WAKP

Transparent Table Application Table
83 Fields 1 CDS Views

Promotion Item Data

WAKP is an SAP database table in S/4HANA. Promotion Item Data. It contains 83 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RetailPromotionItem view_entity from BASIC Retail Promotion Item

Fields (83)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aktnr WAKTION Promotion
KEY artnr MATNR Material
KEY mebme W_MEBME Sales unit
akpos W_AKPOS Item Number
satnr SATNR Cross-plant CM
matkl MATKL Material Group
akthe W_AKTHE Theme
bzqfi W_BZQFI SupplySourceDet
akbsp W_AKBSP Listing
nbpos W_NBPOS No. of modules
reskz W_LCHECK Listing Check
bekty W_BEKTY Announce. cat.
spdat W_SPDAT Item blocked on
spgru W_SPGRU Blocking reason
ekorg EKORG Purchasing Org.
ekgrp EKGRP Purch. Group
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
akliz W_PLIFZ Plnd del. time
pumvp W_PUMVP Pld sales at SP
pumep W_PUMEP Pld sales at PP
pumen W_PUMEN Pl.sales PP-NN
pabbm W_PABBM Pld sales qty
pablm W_PABLM Logistics qty
aufme W_AUFME Alloc. tbl qty
plvkp W_PLVKP Sales Price
vpein VPEIN Sales price un
plekp W_PLEKP Purchase Price
plekn W_PLEKN PP net/net
epein EPEIN Price Unit
waeek W_WAEEK Pur. curr.
waela W_WAELA Plnd crrncy
meins W_MEINS Base unit
melog W_MELOG Logistics unit
mebpr BBPRM Order Price Un.
meauf W_MEAUF Alloc. tbl unit
rgart W_RGART Return type
miamg W_MIAMG Min. order qty
ndisp W_NDISP Replenish. ID
fbdat W_FADAT Sales ord. from
sbdat W_SADAT Sales order to
fldat W_FLDAT Delivery from
sldat W_SLDAT Delivery to
apstp APSTP Item category
bedat W_BEDAT Order Date Sup.
vrege VREGE Allocation Rule
abeln ABELN Alloc. Table
abelp ABELP Item
etiag W_ETIAG Label.matl grpg
ekkps W_EKKPS Purchase prices
vkkps W_VKKPS Sales prices
ekkon W_EKKON PP conditions
vkkon W_VKKON SP conditions
activ W_ACTIV Activations
ernam ERNAM Created By
erdat ERDAT Created On
aenam AENAM Changed By
aedat AEDAT Changed On
eckpkz F_VKPKZ Adjust pr. pnt
vzkon W_VZKON DC conditions
vzkps W_VZKPS DC tran. prices
eprgr W_EPRGR Price Pnt Group
nvkp W_NVKP Standard SP
vk_aktiv_ab W_VK_AKTIV_AB SP active from
vk_aktiv_bi W_VK_AKTIV_BI Active to
batnr BSTARTNR Allocation mat.
ekerv W_EKERV PP det. seq.
reb_value REB_VALUE Abs.Discount
reb_perc REB_PERC Percent.Discnt
reb_status REB_STATUS Discount Status
no_kalk NO_KALK w/o calculation
astra W_ASTRA Alloc. Strategy
offer_type RDM_OFFER_TYPE_PRICE Price Offer
offer_type_dsc RDM_OFFER_TYPE_DISCOUNT Discount Offer
offer_id WPM_OFFERID_PRICE OfferID Price
offer_id_dsc WPM_OFFERID_DISCOUNT OfferID Discnt
offer_prdgrp WPM_OFFER_PRODUCT_GROUP_PRICE Prod. Grp Price
offer_prdgrp_dsc WPM_OFFER_PRODUCT_GROUP_DSCNT Prod. Grp Disc.
item_creat_indic WPM_PROMO_ITEM Promo Item Indicator
pabbm_offer_prc W_PABBM_OFFER_PRC Planned Sales Qty
pabbm_offer_dsc W_PABBM_OFFER_DSC Planned Sales Qty
astra_var ASTRA_VAR Alloc.Strat.Variant

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 Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WAKP (
    MANDT,             -- Client [MANDT]
    AKTNR,             -- Promotion [WAKTION]
    ARTNR,             -- Material [MATNR]
    MEBME,             -- Sales unit [W_MEBME]
    AKPOS,             -- Item Number [W_AKPOS]
    SATNR,             -- Cross-plant CM [SATNR]
    MATKL,             -- Material Group [MATKL]
    AKTHE,             -- Theme [W_AKTHE]
    BZQFI,             -- SupplySourceDet [W_BZQFI]
    AKBSP,             -- Listing [W_AKBSP]
    NBPOS,             -- No. of modules [W_NBPOS]
    RESKZ,             -- Listing Check [W_LCHECK]
    BEKTY,             -- Announce. cat. [W_BEKTY]
    SPDAT,             -- Item blocked on [W_SPDAT]
    SPGRU,             -- Blocking reason [W_SPGRU]
    EKORG,             -- Purchasing Org. [EKORG]
    EKGRP,             -- Purch. Group [EKGRP]
    VKORG,             -- Sales Org. [VKORG]
    VTWEG,             -- Distr. Channel [VTWEG]
    AKLIZ,             -- Plnd del. time [W_PLIFZ]
    PUMVP,             -- Pld sales at SP [W_PUMVP]
    PUMEP,             -- Pld sales at PP [W_PUMEP]
    PUMEN,             -- Pl.sales PP-NN [W_PUMEN]
    PABBM,             -- Pld sales qty [W_PABBM]
    PABLM,             -- Logistics qty [W_PABLM]
    AUFME,             -- Alloc. tbl qty [W_AUFME]
    PLVKP,             -- Sales Price [W_PLVKP]
    VPEIN,             -- Sales price un [VPEIN]
    PLEKP,             -- Purchase Price [W_PLEKP]
    PLEKN,             -- PP net/net [W_PLEKN]
    EPEIN,             -- Price Unit [EPEIN]
    WAEEK,             -- Pur. curr. [W_WAEEK]
    WAELA,             -- Plnd crrncy [W_WAELA]
    MEINS,             -- Base unit [W_MEINS]
    MELOG,             -- Logistics unit [W_MELOG]
    MEBPR,             -- Order Price Un. [BBPRM]
    MEAUF,             -- Alloc. tbl unit [W_MEAUF]
    RGART,             -- Return type [W_RGART]
    MIAMG,             -- Min. order qty [W_MIAMG]
    NDISP,             -- Replenish. ID [W_NDISP]
    FBDAT,             -- Sales ord. from [W_FADAT]
    SBDAT,             -- Sales order to [W_SADAT]
    FLDAT,             -- Delivery from [W_FLDAT]
    SLDAT,             -- Delivery to [W_SLDAT]
    APSTP,             -- Item category [APSTP]
    BEDAT,             -- Order Date Sup. [W_BEDAT]
    VREGE,             -- Allocation Rule [VREGE]
    ABELN,             -- Alloc. Table [ABELN]
    ABELP,             -- Item [ABELP]
    ETIAG,             -- Label.matl grpg [W_ETIAG]
    EKKPS,             -- Purchase prices [W_EKKPS]
    VKKPS,             -- Sales prices [W_VKKPS]
    EKKON,             -- PP conditions [W_EKKON]
    VKKON,             -- SP conditions [W_VKKON]
    ACTIV,             -- Activations [W_ACTIV]
    ERNAM,             -- Created By [ERNAM]
    ERDAT,             -- Created On [ERDAT]
    AENAM,             -- Changed By [AENAM]
    AEDAT,             -- Changed On [AEDAT]
    ECKPKZ,            -- Adjust pr. pnt [F_VKPKZ]
    VZKON,             -- DC conditions [W_VZKON]
    VZKPS,             -- DC tran. prices [W_VZKPS]
    EPRGR,             -- Price Pnt Group [W_EPRGR]
    NVKP,              -- Standard SP [W_NVKP]
    VK_AKTIV_AB,       -- SP active from [W_VK_AKTIV_AB]
    VK_AKTIV_BI,       -- Active to [W_VK_AKTIV_BI]
    BATNR,             -- Allocation mat. [BSTARTNR]
    EKERV,             -- PP det. seq. [W_EKERV]
    REB_VALUE,         -- Abs.Discount [REB_VALUE]
    REB_PERC,          -- Percent.Discnt [REB_PERC]
    REB_STATUS,        -- Discount Status [REB_STATUS]
    NO_KALK,           -- w/o calculation [NO_KALK]
    ASTRA,             -- Alloc. Strategy [W_ASTRA]
    OFFER_TYPE,        -- Price Offer [RDM_OFFER_TYPE_PRICE]
    OFFER_TYPE_DSC,    -- Discount Offer [RDM_OFFER_TYPE_DISCOUNT]
    OFFER_ID,          -- OfferID Price [WPM_OFFERID_PRICE]
    OFFER_ID_DSC,      -- OfferID Discnt [WPM_OFFERID_DISCOUNT]
    OFFER_PRDGRP,      -- Prod. Grp Price [WPM_OFFER_PRODUCT_GROUP_PRICE]
    OFFER_PRDGRP_DSC,  -- Prod. Grp Disc. [WPM_OFFER_PRODUCT_GROUP_DSCNT]
    ITEM_CREAT_INDIC,  -- Promo Item Indicator [WPM_PROMO_ITEM]
    PABBM_OFFER_PRC,   -- Planned Sales Qty [W_PABBM_OFFER_PRC]
    PABBM_OFFER_DSC,   -- Planned Sales Qty [W_PABBM_OFFER_DSC]
    ASTRA_VAR,         -- Alloc.Strat.Variant [ASTRA_VAR]
    PRIMARY KEY (MANDT, AKTNR, ARTNR, MEBME)
);

Learn More