| 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 | | WAKTION | Allow NULL? |
| 3 | AKTYP | Promotion Category | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWTY | W_AKTYP | Allow NULL? |
| 4 | AKART | Promotion Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWAA | W_AKART | Allow NULL? |
| 5 | WAELA | Currency current promotion - planning | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | W_WAELA | Allow NULL? |
| 6 | WAERA | Currency, reference promotion | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | W_WAERA | Allow NULL? |
| 7 | VGLAK | Comparative promotion | nvarchar | 10 | 0 | CHAR | (N' ') | No | WAKH | W_VGLAK | Allow NULL? |
| 8 | LISRE | Listing procedure for store or other assortment categories | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWLV | LSTFL | Allow NULL? |
| 9 | AUFAR | Allocation Table Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T620 | W_AUFAR | Allow NULL? |
| 10 | BEKTY | Promotion announcement category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T626 | W_BEKTY | Allow NULL? |
| 11 | KSBEK | Message Schema | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | W_NACHSM | Allow NULL? |
| 12 | AKVST | Processing status of the promotion | char | 1 | 0 | CHAR | (N' ') | No | | W_AKVST | Allow NULL? |
| 13 | AKAST | Allocation table status of the promotion | char | 1 | 0 | CHAR | (N' ') | No | | W_AKAST | Allow NULL? |
| 14 | AKBST | Listing Status of the Promotion | char | 1 | 0 | CHAR | (N' ') | No | | W_AKBST | Allow NULL? |
| 15 | VKGST | Price activation status | char | 1 | 0 | CHAR | (N' ') | Yes | | W_VKKPSH | Allow NULL? |
| 16 | EKGST | Purchase price activation status at promotion header level | char | 1 | 0 | CHAR | (N' ') | Yes | | W_EKKPSH | Allow NULL? |
| 17 | BEKST | Promotion announcement status | char | 1 | 0 | CHAR | (N' ') | Yes | | W_STBEK | Allow NULL? |
| 18 | AKNBS | No. assigned listing modules | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNBS | |
| 19 | AKNFG | Promotion: no. of plant groups | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNFG | |
| 20 | AKNBF | No. of module-plant group assignments | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNBF | |
| 21 | AKNTH | Promotion, no. of themes | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNTH | |
| 22 | AKNPO | No. of items with allocation qty > 0 | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNPO | |
| 23 | AKNWM | No. of product catalogs in promotion | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNWM | |
| 24 | AKNTX | No. of foreign language texts | smallint | 5 | 0 | INT2 | ((0)) | No | | W_AKNTX | |
| 25 | NEKKO | No. of purchase prices maintained via price calcul. (KONP) | smallint | 5 | 0 | INT2 | ((0)) | No | | W_NEKKO | |
| 26 | NVKKO | No. of sales prices maintained via price calculation (KONP) | smallint | 5 | 0 | INT2 | ((0)) | No | | W_NVKKO | |
| 27 | NARTS | No. of blocked materials | smallint | 5 | 0 | INT2 | ((0)) | No | | W_NARTS | |
| 28 | ATNPO | Number of promo materials in generated allocation tables | smallint | 5 | 0 | INT2 | ((0)) | No | | W_ATNPO | |
| 29 | VTART | Check Against Listing Rules/Listing Conditions | char | 1 | 0 | CHAR | (N' ') | No | | W_LCHECK | Allow NULL? |
| 30 | EKDAB | Purchase price conditions valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_EKDAB | Allow NULL? |
| 31 | EKDBI | Purchase price conditions valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_EKDBI | Allow NULL? |
| 32 | VKDAB | On Sale to Consumers From | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_VKDAB | Allow NULL? |
| 33 | VKDBI | On Sale To Consumers To | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_VKDBI | Allow NULL? |
| 34 | ALIVO | Start of promotion listing | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_ALIVO | Allow NULL? |
| 35 | ALIBI | End of promotion listing | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_ALIBI | Allow NULL? |
| 36 | SPDAB | Promotion blocked on | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | W_SPDAB | Allow NULL? |
| 37 | SPGRU | Reason for promotion block | char | 1 | 0 | CHAR | (N' ') | No | | W_SPGRU | Allow NULL? |
| 38 | EKKON | Create purchase price condition records | char | 1 | 0 | CHAR | (N' ') | Yes | | W_EKKON | Allow NULL? |
| 39 | VKKON | Create sales price condition records | char | 1 | 0 | CHAR | (N' ') | Yes | | W_VKKON | Allow NULL? |
| 40 | KOBOG | Group of condition types/tables for purchasing conditions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | W_KOBOG | Allow NULL? |
| 41 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | T024E | EKORG | Allow NULL? |
| 42 | EKGRP | Purchasing Group - Promotion Header | nvarchar | 3 | 0 | CHAR | (N' ') | No | T024 | W_EKGRP | Allow NULL? |
| 43 | VKORG | Sales Organization: Promotion Header | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | W_VKORG_HEADER | Allow NULL? |
| 44 | VTWEG | Distribution Channel: Promotion Header | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVKOV | W_VTWEG_HEADER | Allow NULL? |
| 45 | PLUEP | Promotion plan, sales at purchase price | decimal | 13 | 2 | CURR | ((0)) | No | | W_PLUEP | |
| 46 | PLUEN | Planned sales qty for promo at delivered price (net/net) | decimal | 13 | 2 | CURR | ((0)) | Yes | | W_PLUEN | |
| 47 | PLUVP | Promotion Plan Sales Volume at Promo. Sales Prices | decimal | 13 | 2 | CURR | ((0)) | No | | W_PLUVP | |
| 48 | PLMGE | Promotion plan, no. logistics units | decimal | 13 | 3 | QUAN | ((0)) | No | | W_PLMGE | |
| 49 | PLANZ | Promotion plan, no. of materials | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | W_PLANZ | Allow NULL? |
| 50 | MELAK | Logistics unit, promotion plan | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | W_MELAK | Allow NULL? |
| 51 | MELRA | Logistics units, reference promotion | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | W_MELRA | Allow NULL? |
| 52 | PDUEP | Detailed promotion plan, sales volume at purchase price | decimal | 13 | 2 | CURR | ((0)) | No | | W_PDUEP | |
| 53 | PDUEN | Planned sales qty at delivered price (net/net) | decimal | 13 | 2 | CURR | ((0)) | Yes | | W_PDUEN | |
| 54 | PDUVP | Detailed Promotion Plan Sales Volume at Promo. Sales Price | decimal | 13 | 2 | CURR | ((0)) | No | | W_PDUVP | |
| 55 | PDMGE | Detailed promotion plan, no. of logistics units | decimal | 13 | 3 | QUAN | ((0)) | No | | W_PDMGE | |
| 56 | PDANZ | Detailed Promotion Plan, Number of Materials | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | W_PDANZ | Allow NULL? |
| 57 | VAUEP | Sales volume at purchase price for comparative promotion | decimal | 13 | 2 | CURR | ((0)) | No | | W_VAUEP | |
| 58 | VAUEN | Comparative promotion: sales vol.at delivered price(net/net) | decimal | 13 | 2 | CURR | ((0)) | Yes | | W_VAUEN | |
| 59 | VAUVP | Sales volume of comparative promotion at sales prices | decimal | 13 | 2 | CURR | ((0)) | No | | W_VAUVP | |
| 60 | VAMGE | No. of log. units in comparative promotion | decimal | 13 | 3 | QUAN | ((0)) | No | | W_VAMGE | |
| 61 | RFIND | External description for agreement | nvarchar | 20 | 0 | CHAR | (N' ') | No | | ABREX | Allow NULL? |
| 62 | VAANZ | No. of materials/units of measure in comparative promotion | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | W_VAANZ | Allow NULL? |
| 63 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 64 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 65 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 66 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AEDAT | Allow NULL? |
| 67 | KOBVK | Group of condition types/tables for sales price conditions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | W_KOBVK | Allow NULL? |
| 68 | FADAT | Earliest Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_FADAT | Allow NULL? |
| 69 | SADAT | Latest Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_SADAT | Allow NULL? |
| 70 | FLDAT | Earliest delivery date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_FLDAT | Allow NULL? |
| 71 | SLDAT | Latest delivery date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_SLDAT | Allow NULL? |
| 72 | ADDIBELNR | Document number for additional | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ADDI_BELNR | Allow NULL? |
| 73 | VZKON | Create DC condition records | char | 1 | 0 | CHAR | (N' ') | Yes | | W_VZKON | Allow NULL? |
| 74 | KALKE | Activation type for sales prices | char | 1 | 0 | CHAR | (N' ') | Yes | | W_AKTARTH | Allow NULL? |
| 75 | PLTYP | Price list type: promotion header | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T189 | W_PLTYP | Allow NULL? |
| 76 | NO_KALK | Price Activation w/o Price Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | NO_KALK | Allow NULL? |
| 77 | EKERV | Promotion: Purchase price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWEV | W_EKERV | Allow NULL? |
| 78 | RFCDEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 79 | ERAPPL | Application that Created the Promotion | char | 1 | 0 | CHAR | (N' ') | Yes | | W_ERAPPL | Allow NULL? |
| 80 | KSCHL_PERC | Condition Type Percentage Discount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | KSCHL_PERC | Allow NULL? |
| 81 | KSCHL_VAL | Condition Type Absolute Discount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | KSCHL_VAL | Allow NULL? |
| 82 | PLUNP | Promotion Plan Invoiced Sales at Standard Sales Prices | decimal | 13 | 2 | CURR | ((0)) | Yes | | W_PLUNP | |
| 83 | PLURE | Promotion Plan Gross Revenue | decimal | 13 | 2 | CURR | ((0)) | Yes | | W_PLURE | |
| 84 | PLULO | Promotion Plan Invoiced Lost Sales | decimal | 13 | 2 | CURR | ((0)) | Yes | | W_PLULO | |
| 85 | MEDIA_TYPE | Media Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | RDMT_MED_TYPE | RDM_MEDIA_TYPE | Allow NULL? |
| 86 | CUSTOMER_TYPE | Customer Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | RDMT_CUST_TYPE | RDM_CUSTOMER_TYPE | Allow NULL? |
| 87 | ALLOW_PMAT_IGNO | Variant Price Allowed (for Promotion Type) | char | 1 | 0 | CHAR | (N' ') | Yes | | WPM_ALLOW_PMAT_IGNO_PROMO | Allow NULL? |
| 88 | ITEMS_4_BBY | Control of Subsequent Processing of Bonus Buy Materials | char | 1 | 0 | CHAR | (N' ') | Yes | | WPM_ITEMS_4_BBYS | Allow NULL? |
| 89 | ALLOW_DISP_MAT | Addition of Display Materials Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | WPM_ALLOW_DISP_MAT | Allow NULL? |
| 90 | INIT_SLS_PRICE | Allow Initial Sales Price in Price Activation | char | 1 | 0 | CHAR | (N' ') | Yes | | WPM_ALLOW_INITIAL_SLS_PRICE | Allow NULL? |
| 91 | REF_PROMO | Higher-Level Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | WAKH | WAKTPP_REF_PROMO | Allow NULL? |
| 92 | CGPL_GUID | CGPL Project GUID | varbinary | 16 | 0 | RAW | | Yes | | WAKTPP_CGPL_GUID | |
| 93 | EXTERNAL_ID | CGPL Project External ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | WAKTPP_CGPL_EXTID | Allow NULL? |
| 94 | IS_REF_PROMO | Indicator: Higher-Level Promotion | char | 1 | 0 | CHAR | (N' ') | Yes | | WAKTPP_IS_REF_PROMO | Allow NULL? |
| 95 | BEKST2 | Status of New Announcement | char | 1 | 0 | CHAR | (N' ') | Yes | | WAKTPP_STBEK2 | Allow NULL? |
| 96 | ERDOCN | Document that Created the Retail Promotion | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WAKTPP_ERDOCN | Allow NULL? |
| 97 | HIER_ID | Hierarchy | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WAKT_HIER_CNT | Allow NULL? |
| 98 | BPROF | Bonus Buy: Bonus buy profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RDM_BBY_BPROF | Allow NULL? |