WAKR

Transparent Table Application Table
19 Fields 1 CDS Views

Promotion Discounts

WAKR is an SAP database table in S/4HANA. Promotion Discounts. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RetailPromotionDiscount view_entity from BASIC Retail Promotion Discount

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aktnr WAKTION Promotion
KEY posnr REB_POSNR Item Number for Promotion Discount
reb_level REB_LEVEL Discount Level
matkl REB_MATKL Material group
wghier REB_WWGHIE MG hierarchy level
reb_value REB_VALUE Abs.Discount
reb_curr REB_CURR Currency
reb_perc REB_PERC Percent.Discnt
reb_status REB_STATUS Discount Status
reb_datefr REB_DATEFR Dsct Valid From
reb_dateto REB_DATETO Valid to
reb_unit REB_UNIT Unit of measure
offer_id WPM_OFFERID_DISCOUNT OfferID Discnt
offer_prdgrp WPM_OFFER_PRODUCT_GROUP_DSCNT Prod. Grp Disc.
hier_id WAKT_HIER_CNT Hierarchy
node WAKT_STRUC_NODE Hierarchy Node
saiso SAISO Season
saisj SAISJ Season Year

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Promotion Discounts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WAKR (
    MANDT,         -- Client [MANDT]
    AKTNR,         -- Promotion [WAKTION]
    POSNR,         -- Item Number for Promotion Discount [REB_POSNR]
    REB_LEVEL,     -- Discount Level [REB_LEVEL]
    MATKL,         -- Material group [REB_MATKL]
    WGHIER,        -- MG hierarchy level [REB_WWGHIE]
    REB_VALUE,     -- Abs.Discount [REB_VALUE]
    REB_CURR,      -- Currency [REB_CURR]
    REB_PERC,      -- Percent.Discnt [REB_PERC]
    REB_STATUS,    -- Discount Status [REB_STATUS]
    REB_DATEFR,    -- Dsct Valid From [REB_DATEFR]
    REB_DATETO,    -- Valid to [REB_DATETO]
    REB_UNIT,      -- Unit of measure [REB_UNIT]
    OFFER_ID,      -- OfferID Discnt [WPM_OFFERID_DISCOUNT]
    OFFER_PRDGRP,  -- Prod. Grp Disc. [WPM_OFFER_PRODUCT_GROUP_DSCNT]
    HIER_ID,       -- Hierarchy [WAKT_HIER_CNT]
    NODE,          -- Hierarchy Node [WAKT_STRUC_NODE]
    SAISO,         -- Season [SAISO]
    SAISJ,         -- Season Year [SAISJ]
    PRIMARY KEY (MANDT, AKTNR, POSNR)
);

Learn More