| 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 | | ABELN | Allow NULL? |
| 3 | AUFAR | Allocation Table Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T620 | AUFAR | Allow NULL? |
| 4 | BEZCH | Description | nvarchar | 40 | 0 | CHAR | (N' ') | No | | BEZEI40 | Allow NULL? |
| 5 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 6 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024 | EKGRP | Allow NULL? |
| 7 | ASTAK | Activity status allocation tbl (header) | char | 1 | 0 | CHAR | (N' ') | No | | ASTAK | Allow NULL? |
| 8 | PSTAK | Maintenance status of allocation table | char | 1 | 0 | CHAR | (N' ') | No | | PSTAK | Allow NULL? |
| 9 | SPERR | Blocking flag: allocation table | char | 1 | 0 | CHAR | (N' ') | No | T629 | SPKPF | 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 | LEPOS | Last item number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | * | LEPOS | Allow NULL? |
| 15 | PINCR | Item Number Interval | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | PINCR | Allow NULL? |
| 16 | AFDAT | Confirmation request date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AFIDT | Allow NULL? |
| 17 | AFDTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 18 | FBDAT | Release date of PO generation | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FBIDT | Allow NULL? |
| 19 | FBDTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 20 | FLDAT | Release date for generation of delivery note | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FLIDT | Allow NULL? |
| 21 | FLDTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 22 | FUDAT | Release date for generation of stock transfer | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FUIDT | Allow NULL? |
| 23 | FUDTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 24 | VKSDT | Date of start of sales at plant | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | VKIDT | Allow NULL? |
| 25 | VKSTP | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | No | | PRGRS | Allow NULL? |
| 26 | RFCDEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 27 | ERVON | Application creating allocation table | char | 1 | 0 | CHAR | (N' ') | Yes | | ERVON | Allow NULL? |