|
|
SQL 
Others / 
Schedule Row Detail
API ODSL
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ObjType KEY | Object Type | nVarChar | -1) 13) A/R Reserve Invoice 17) Sales Order 18) A/P Reserve Invoice 22) Purchase Order 163) A/P Correction Reserve Invoice 165) A/R Correction Reserve Invoice 202) Production Order 1250000001) Warehouse Transfer Request | 20 | -1 | DOCLINESLD | No | |
| DocEntry | Associated Doc. Entry | Int | 11 | |||||
| DocLineNum | Associated Doc Row No. | Int | 11 | |||||
| SchdLine | Schedule Row No. | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| CfmDate | Confirmation Date | Date | 8 | |||||
| CfmQty | Confirmation Quantity | Num | 20 | |||||
| FixedCfm | Fixed Confirmation Data | VarChar | Y) Yes N) No | 1 | N | |||
| ReqQty | Required Quantity | Num | 20 |
Table relationship map
SELECT statement
SELECT
ODSL.AbsEntry AS 'Internal Number',
ODSL.ObjType AS 'Object Type',
ODSL.DocEntry AS 'Associated Doc. Entry',
ODSL.DocLineNum AS 'Associated Doc Row No.',
ODSL.SchdLine AS 'Schedule Row No.',
ODSL.ItemCode AS 'Item Code',
ODSL.WhsCode AS 'Warehouse Code',
ODSL.CfmDate AS 'Confirmation Date',
ODSL.CfmQty AS 'Confirmation Quantity',
ODSL.FixedCfm AS 'Fixed Confirmation Data',
ODSL.ReqQty AS 'Required Quantity'
FROM ODSL AS ODSL
Related information
Items OITM SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates