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