SWOR

Transparent Table Application Table
6 Fields 11 CDS Views

Classification System: Keywords

SWOR is an SAP database table in S/4HANA. Classification System: Keywords. It contains 6 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
/merp/core_Class_Def view left_outer CDS View: Classification Definition - Class Key
I_ClassText view from BASIC Class Description Text
I_ClfnClassDescription view from BASIC Description of Classification Class
I_ClfnClassDescriptionDEX view_entity from BASIC Description of Classification Class DEX
I_ClfnClassKeyword view from BASIC Keyword of Classification Class
I_MrchdsCatHierNodeText view_entity inner BASIC Merchandise Cat Hier Node - Text
I_MrchdsCatHierNodeText_2 view_entity inner BASIC Merchandise Cat Hier Node - Text
I_ProdStrucClassVH view inner BASIC Product Structure Class Value Help
I_Relclassdescription view from BASIC CDS view for description of release strategy class
P_NodeClass view inner BASIC
VC_INTEGRATION_SWOR view from Extraction for SWOR

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY clint CLINT Int class no.
KEY spras SPRAS Language
KEY klpos KLAPOS Item number
kschl KLSCHL Keyword
kschg KLSCHLG Keyword

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.

-- Classification System: Keywords
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWOR (
    MANDT,  -- Client [MANDT]
    CLINT,  -- Int class no. [CLINT]
    SPRAS,  -- Language [SPRAS]
    KLPOS,  -- Item number [KLAPOS]
    KSCHL,  -- Keyword [KLSCHL]
    KSCHG,  -- Keyword [KLSCHLG]
    PRIMARY KEY (MANDT, CLINT, SPRAS, KLPOS)
);

Learn More