WLK1

Transparent Table Application Table
19 Fields 1 CDS Views

Listing Conditions SAP Retail Assortments

WLK1 is an SAP database table in S/4HANA. Listing Conditions SAP Retail Assortments. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ListingCondition view from BASIC Listing conditions

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY filia ASORT Assortment
KEY artnr MATNR Material
KEY vrkme VRKME Sales Unit
KEY datbi DATBI Valid To
KEY lfdnr LFDN3 Seq. no.
datab DATAB Valid From
ursac W_URSAC_BS Module
quell W_URSAC_LI Listing Source
pflkn W_PFLKN Int.astmt prio.
anzal W_BAU_ZAHL No. of modules
datae DATAE Last change
negat W_NEG_SORT Negation item
aktio WAKTION Promotion
thema WAKT_THEMA Promo theme
strli W_STRULI List as compon.
sstat W_SORTSTAT Astmt status
lifnr W_RACKJOB Rack Jobber
strnr STRNR Structured matl

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.

-- Listing Conditions SAP Retail Assortments
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLK1 (
    MANDT,  -- Client [MANDT]
    FILIA,  -- Assortment [ASORT]
    ARTNR,  -- Material [MATNR]
    VRKME,  -- Sales Unit [VRKME]
    DATBI,  -- Valid To [DATBI]
    LFDNR,  -- Seq. no. [LFDN3]
    DATAB,  -- Valid From [DATAB]
    URSAC,  -- Module [W_URSAC_BS]
    QUELL,  -- Listing Source [W_URSAC_LI]
    PFLKN,  -- Int.astmt prio. [W_PFLKN]
    ANZAL,  -- No. of modules [W_BAU_ZAHL]
    DATAE,  -- Last change [DATAE]
    NEGAT,  -- Negation item [W_NEG_SORT]
    AKTIO,  -- Promotion [WAKTION]
    THEMA,  -- Promo theme [WAKT_THEMA]
    STRLI,  -- List as compon. [W_STRULI]
    SSTAT,  -- Astmt status [W_SORTSTAT]
    LIFNR,  -- Rack Jobber [W_RACKJOB]
    STRNR,  -- Structured matl [STRNR]
    PRIMARY KEY (MANDT, FILIA, ARTNR, VRKME, DATBI, LFDNR)
);

Learn More