WAKR

Transparent Table Application Table
15 Fields 1 CDS Views

Promotion Discounts

WAKR is an SAP database table in S/4HANA. Promotion Discounts. It contains 15 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 (15)

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.

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]
    PRIMARY KEY (MANDT, AKTNR, POSNR)
);

Learn More