| 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 | ABELN | Allocation Table Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | AUKO | ABELN | Allow NULL? |
| 3 | ABELP | Item number of allocation table | nvarchar | 5 | 0 | NUMC | (N'00000') | No | AUPO | ABELP | Allow NULL? |
| 4 | VZWRK | Distribution center as plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | VZWRK | Allow NULL? |
| 5 | VZENT | Distribution center (as customer) | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | VZENT | Allow NULL? |
| 6 | VZLFR | Vendor number of plant | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR_WK | Allow NULL? |
| 7 | PMNGV | Planned GR qty Distribution Center | decimal | 13 | 3 | QUAN | ((0)) | No | | PMNGV | |
| 8 | IMNGV | Confirmed quantity, Distribution Center | decimal | 13 | 3 | QUAN | ((0)) | No | | IMNGV | |
| 9 | MENGE_OPT | Optimized quantity | decimal | 13 | 3 | QUAN | ((0)) | No | | MENGE_OPT | |
| 10 | AUFME | Allocation Unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | AUFME | Allow NULL? |
| 11 | LIFNR | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | ELIFN | Allow NULL? |
| 12 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 13 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 14 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPART | Allow NULL? |
| 15 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | PLIFZ | |
| 16 | WEBAZ | Goods Receipt Processing Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | WEBAZ | |
| 17 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 18 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024 | EKGRP | Allow NULL? |
| 19 | BSTMG | Purchase Order Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG | |
| 20 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BSTME | Allow NULL? |
| 21 | UMLMG | Reduced DC order quantity (in allocation table) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG_RED | |
| 22 | UMLME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BSTME | Allow NULL? |
| 23 | LFMNG | GR qty assigned after alloc tbl adjustment made | decimal | 13 | 3 | QUAN | ((0)) | Yes | | EFMNG | |
| 24 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 25 | EBLNU | Purchase Order Generated for Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBLNU | Allow NULL? |
| 26 | EBLPU | Generated purchase order item | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBLPU | Allow NULL? |
| 27 | ABFST | Status plant notification | char | 1 | 0 | CHAR | (N' ') | Yes | | ABFST | Allow NULL? |
| 28 | ABAST | Details status, plant notification | char | 1 | 0 | CHAR | (N' ') | Yes | | ABAST | Allow NULL? |
| 29 | BSTST | Status: Vendor Purchase Order Generation | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTST | Allow NULL? |
| 30 | UMLST | Status: warehouse order generation | char | 1 | 0 | CHAR | (N' ') | Yes | | UMLST | Allow NULL? |
| 31 | LIEST | Status: generate deliveries | char | 1 | 0 | CHAR | (N' ') | Yes | | LIEST | Allow NULL? |
| 32 | ABVST | Notification status (DC) | char | 1 | 0 | CHAR | (N' ') | Yes | | ABVST | Allow NULL? |
| 33 | WEEST | Entry status of GR in DC | char | 1 | 0 | CHAR | (N' ') | Yes | | WEEST | Allow NULL? |
| 34 | KAGST | Status of sales order generation | char | 1 | 0 | CHAR | (N' ') | Yes | | KAGST | Allow NULL? |
| 35 | SPERR | Blocking flag, plant | char | 1 | 0 | CHAR | (N' ') | Yes | T629 | SPBTR | Allow NULL? |
| 36 | BMERF | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 37 | ELIKZ | "Delivery Completed" Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ELIKZ | Allow NULL? |
| 38 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 39 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 40 | WAFLU_VZ | Processing Method / Goods Movement in Distribution Center | char | 1 | 0 | CHAR | (N' ') | Yes | | WAFLU_VZ | Allow NULL? |
| 41 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | LGORT_D | Allow NULL? |
| 42 | SLS_REL | Single-Recipient Vendor Orders from Allocation Table | char | 1 | 0 | CHAR | (N' ') | Yes | | SLS_REL | Allow NULL? |
