WCALA

Transparent Table Application Table
12 Fields 7 CDS Views

WCM: WCM Object <-> WCM Object

WCALA is an SAP database table in S/4HANA. WCM: WCM Object <-> WCM Object. It contains 12 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_SafetyCertificateWorkPermit view_entity from EXTENSION Work Permits in Safety Certificate Ext
E_SftyCertTmplWrkPmtTemplate view_entity from EXTENSION Sfty Cert Tmpl Wrk Pmt Template
E_WorkPermitOrder view_entity from EXTENSION Work Permit Assigned Orders - Extension
E_WorkPermitSafetyCertificate view_entity from EXTENSION Safety Certificate Extension
E_WrkPmtTmplSftyCertTemplate view_entity from EXTENSION WP Sfty Cert Template Extn
I_SftyCertWorkPermitBasic view_entity from BASIC Work Permits in Safety Certificate
I_WorkPermitOrderBasic view_entity from BASIC Work Permit Order

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fatherobj j_objnr Object number
KEY childobj j_objnr Object number
fatherart wcefatherart 1st ObjTyp
fathertyp wcefathertyp 1st ObjTyp
childart wcechildart 2nd ObjTyp
childtyp wcechildtyp 2nd ObjTyp
ctrlflg1 wceflg Indicator
ctrlflg2 wceflg Indicator
ctrlflg3 wceflg Indicator
wrkpmtprocessingcontext ptwewrkpmtprocessingcontext Processing Context
isreferencedocument ptweisreferencedocument

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.

-- WCM: WCM Object <-> WCM Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WCALA (
    MANDT,                    -- Client [mandt]
    FATHEROBJ,                -- Object number [j_objnr]
    CHILDOBJ,                 -- Object number [j_objnr]
    FATHERART,                -- 1st ObjTyp [wcefatherart]
    FATHERTYP,                -- 1st ObjTyp [wcefathertyp]
    CHILDART,                 -- 2nd ObjTyp [wcechildart]
    CHILDTYP,                 -- 2nd ObjTyp [wcechildtyp]
    CTRLFLG1,                 -- Indicator [wceflg]
    CTRLFLG2,                 -- Indicator [wceflg]
    CTRLFLG3,                 -- Indicator [wceflg]
    WRKPMTPROCESSINGCONTEXT,  -- Processing Context [ptwewrkpmtprocessingcontext]
    ISREFERENCEDOCUMENT,      -- ptweisreferencedocument
    PRIMARY KEY (MANDT, FATHEROBJ, CHILDOBJ)
);

Learn More