BIW_WAKH_S SAP (Provider Structure for Promotion Data from WAKH) Structure details
Description: Provider Structure for Promotion Data from WAKH
Structure field list including key, data, relationships and ABAP select examples
BIW_WAKH_S is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Provider Structure for Promotion Data from WAKH" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BIW_WAKH_S TYPE BIW_WAKH_S.
The BIW_WAKH_S table consists of various fields, each holding specific information or linking keys about Provider Structure for Promotion Data from WAKH data available in SAP. These include MANDT (Client), AKTNR (COUPON), AKTYP (Promotion Category), AKART (Promotion Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BIW_WAKH_S structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
AKTYP | Promotion Category | W_AKTYP | CHAR | 4 | TWTY | AKTTY | |||
AKART | Promotion Type | W_AKART | CHAR | 4 | TWAA | W_AKART | WAA | ||
WAELA | Currency current promotion - planning | W_WAELA | CUKY | 5 | TCURC | WAERS | FWS | ||
WAERA | Currency, reference promotion | W_WAERA | CUKY | 5 | TCURC | WAERS | |||
VGLAK | Comparative promotion | W_VGLAK | CHAR | 10 | WAKH | ALPHA | WAKTION | ||
LISRE | Listing procedure for store or other assortment categories | LSTFL | CHAR | 2 | TWLV | LSTFL | WLV | ||
AUFAR | Allocation Table Type | W_AUFAR | CHAR | 4 | T620 | AUFAR | ATG | ||
BEKTY | Promotion announcement category | W_BEKTY | CHAR | 4 | T626 | AAVIT | |||
KSBEK | Message Schema | W_NACHSM | CHAR | 6 | T683 | KALSM | |||
AKVST | Processing status of the promotion | W_AKVST | CHAR | 1 | AKVST | ||||
AKAST | Allocation table status of the promotion | W_AKAST | CHAR | 1 | AKAST | ||||
AKBST | Listing Status of the Promotion | W_AKBST | CHAR | 1 | AKBST | ||||
VKGST | Price activation status | W_VKKPSH | CHAR | 1 | PREISSH | ||||
EKGST | Purchase price activation status at promotion header level | W_EKKPSH | CHAR | 1 | PREISSH | ||||
BEKST | Promotion announcement status | W_STBEK | CHAR | 1 | BEKST | ||||
AKNBS | No. assigned listing modules | W_AKNBS | INT2 | 5 | INT2 | ||||
AKNFG | Promotion: no. of plant groups | W_AKNFG | INT2 | 5 | INT2 | ||||
AKNBF | No. of module-plant group assignments | W_AKNBF | INT2 | 5 | INT2 | ||||
AKNTH | Promotion, no. of themes | W_AKNTH | INT2 | 5 | INT2 | ||||
AKNPO | No. of items with allocation qty > 0 | W_AKNPO | INT2 | 5 | INT2 | ||||
AKNWM | No. of product catalogs in promotion | W_AKNWM | INT2 | 5 | INT2 | ||||
AKNTX | No. of foreign language texts | W_AKNTX | INT2 | 5 | INT2 | ||||
NEKKO | No. of purchase prices maintained via price calcul. (KONP) | W_NEKKO | INT2 | 5 | INT2 | ||||
NVKKO | No. of sales prices maintained via price calculation (KONP) | W_NVKKO | INT2 | 5 | INT2 | ||||
NARTS | No. of blocked materials | W_NARTS | INT2 | 5 | INT2 | ||||
ATNPO | Number of promo materials in generated allocation tables | W_ATNPO | INT2 | 5 | INT2 | ||||
VTART | Check Against Listing Rules/Listing Conditions | W_LCHECK | CHAR | 1 | W_LCHECK | ||||
EKDAB | Purchase price conditions valid from | W_EKDAB | DATS | 8 | DATUM | ||||
EKDBI | Purchase price conditions valid to | W_EKDBI | DATS | 8 | DATUM | ||||
VKDAB | On Sale to Consumers From | W_VKDAB | DATS | 8 | DATUM | ||||
VKDBI | On Sale To Consumers To | W_VKDBI | DATS | 8 | DATUM | ||||
ALIVO | Start of promotion listing | W_ALIVO | DATS | 8 | DATUM | ||||
ALIBI | End of promotion listing | W_ALIBI | DATS | 8 | DATUM | ||||
SPDAB | Promotion blocked on | W_SPDAB | DATS | 8 | DATUM | ||||
SPGRU | Reason for promotion block | W_SPGRU | CHAR | 1 | SPGRU | ||||
EKKON | Create purchase price condition records | W_EKKON | CHAR | 1 | XFELD | ||||
VKKON | Create sales price condition records | W_VKKON | CHAR | 1 | XFELD | ||||
KOBOG | Group of condition types/tables for purchasing conditions | W_KOBOG | CHAR | 4 | CHAR4 | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EKGRP | Purchasing Group - Promotion Header | W_EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
VKORG | Sales Organization: Promotion Header | W_VKORG_HEADER | CHAR | 4 | TVKO | VKORG | VKO | ||
VTWEG | Distribution Channel: Promotion Header | W_VTWEG_HEADER | CHAR | 2 | TVTW | VTWEG | VTW | ||
PLUEP | Promotion plan, sales at purchase price | W_PLUEP | CURR | 13(2) | WERT | ||||
PLUEN | Planned sales qty for promo at delivered price (net/net) | W_PLUEN | CURR | 13(2) | WERT | ||||
PLUVP | Promotion Plan Sales Volume at Promo. Sales Prices | W_PLUVP | CURR | 13(2) | WERT | ||||
PLMGE | Promotion plan, no. logistics units | W_PLMGE | QUAN | 13(3) | MENGE | ||||
PLANZ | Promotion plan, no. of materials | W_PLANZ | NUMC | 6 | NUMC6 | ||||
MELAK | Logistics unit, promotion plan | W_MELAK | UNIT | 3 | T006 | CUNIT | MEINS | ||
MELRA | Logistics units, reference promotion | W_MELRA | UNIT | 3 | T006 | CUNIT | MEINS | ||
PDUEP | Detailed promotion plan, sales volume at purchase price | W_PDUEP | CURR | 13(2) | WERT | ||||
PDUEN | Planned sales qty at delivered price (net/net) | W_PDUEN | CURR | 13(2) | WERT | ||||
PDUVP | Detailed Promotion Plan Sales Volume at Promo. Sales Price | W_PDUVP | CURR | 13(2) | WERT | ||||
PDMGE | Detailed promotion plan, no. of logistics units | W_PDMGE | QUAN | 13(3) | MENGE | ||||
PDANZ | Detailed Promotion Plan, Number of Materials | W_PDANZ | NUMC | 6 | NUMC6 | ||||
VAUEP | Sales volume at purchase price for comparative promotion | W_VAUEP | CURR | 13(2) | WERT | ||||
VAUEN | Comparative promotion: sales vol.at delivered price(net/net) | W_VAUEN | CURR | 13(2) | WERT | ||||
VAUVP | Sales volume of comparative promotion at sales prices | W_VAUVP | CURR | 13(2) | WERT | ||||
VAMGE | No. of log. units in comparative promotion | W_VAMGE | QUAN | 13(3) | MENGE | ||||
RFIND | External description for agreement | ABREX | CHAR | 20 | CHAR20 | ||||
VAANZ | No. of materials/units of measure in comparative promotion | W_VAANZ | NUMC | 6 | NUMC6 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KOBVK | Group of condition types/tables for sales price conditions | W_KOBVK | CHAR | 4 | CHAR4 | ||||
FADAT | Earliest Order Date | W_FADAT | DATS | 8 | DATUM | ||||
SADAT | Latest Order Date | W_SADAT | DATS | 8 | DATUM | ||||
FLDAT | Earliest delivery date | W_FLDAT | DATS | 8 | DATUM | ||||
SLDAT | Latest delivery date | W_SLDAT | DATS | 8 | DATUM | ||||
ADDIBELNR | Document number for additional | ADDI_BELNR | CHAR | 10 | Assigned to domain | ALPHA | ADDI_BELNR | ||
VZKON | Create DC condition records | W_VZKON | CHAR | 1 | XFELD | ||||
KALKE | Activation type for sales prices | W_AKTARTH | CHAR | 1 | AKTARTH | ||||
PLTYP | Price list type: promotion header | W_PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
NO_KALK | Price Activation w/o Price Calculation | NO_KALK | CHAR | 1 | XFELD | ||||
EKERV | Promotion: Purchase price determination sequence | W_EKERV | CHAR | 2 | TWEV | EKERV | |||
RFCDEST | Logical Destination (Specified in Function Call) | RFCDEST | CHAR | 32 | Assigned to domain | RFCDEST | RFC | F4_RFCDESTYPEALL | |
ERAPPL | Application that Created the Promotion | W_ERAPPL | CHAR | 1 | W_ERAPPL | ||||
KSCHL_PERC | Condition Type Percentage Discount | KSCHL_PERC | CHAR | 4 | T685 | KSCHL | |||
KSCHL_VAL | Condition Type Absolute Discount | KSCHL_VAL | CHAR | 4 | T685 | KSCHL | |||
PLUNP | Promotion Plan Invoiced Sales at Standard Sales Prices | W_PLUNP | CURR | 13(2) | WERT | ||||
PLURE | Promotion Plan Gross Revenue | W_PLURE | CURR | 13(2) | WERT | ||||
PLULO | Promotion Plan Invoiced Lost Sales | W_PLULO | CURR | 13(2) | WERT | ||||
MEDIA_TYPE | Media Type | RDM_MEDIA_TYPE | CHAR | 4 | RDMT_MED_TYPE | RDM_MEDIA_TYPE | |||
CUSTOMER_TYPE | Customer Type | RDM_CUSTOMER_TYPE | CHAR | 4 | RDMT_CUST_TYPE | RDM_CUSTOMER_TYPE | |||
ALLOW_PMAT_IGNO | Variant Price Allowed (for Promotion Type) | WPM_ALLOW_PMAT_IGNO_PROMO | CHAR | 1 | XFELD | ||||
ITEMS_4_BBY | Control of Subsequent Processing of Bonus Buy Materials | WPM_ITEMS_4_BBYS | CHAR | 1 | WPM_ITEMS_4_BBYS | ||||
ALLOW_DISP_MAT | Addition of Display Materials Allowed | WPM_ALLOW_DISP_MAT | CHAR | 1 | XFELD | ||||
INIT_SLS_PRICE | Allow Initial Sales Price in Price Activation | WPM_ALLOW_INITIAL_SLS_PRICE | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
REF_PROMO | Higher-Level Promotion | WAKTPP_REF_PROMO | CHAR | 10 | WAKH | ALPHA | WAKTION | ||
CGPL_GUID | CGPL Project GUID | WAKTPP_CGPL_GUID | RAW | 16 | WAKTPP_CGPL_GUID | ||||
EXTERNAL_ID | CGPL Project External ID | WAKTPP_CGPL_EXTID | CHAR | 24 | WAKTPP_CGPL_EXTID | ||||
IS_REF_PROMO | Indicator: Higher-Level Promotion | WAKTPP_IS_REF_PROMO | CHAR | 1 | WAKTPP_IS_REF_PROMO | ||||
BEKST2 | Status of New Announcement | WAKTPP_STBEK2 | CHAR | 1 | WAKTPP_STBEK2 | ||||
ERDOCN | Document that Created the Retail Promotion | WAKTPP_ERDOCN | CHAR | 10 | ALPHA | WAKTPP_ERDOCN | |||
HIER_ID | Hierarchy | WAKT_HIER_CNT | CHAR | 2 | WAKT_HIERCNT | ||||
.INCLU--AP | 0 | ||||||||
BPROF | Bonus Buy: Bonus buy profile | RDM_BBY_BPROF | CHAR | 4 | CHAR4 | RDM_BBY_BPROF | RDM_BBY_BPROF_SHLP |
Key field | Non-key field |
How do I retrieve data from SAP structure BIW_WAKH_S using ABAP code?
As BIW_WAKH_S is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BIW_WAKH_S as there is no data to select.How to access SAP table BIW_WAKH_S
Within an ECC or HANA version of SAP you can also view further information about BIW_WAKH_S and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects