WRSZ

Transparent Table Application Table
18 Fields 1 CDS Views

Assignment of assortment user to assortment

WRSZ is an SAP database table in S/4HANA. Assignment of assortment user to assortment. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AssortmentUser view from BASIC Assortment User

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY asort asort Assortment
KEY lfdnr lfdnr5 Sequence No.
locnr locnr CustomerNoPlant
kunnr kunnr Customer
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
spart spart Division
sonut w_sonut Astmt user cat.
datab datab Valid From
datbi datbi Valid To
rangf w_s_rangf Ranking,AstAsgt
ligrd wligrd BasicRuleListng
ernam ernam Created By
erzet erzet Time
aenam aenam Changed By
aedat aedat Changed On
aezet aezet Time of change

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.

-- Assignment of assortment user to assortment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRSZ (
    MANDT,  -- Client [mandt]
    ASORT,  -- Assortment [asort]
    LFDNR,  -- Sequence No. [lfdnr5]
    LOCNR,  -- CustomerNoPlant [locnr]
    KUNNR,  -- Customer [kunnr]
    VKORG,  -- Sales Org. [vkorg]
    VTWEG,  -- Distr. Channel [vtweg]
    SPART,  -- Division [spart]
    SONUT,  -- Astmt user cat. [w_sonut]
    DATAB,  -- Valid From [datab]
    DATBI,  -- Valid To [datbi]
    RANGF,  -- Ranking,AstAsgt [w_s_rangf]
    LIGRD,  -- BasicRuleListng [wligrd]
    ERNAM,  -- Created By [ernam]
    ERZET,  -- Time [erzet]
    AENAM,  -- Changed By [aenam]
    AEDAT,  -- Changed On [aedat]
    AEZET,  -- Time of change [aezet]
    PRIMARY KEY (MANDT, ASORT, LFDNR)
);

Learn More