WAKH

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 Header Data, IS-R
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WAKH (
    MANDT,            -- Client [mandt]
    AKTNR,            -- Promotion [waktion]
    AKTYP,            -- Promotion Cat. [w_aktyp]
    AKART,            -- Promotion Type [w_akart]
    WAELA,            -- Plnd crrncy [w_waela]
    WAERA,            -- Sales currency [w_waera]
    VGLAK,            -- Comp. promotion [w_vglak]
    LISRE,            -- LP for Stores [lstfl]
    AUFAR,            -- Alloc. Tbl Type [w_aufar]
    BEKTY,            -- Announce. cat. [w_bekty]
    KSBEK,            -- Message schema [w_nachsm]
    AKVST,            -- Subseq. process [w_akvst]
    AKAST,            -- Alloc. tbl stat [w_akast]
    AKBST,            -- Listing [w_akbst]
    VKGST,            -- Prices [w_vkkpsh]
    EKGST,            -- PPrice status [w_ekkpsh]
    BEKST,            -- Announcement [w_stbek]
    AKNBS,            -- No. of modules [w_aknbs]
    AKNFG,            -- No. plant grps [w_aknfg]
    AKNBF,            -- No.Mod./Plt.Grp [w_aknbf]
    AKNTH,            -- No. of themes [w_aknth]
    AKNPO,            -- No. alloc. itms [w_aknpo]
    AKNWM,            -- No. prod. cats [w_aknwm]
    AKNTX,            -- No. texts [w_akntx]
    NEKKO,            -- No.pur.pr.maint [w_nekko]
    NVKKO,            -- No.SalesPr.main [w_nvkko]
    NARTS,            -- Blocked items [w_narts]
    ATNPO,            -- No.in alloc tbl [w_atnpo]
    VTART,            -- Listing Check [w_lcheck]
    EKDAB,            -- Purchase from [w_ekdab]
    EKDBI,            -- to [w_ekdbi]
    VKDAB,            -- On sale from [w_vkdab]
    VKDBI,            -- to [w_vkdbi]
    ALIVO,            -- Listed from [w_alivo]
    ALIBI,            -- Listed to [w_alibi]
    SPDAB,            -- Pro.blocked on [w_spdab]
    SPGRU,            -- Blocking reason [w_spgru]
    EKKON,            -- PP conditions [w_ekkon]
    VKKON,            -- SP conditions [w_vkkon]
    KOBOG,            -- Cond.grp pur. [w_kobog]
    EKORG,            -- Purchasing Org. [ekorg]
    EKGRP,            -- Purch. Group [w_ekgrp]
    VKORG,            -- Sales Organiz. [w_vkorg_header]
    VTWEG,            -- Distrib.Channel [w_vtweg_header]
    PLUEP,            -- Sales at PP [w_pluep]
    PLUEN,            -- SalesPP net/net [w_pluen]
    PLUVP,            -- Sales vol.at SP [w_pluvp]
    PLMGE,            -- Qty log. units [w_plmge]
    PLANZ,            -- No. items [w_planz]
    MELAK,            -- Logistics unit [w_melak]
    MELRA,            -- Logistics unit [w_melra]
    PDUEP,            -- Sales at PP [w_pduep]
    PDUEN,            -- SalesPP net/net [w_pduen]
    PDUVP,            -- Sales vol.at SP [w_pduvp]
    PDMGE,            -- Qty log. units [w_pdmge]
    PDANZ,            -- No. Items [w_pdanz]
    VAUEP,            -- Sales at PP [w_vauep]
    VAUEN,            -- SalesPP net/net [w_vauen]
    VAUVP,            -- Sales at retail [w_vauvp]
    VAMGE,            -- Qty log. units [w_vamge]
    RFIND,            -- Ext.description [abrex]
    VAANZ,            -- No. items [w_vaanz]
    ERNAM,            -- Created By [ernam]
    ERDAT,            -- Created On [erdat]
    AENAM,            -- Changed By [aenam]
    AEDAT,            -- Changed On [aedat]
    KOBVK,            -- Cond. group SP [w_kobvk]
    FADAT,            -- Sales ord. from [w_fadat]
    SADAT,            -- Sales order to [w_sadat]
    FLDAT,            -- Delivery from [w_fldat]
    SLDAT,            -- Delivery to [w_sldat]
    ADDIBELNR,        -- Document number [addi_belnr]
    VZKON,            -- DC conditions [w_vzkon]
    KALKE,            -- Activation Type [w_aktarth]
    PLTYP,            -- Price list [w_pltyp]
    NO_KALK,          -- w/o calculation [no_kalk]
    EKERV,            -- PP det. seq. [w_ekerv]
    RFCDEST,          -- Destination [rfcdest]
    ERAPPL,           -- Creating applic. [w_erappl]
    KSCHL_PERC,       -- CondType %Disct [kschl_perc]
    KSCHL_VAL,        -- CondTypeAbsDsct [kschl_val]
    PLUNP,            -- Standard SP [w_plunp]
    PLURE,            -- Gross Revenue [w_plure]
    PLULO,            -- Lost Sales [w_plulo]
    MEDIA_TYPE,       -- Media Type [rdm_media_type]
    CUSTOMER_TYPE,    -- Customer Type [rdm_customer_type]
    ALLOW_PMAT_IGNO,  -- Var. Price Allowed [wpm_allow_pmat_igno_promo]
    ITEMS_4_BBY,      -- Subsequent Process [wpm_items_4_bbys]
    ALLOW_DISP_MAT,   -- Display Article [wpm_allow_disp_mat]
    INIT_SLS_PRICE,   -- Allow InitSlsPrc [wpm_allow_initial_sls_price]
    PRIMARY KEY (MANDT, AKTNR)
);