SAP Table WAKR
Promotion Discounts
WAKR (Promotion Discounts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WAKR to other SAP tables.
WAKR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 | 0 | ||||||||||||||||
| POSNR | Item Number for Promotion Discount | REB_POSNR | NUMC | 6 | 0 | |||||||||||||||||
| REB_LEVEL | Discount Level | REB_LEVEL | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||
| MATKL | Promotion Discount: Material Group | REB_MATKL | T023 | CHAR | 9 | 0 | ||||||||||||||||
| WGHIER | Promotion Discount: Material Group Hierarchy Level | REB_WWGHIE | CHAR | 18 | 0 | |||||||||||||||||
| REB_VALUE | Value of Absolute Discount | REB_VALUE | CURR | 11 | 2 | |||||||||||||||||
| REB_CURR | Currency for Absolute Discount | REB_CURR | TCURC | CUKY | 5 | 0 | ||||||||||||||||
| REB_PERC | Percentage Discount | REB_PERC | DEC | 5 | 2 | |||||||||||||||||
| REB_STATUS | Discount Status | REB_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| REB_DATEFR | Discount Valid From | REB_DATEFR | DATS | 8 | 0 | |||||||||||||||||
| REB_DATETO | Discount Valid To | REB_DATETO | DATS | 8 | 0 | |||||||||||||||||
| REB_UNIT | Unit of Measure for Discount | REB_UNIT | T006 | UNIT | 3 | 0 | ||||||||||||||||
| OFFER_ID | Offer ID for Discount | WPM_OFFERID_DISCOUNT | CHAR | 36 | 0 | |||||||||||||||||
| OFFER_PRDGRP | Product Group in Offer (Discount) | WPM_OFFER_PRODUCT_GROUP_DSCNT | NUMC | 3 | 0 | |||||||||||||||||
| HIER_ID | Hierarchy | WAKT_HIER_CNT | CHAR | 2 | 0 | |||||||||||||||||
| NODE | Hierarchy Node | WAKT_STRUC_NODE | CHAR | 18 | 0 | |||||||||||||||||
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 | 0 | ||||||||||||||||
| SAISJ | Season Year | SAISJ | CHAR | 4 | 0 | |||||||||||||||||
WAKR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WAKR | AKTNR | WAKR | MANDT | WAKH | Promotion Header Data, IS-R | MANDT |
| WAKR | AKTNR | WAKR | AKTNR | WAKH | Promotion Header Data, IS-R | AKTNR |
| WAKR | MANDT | WAKR | MANDT | T000 | Clients | MANDT |
| WAKR | MATKL | WAKR | MANDT | T023 | Material Groups | MANDT |
| WAKR | MATKL | WAKR | MATKL | T023 | Material Groups | MATKL |
| WAKR | REB_CURR | WAKR | REB_CURR | TCURC | Currency Codes | WAERS |
| WAKR | REB_CURR | WAKR | MANDT | TCURC | Currency Codes | MANDT |
| WAKR | REB_UNIT | WAKR | MANDT | T006 | Units of Measurement | MANDT |
| WAKR | REB_UNIT | WAKR | REB_UNIT | T006 | Units of Measurement | MSEHI |
| WAKR | SAISO | SYST | MANDT | T6WSP | Check Table for Season Indicator | MANDT |
| WAKR | SAISO | WAKR | SAISO | T6WSP | Check Table for Season Indicator | SAISO |
