| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VBELN | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN_VA | Allow NULL? |
| 3 | POSNR | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR_VA | Allow NULL? |
| 4 | ETENR | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | * | ETENR | Allow NULL? |
| 5 | ETTYP | Schedule line category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVEP | ETTYP | Allow NULL? |
| 6 | LFREL | Item is relevant for delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | LFREL | Allow NULL? |
| 7 | EDATU | Schedule line date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EDATU | Allow NULL? |
| 8 | EZEIT | Arrival time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | EZEIT_VBEP | Allow NULL? |
| 9 | WMENG | Order quantity in sales units | decimal | 13 | 3 | QUAN | ((0)) | Yes | | WMENG | |
| 10 | BMENG | Confirmed Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BMENG | |
| 11 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 12 | LMENG | Required quantity for mat.management in stockkeeping units | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LMENG | |
| 13 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 14 | BDDAT | Requirement date (deadline for procurement) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDDAT | Allow NULL? |
| 15 | BDART | Requirement type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BDART | Allow NULL? |
| 16 | PLART | Planning type | char | 1 | 0 | CHAR | (N' ') | Yes | * | PLART | Allow NULL? |
| 17 | VBELE | Business document number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELE | Allow NULL? |
| 18 | POSNE | Business item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | VBUP | POSNE | Allow NULL? |
| 19 | ETENE | Schedule line | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | VBEP | ETENE | Allow NULL? |
| 20 | RSDAT | Earliest possible reservation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RSDAT | Allow NULL? |
| 21 | IDNNR | Maintenance request | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | IDNNR | Allow NULL? |
| 22 | BANFN | Purchase Requisition Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BANFN | Allow NULL? |
| 23 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T161 | BSART | Allow NULL? |
| 24 | BSTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTYP | Allow NULL? |
| 25 | WEPOS | Confirmation status of schedule line (incl.ALE) | char | 1 | 0 | CHAR | (N' ') | Yes | | WEPOS_A | Allow NULL? |
| 26 | REPOS | Invoice Receipt Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | REPOS | Allow NULL? |
| 27 | LRGDT | Return date for returnable packaging | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LRGDT | Allow NULL? |
| 28 | PRGRS | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | Yes | | PRGRS | Allow NULL? |
| 29 | TDDAT | Transportation Planning Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TDDAT_D | Allow NULL? |
| 30 | MBDAT | Material Staging/Availability Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MBDAT | Allow NULL? |
| 31 | LDDAT | Loading Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LDDAT | Allow NULL? |
| 32 | WADAT | Goods Issue Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WADAT | Allow NULL? |
| 33 | CMENG | Corrected quantity in sales unit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | CMENG | |
| 34 | LIFSP | Schedule line blocked for delivery | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVLS | LIFSP_EP | Allow NULL? |
| 35 | GRSTR | Group definition of structure data | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | GRSTR | Allow NULL? |
| 36 | ABART | Release type | char | 1 | 0 | CHAR | (N' ') | Yes | | ABART | Allow NULL? |
| 37 | ABRUF | Forecast Delivery schedule number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ABRUF | Allow NULL? |
| 38 | ROMS1 | Committed quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | DCQNT | |
| 39 | ROMS2 | Size 2 | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ROMS2 | |
| 40 | ROMS3 | Size 3 | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ROMS3 | |
| 41 | ROMEI | Unit of measure for sizes 1 to 3 | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | ROMEI | Allow NULL? |
| 42 | RFORM | Formula key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RFORM | Allow NULL? |
| 43 | UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMVKZ | |
| 44 | UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMVKN | |
| 45 | VERFP | Availability confirmed automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | VERFP_MAS | Allow NULL? |
| 46 | BWART | Movement Type (Inventory Management) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | BWART | Allow NULL? |
| 47 | BNFPO | Item Number of Purchase Requisition | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | EBAN | BNFPO | Allow NULL? |
| 48 | ETART | Schedule line type EDI | char | 1 | 0 | CHAR | (N' ') | Yes | TVET | EDI_ETTYP | Allow NULL? |
| 49 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | AUFNR | Allow NULL? |
| 50 | PLNUM | Planned order number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | PLAF | PLNUM | Allow NULL? |
| 51 | SERNR | BOM explosion number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | SNUM | SERNR | Allow NULL? |
| 52 | AESKD | Customer Engineering Change Status | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | AESKD | Allow NULL? |
| 53 | ABGES | Guaranteed (factor between 0 and 1) | float | 15 | 16 | FLTP | ((0)) | Yes | | ABGES_CM | |
| 54 | MBUHR | Material Staging Time (Local, Relating to a Plant) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | MBUHR | Allow NULL? |
| 55 | TDUHR | Transp. Planning Time (Local, Relating to a Shipping Point) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TDUHR | Allow NULL? |
| 56 | LDUHR | Loading Time (Local Time Relating to a Shipping Point) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LDUHR | Allow NULL? |
| 57 | WAUHR | Time of Goods Issue (Local, Relating to a Plant) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | WAUHR | Allow NULL? |
| 58 | AULWE | Route Schedule | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VALW | AULWE | Allow NULL? |
| 59 | HANDOVERDATE | Handover Date at the Handover Location | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HANDOVER_DATE | Allow NULL? |
| 60 | HANDOVERTIME | Handover time at the handover location | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | HANDOVER_TIME | Allow NULL? |
| 61 | MBDAT_DRS | Material Availability Date Third-Party Order Planning | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MBDAT_DRS | Allow NULL? |
