| 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 | ETENR | Delivery Schedule Line Counter | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | EINDT | Item Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | SLFDT | Statistics-Relevant Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | LPEIN | Category of Delivery Date | char | 1 | 0 | | | | Allow NULL? |
| 8 | MENGE | Scheduled Quantity | decimal | 13 | 3 | | | | |
| 9 | AMENG | Previous Quantity (Delivery Schedule Lines) | decimal | 13 | 3 | | | | |
| 10 | WEMNG | Quantity of Goods Received | decimal | 13 | 3 | | | | |
| 11 | WAMNG | Issued Quantity | decimal | 13 | 3 | | | | |
| 12 | UZEIT | Delivery Date Time-Spot | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | BANFN | Purchase Requisition Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | BNFPO | Item Number of Purchase Requisition | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | char | 1 | 0 | | | | Allow NULL? |
| 16 | QUNUM | Number of Quota Arrangement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | QUPOS | Quota Arrangement Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | MAHNZ | No. of Reminders/Expediters for Schedule Line | decimal | 3 | 0 | | | | |
| 19 | BEDAT | Order date of schedule line | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | RSNUM | Number of Reservation/Dependent Requirement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | SERNR | BOM explosion number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | FIXKZ | Schedule Line is "Fixed" | char | 1 | 0 | | | | Allow NULL? |
| 23 | GLMNG | Quantity Delivered (Stock Transfer) | decimal | 13 | 3 | | | | |
| 24 | DABMG | Quantity Reduced (MRP) | decimal | 13 | 3 | | | | |
| 25 | CHARG | Batch Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 27 | CHKOM | Components | char | 1 | 0 | | | | Allow NULL? |
| 28 | VERID | Production Version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | ABART | Scheduling agreement release type | char | 1 | 0 | | | | Allow NULL? |
| 30 | MNG02 | Committed Quantity | decimal | 13 | 3 | | | | |
| 31 | DAT01 | Committed Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | ALTDT | Previous delivery date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | AULWE | Route Schedule | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | MBDAT | Material Staging/Availability Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | MBUHR | Material Staging Time (Local, Relating to a Plant) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 36 | LDDAT | Loading Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | LDUHR | Loading Time (Local Time Relating to a Shipping Point) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | TDDAT | Transportation Planning Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | TDUHR | Transp. Planning Time (Local, Relating to a Shipping Point) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 40 | WADAT | Goods Issue Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | WAUHR | Time of Goods Issue (Local, Relating to a Plant) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | ELDAT | Goods Receipt End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | ELUHR | Goods Receipt End Time (Local, Relating to a Plant) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 44 | ANZSN | Number of serial numbers | int | 10 | 0 | | | | Allow NULL? |
| 45 | NODISP | Ind: Reserv. not applicable to MRP;Purc. req. not created | char | 1 | 0 | | | | Allow NULL? |
| 46 | GEO_ROUTE | Description of a Geographical Route | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | ROUTE_GTS | Route Code for SAP Global Trade Services | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | GTS_IND | Goods Traffic Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 49 | TSP | Forwarding agent | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | CD_LOCNO | Location number in APO | nvarchar | 20 | 0 | | | | Allow NULL? |
| 51 | CD_LOCTYPE | APO location type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | HANDOVERDATE | Handover Date at the Handover Location | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | HANDOVERTIME | Handover time at the handover location | nvarchar | 6 | 0 | | | | Allow NULL? |
