| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | ABART | Scheduling agreement release type | char | 1 | 0 | | | | Allow NULL? |
| 5 | ABRUF | Release Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ETENR | Delivery Schedule Line Counter | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | EINDT | Item Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | LPEIN | Category of Delivery Date | char | 1 | 0 | | | | Allow NULL? |
| 9 | UZEIT | Delivery Date Time-Spot | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | MENGE | Scheduled Quantity | decimal | 13 | 3 | | | | |
| 11 | ETART | Schedule line type (backlog, immed. requirement, forecast) | char | 1 | 0 | | | | Allow NULL? |
| 12 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | char | 1 | 0 | | | | Allow NULL? |
| 14 | AMENG | Previous Quantity (Delivery Schedule Lines) | decimal | 13 | 3 | | | | |
| 15 | WEMNG | Quantity of Goods Received | decimal | 13 | 3 | | | | |