| 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 | AKTNR | Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | No | WAKH | WAKTION | Allow NULL? |
| 3 | CLINT | Internal Class Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | KLAH | CLINT | Allow NULL? |
| 4 | AVKVO | Start of promotion sales | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_AVKVO | Allow NULL? |
| 5 | AVKBI | End of promotion sales - IS-R | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_AVKBI | Allow NULL? |
| 6 | ALIVO | Start of promotion listing | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_ALIVO | Allow NULL? |
| 7 | ALIBI | End of promotion listing | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_ALIBI | Allow NULL? |
| 8 | AWEFI | Goods receipt promotional merchandise in plant | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_AWEFI | Allow NULL? |
| 9 | ETIAG | IS-R Labeling: material grouping (deactivated in 4.0) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | TWEA | W_ETIAG | Allow NULL? |
| 10 | BEKTY | Promotion announcement category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T626 | W_BEKTY | Allow NULL? |
| 11 | ABEKM | Announcement date of the promotion | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_ABEKM | Allow NULL? |
| 12 | STBEK | Promotion announcement status | char | 1 | 0 | CHAR | (N' ') | No | | W_STBEK | Allow NULL? |
| 13 | RUDAT | Latest date for replying to promotion announcement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_RUDAT | Allow NULL? |
| 14 | NBSZO | No. of plant group to module assignments | smallint | 5 | 0 | INT2 | ((0)) | No | | W_NBSZO | |
| 15 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 16 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 17 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 18 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AEDAT | Allow NULL? |
| 19 | FADAT | Earliest Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_FADAT | Allow NULL? |
| 20 | SADAT | Latest Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_SADAT | Allow NULL? |
| 21 | FLDAT | Earliest delivery date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_FLDAT | Allow NULL? |
| 22 | SLDAT | Latest delivery date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_SLDAT | Allow NULL? |
| 23 | KLART | Class type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TWRF16 | W_KLART | Allow NULL? |
| 24 | VLGNR | Customer no. of reference plant | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | W_VLGNR | Allow NULL? |
| 25 | VKORG | Sales organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | W_VERKORG | Allow NULL? |
| 26 | VTWEG | Distribution channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVKOV | W_VERTWEG | Allow NULL? |
| 27 | KALKE | Activation type for sales prices | char | 1 | 0 | CHAR | (N' ') | Yes | | W_AKTART | Allow NULL? |
| 28 | STPLGR | Status of Plant Group | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_STPLGR | Allow NULL? |
