| 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 | ABELG | Sub-item no. of plant group (alloc tbl) | nvarchar | 5 | 0 | NUMC | (N'00000') | No | AUFG | ABELG | Allow NULL? |
| 5 | ABELF | Sub.item no. of plant (alloc. tbl) | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | ABELF | Allow NULL? |
| 6 | FILNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNNR | Allow NULL? |
| 7 | FIWRK | Store as plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | FIWRK | Allow NULL? |
| 8 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 9 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024 | EKGRP | Allow NULL? |
| 10 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 11 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AEDAT | Allow NULL? |
| 12 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 13 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 14 | LFNRU | Account no. of vendor / creditor of sub-item | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | LFNRU | Allow NULL? |
| 15 | PMNGU | Planned qty of sub-item | decimal | 13 | 3 | QUAN | ((0)) | No | | PMNGU | |
| 16 | IMNGU | Confirmed qty of plant | decimal | 13 | 3 | QUAN | ((0)) | No | | IMNGU | |
| 17 | MMNGU | Minimum Quantity of Plant in Plant Group | decimal | 13 | 3 | QUAN | ((0)) | No | | MMNGU | |
| 18 | WMNGE | Quantity requested by store | decimal | 13 | 3 | QUAN | ((0)) | No | | WMNGE | |
| 19 | AUFME | Allocation Unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | AUFME | Allow NULL? |
| 20 | LIEFW | Flag: delivery phase exists | char | 1 | 0 | CHAR | (N' ') | No | | LIEFW | Allow NULL? |
| 21 | EBLNU | Purchase Order Generated for Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | EBLNU | Allow NULL? |
| 22 | EBLPU | Generated purchase order item | nvarchar | 5 | 0 | NUMC | (N'00000') | No | * | EBLPU | Allow NULL? |
| 23 | UBSTN | Generated warehouse order | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | UBSTN | Allow NULL? |
| 24 | UBSTP | Generated stock transport order item | nvarchar | 5 | 0 | NUMC | (N'00000') | No | * | UBSTP | Allow NULL? |
| 25 | VBLNU | Generated delivery number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBLNU | Allow NULL? |
| 26 | VBLPU | Generated delivery note item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | VBLPU | Allow NULL? |
| 27 | BEDAT | Purchase Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEDAT | Allow NULL? |
| 28 | BEDTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 29 | VKDAT | Date of start of sales at plant | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VKIDT | Allow NULL? |
| 30 | VKTYP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 31 | LEWED | Latest Possible Goods Receipt | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LEWED | Allow NULL? |
| 32 | VZENT | Distribution center (as customer) | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | VZENT | Allow NULL? |
| 33 | VZWRK | Distribution center as plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | VZWRK | Allow NULL? |
| 34 | VZLFR | Vendor number of plant | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR_WK | Allow NULL? |
| 35 | AAVIT | Notification Category Allocation: Info Exchance HQ - Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T626 | AAVIT | Allow NULL? |
| 36 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | PLIFZ | |
| 37 | WEBAZ | Goods Receipt Processing Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | WEBAZ | |
| 38 | ABFDT | Confirmation request date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AFIDT | Allow NULL? |
| 39 | ABFTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | Yes | | PRGRS | Allow NULL? |
| 40 | PSTAB | Maint. status of plant | char | 1 | 0 | CHAR | (N' ') | Yes | | PSTAB | Allow NULL? |
| 41 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 42 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 43 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 44 | BSTMG | Purchase Order Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG | |
| 45 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BSTME | Allow NULL? |
| 46 | UMLMG | Purchase Order Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG | |
| 47 | UMLME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BSTME | Allow NULL? |
| 48 | LFMNG | GR qty assigned after alloc tbl adjustment made | decimal | 13 | 3 | QUAN | ((0)) | Yes | | EFMNG | |
| 49 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 50 | SPERR | Blocking flag, plant | char | 1 | 0 | CHAR | (N' ') | Yes | T629 | SPBTR | Allow NULL? |
| 51 | VQUOT | Quotas (Base for qty calculation) | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | Yes | | VQUOT | Allow NULL? |
| 52 | WMERF | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 53 | BMERF | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 54 | BEWZA | Evaluation figure of plant | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | Yes | | UPOBZ | Allow NULL? |
| 55 | LABST | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LABST | |
| 56 | HMNGU | Maximum Quantity for Plants in Plant Group | decimal | 13 | 3 | QUAN | ((0)) | Yes | | HMNGU | |
| 57 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 58 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 59 | ELIKZ | "Delivery Completed" Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ELIKZ | Allow NULL? |
| 60 | LGORT | Storage Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | LGORT_D | Allow NULL? |
| 61 | ABFST | Status plant notification | char | 1 | 0 | CHAR | (N' ') | Yes | | ABFST | Allow NULL? |
| 62 | ABAST | Details status, plant notification | char | 1 | 0 | CHAR | (N' ') | Yes | | ABAST | Allow NULL? |
| 63 | BLGTP | Doc.Cat. for Follow-On Doc. to be Generated in Alloc. Tble | char | 1 | 0 | CHAR | (N' ') | Yes | | BLGTP | Allow NULL? |
| 64 | EXPECTED_SALES | Evaluation figure of plant | nvarchar | 13 | 0 | NUMC | (N'0000000000000') | Yes | | UPOBZ | Allow NULL? |
| 65 | OPEN_ORDERS | Purchase Order Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BSTMG | |
| 66 | TREND_FACTOR | Trend Factor | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TREND_ALL | Allow NULL? |