| 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 | DL_ID | Date Line ID (GUID) | nvarchar | 22 | 0 | | | | Allow NULL? |
| 6 | FOLDER_ID | Key of an Activity Folder | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 14 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 15 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | HANDOVER_DATE | Transfer Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | EINDT | Item Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | DL_STATUS | Status of PO Item in Purchase Order Monitoring Reacting | char | 1 | 0 | | | | Allow NULL? |
| 19 | NETWR | Net Order Value in PO Currency | decimal | 13 | 2 | | | | |
| 20 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | NOTE_ACTIVITY | Activity Carried Out | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | ACTIVITY_ID | Activity To Be Executed | tinyint | 3 | 0 | | | | |
| 23 | DATESHIFT_ALWD | Indicator: Date Shift Allowed | char | 1 | 0 | | | | Allow NULL? |
| 24 | DUNNING_ALWD | Indicator: Reminder Allowed | char | 1 | 0 | | | | Allow NULL? |
| 25 | CNCL_ANCMT_ALWD | Indicator: Cancellation Threat Allowed | char | 1 | 0 | | | | Allow NULL? |
| 26 | CANCELATION_ALWD | Indicator: Cancellation Allowed | char | 1 | 0 | | | | Allow NULL? |
| 27 | ACTIVITY_MODE | Describes the Mode in Which Activity Is To Be Executed | char | 1 | 0 | | | | Allow NULL? |
| 28 | ORIGIN_DATE_ID | Triggering Date | nvarchar | 18 | 0 | | | | Allow NULL? |
| 29 | PROCESSING_TYPE | Procurement Controlling: Processing Type Remaining Quantity | char | 1 | 0 | | | | Allow NULL? |
| 30 | QTY_MONITOR | Monitor Quantity Variance | char | 1 | 0 | | | | Allow NULL? |
| 31 | QTY_OVERDEL | Monitor Overdelivery | char | 1 | 0 | | | | Allow NULL? |
| 32 | QTY_UNDERDEL | Monitor Underdelivery | char | 1 | 0 | | | | Allow NULL? |
| 33 | REM_QTY_AUTO | Process Remaining Quantity Automatically | char | 1 | 0 | | | | Allow NULL? |
| 34 | DISTANCE | Total Interval | decimal | 3 | 0 | | | | |
| 35 | STAT_DAT_SHIFT | Indicator: Shift Statistical Date | char | 1 | 0 | | | | Allow NULL? |
| 36 | DELAYED | Late Execution of the Activity from the Calling System | char | 1 | 0 | | | | Allow NULL? |
| 37 | DATESHIFT_NUMBER | Number of Current Date Shifts | decimal | 3 | 0 | | | | |
| 38 | CLOSING_INDICATR | Completion Indicator for Worklist | char | 1 | 0 | | | | Allow NULL? |
| 39 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 40 | UNAME | User Name in User Master Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 41 | PROGRAMM | ABAP Program Name | nvarchar | 40 | 0 | | | | Allow NULL? |
