WCAHE

Transparent Table Application Table
33 Fields 6 CDS Views

WCM: Work Clearance Document (Header)

WCAHE is an SAP database table in S/4HANA. WCM: Work Clearance Document (Header). It contains 33 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_SafetyCertificate view_entity from EXTENSION Safety Certificate - Extension
E_SafetyCertificateTemplate view_entity from EXTENSION Safety Certificate Template - Extension
I_SafetyCertificateApproval view_entity inner BASIC Approvals for Safety Certificate
I_SafetyCertificateBasic view_entity from BASIC Safety Certificate Details
I_SafetyCertificatePartner view_entity inner BASIC Safety Certificate Partner
I_SftyCertTemplatePartner view_entity inner BASIC Safety certificate template Partner

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wcnr wcewcnr WC Document
objnr j_objnr Object number
wctyp wcetyp Object Type
wcuse wceusage Usage
stxt wcestxt Short Text
lflg wceltxtflg Long Text
delflg wcedelflg Delete
untgflg wceunltxtflg UG Text Exists
tgflg wcetgltxtflg TG Text Exists
catflg1 wcecatflg Catalog Exists
catflg2 wcecatflg Catalog Exists
ingrp ingrp Planner Group
iwerk iwerk Planning Plant
wkcrtyp cr_objty Object Type
wkcrid cr_objid Object ID
begru iautg AuthorizGroup
anlzu wceanlzu Overall Condtn
rctime wcerectime Recall Time
rcunit wcerecunit Unit
priok priok Priority
tplnr tplnr Functional loc.
equnr equnr Equipment
lnkflg wcelnkflg Obj.List Exists
train wcetrain Train
etape wceetape Revision Phase
docflg wcedocflg Document Link
wcstsma j_stsma Status Profile
wcitmstsma j_stsma Status Profile
refobj wcerefobj Template
remarkflg1 wceremarkflg1 Remarks Mt
remarkflg2 wceremarkflg2 Remarks Op
sftycertprocessingstatus ptwdsftycertprocessingstatus Proc Stat Sfty Cert

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: Work Clearance Document (Header)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WCAHE (
    MANDT,                     -- Client [mandt]
    WCNR,                      -- WC Document [wcewcnr]
    OBJNR,                     -- Object number [j_objnr]
    WCTYP,                     -- Object Type [wcetyp]
    WCUSE,                     -- Usage [wceusage]
    STXT,                      -- Short Text [wcestxt]
    LFLG,                      -- Long Text [wceltxtflg]
    DELFLG,                    -- Delete [wcedelflg]
    UNTGFLG,                   -- UG Text Exists [wceunltxtflg]
    TGFLG,                     -- TG Text Exists [wcetgltxtflg]
    CATFLG1,                   -- Catalog Exists [wcecatflg]
    CATFLG2,                   -- Catalog Exists [wcecatflg]
    INGRP,                     -- Planner Group [ingrp]
    IWERK,                     -- Planning Plant [iwerk]
    WKCRTYP,                   -- Object Type [cr_objty]
    WKCRID,                    -- Object ID [cr_objid]
    BEGRU,                     -- AuthorizGroup [iautg]
    ANLZU,                     -- Overall Condtn [wceanlzu]
    RCTIME,                    -- Recall Time [wcerectime]
    RCUNIT,                    -- Unit [wcerecunit]
    PRIOK,                     -- Priority [priok]
    TPLNR,                     -- Functional loc. [tplnr]
    EQUNR,                     -- Equipment [equnr]
    LNKFLG,                    -- Obj.List Exists [wcelnkflg]
    TRAIN,                     -- Train [wcetrain]
    ETAPE,                     -- Revision Phase [wceetape]
    DOCFLG,                    -- Document Link [wcedocflg]
    WCSTSMA,                   -- Status Profile [j_stsma]
    WCITMSTSMA,                -- Status Profile [j_stsma]
    REFOBJ,                    -- Template [wcerefobj]
    REMARKFLG1,                -- Remarks Mt [wceremarkflg1]
    REMARKFLG2,                -- Remarks Op [wceremarkflg2]
    SFTYCERTPROCESSINGSTATUS,  -- Proc Stat Sfty Cert [ptwdsftycertprocessingstatus]
    PRIMARY KEY (MANDT, WCNR)
);

Learn More