WRS1

Transparent Table Application Table
25 Fields 1 CDS Views

Assortment

WRS1 is an SAP database table in S/4HANA. Assortment. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Assortment view from BASIC Assortment

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY asort ASORT Assortment
statu W_S_STATUS Status
kzlik KZLIK ListCondAstmt
nlmatfb NLMATFB ID subseq.list.
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
lstfl LSTVF List. procedure
datab DATAB Valid From
datbi DATBI Valid To
kopro W_S_KOPRO List all MatGps
laypr W_S_LAYPR LaytChck, astmt
sotyp W_SOTYP Assortment Cat.
layvr LAYVAR Layout
posds W_POS_DS No POS data
exclu W_S_EXCLU Exclusion LC
category CAT_NODE Category
lay_list_utime LAYOUT_LISTING_UPDTTIME date and time
hier_id WRF_HIER_CNT Hierarchy
assortyp WRFDE_ASSORTYP Assortment Type
assordimval1 WRFDE_ASSORDIMVAL Dimension Val.
assordimval2 WRFDE_ASSORDIMVAL Dimension Val.
assordimval3 WRFDE_ASSORDIMVAL Dimension Val.
laygr LAYGR Layout Mod.
aedat AEDAT Changed On

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.

-- Assortment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRS1 (
    MANDT,           -- Client [MANDT]
    ASORT,           -- Assortment [ASORT]
    STATU,           -- Status [W_S_STATUS]
    KZLIK,           -- ListCondAstmt [KZLIK]
    NLMATFB,         -- ID subseq.list. [NLMATFB]
    VKORG,           -- Sales Org. [VKORG]
    VTWEG,           -- Distr. Channel [VTWEG]
    LSTFL,           -- List. procedure [LSTVF]
    DATAB,           -- Valid From [DATAB]
    DATBI,           -- Valid To [DATBI]
    KOPRO,           -- List all MatGps [W_S_KOPRO]
    LAYPR,           -- LaytChck, astmt [W_S_LAYPR]
    SOTYP,           -- Assortment Cat. [W_SOTYP]
    LAYVR,           -- Layout [LAYVAR]
    POSDS,           -- No POS data [W_POS_DS]
    EXCLU,           -- Exclusion LC [W_S_EXCLU]
    CATEGORY,        -- Category [CAT_NODE]
    LAY_LIST_UTIME,  -- date and time [LAYOUT_LISTING_UPDTTIME]
    HIER_ID,         -- Hierarchy [WRF_HIER_CNT]
    ASSORTYP,        -- Assortment Type [WRFDE_ASSORTYP]
    ASSORDIMVAL1,    -- Dimension Val. [WRFDE_ASSORDIMVAL]
    ASSORDIMVAL2,    -- Dimension Val. [WRFDE_ASSORDIMVAL]
    ASSORDIMVAL3,    -- Dimension Val. [WRFDE_ASSORDIMVAL]
    LAYGR,           -- Layout Mod. [LAYGR]
    AEDAT,           -- Changed On [AEDAT]
    PRIMARY KEY (MANDT, ASORT)
);

Learn More