WCAHE

Transparent Table Application Table
84 Fields 8 CDS Views

WCM: Work Clearance Document (Header)

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

CDS Views using this table (8)

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

Fields (84)

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
datefr WCEDATEFR Valid from
timefr WCETIMEFR ValidFrm Time
dateto WCEDATETO Valid to
timeto WCETIMETO Valid-To Time
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
crname WCECRNAME Created by
crdate WCECRDATE Created on
crtime WCECRTIME Created at
chname WCECHNAME Changed By
chdate WCECHDATE Changed on
chtime WCECHTIME Last Changed at
pspel PS_PSP_PNR WBS Element
aufnt CO_TEILNET Subnetwork of
vornr CN_VORNRT Activity
bdate CO_GSTRP Bas. start date
btime CO_GSUZP Start time
edate CO_GLTRP Basic fin. date
etime CO_GLUZP Basic Fin. Time
tsdate CO_GSTRS Sched. start
tstime CO_GSUZS SchedStartTime
tfdate CO_GLTRS Sched. finish
tftime CO_GLUZS Finish time
esdate WCEDATE Date
estime WCETIME Time
efdate WCEDATE Date
eftime WCETIME Time
lsdate WCEDATE Date
lstime WCETIME Time
lfdate WCEDATE Date
lftime WCETIME Time
psdate WCEDATE Date
pstime WCETIME Time
pfdate WCEDATE Date
pftime WCETIME Time
asdate CO_GSTRI Actual start
astime CO_GSUZI ActualStart
afdate CO_GLTRI Actual finish
aftime WCEAFTIME ActEndTime
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
dummy_wcahe_tmpl_incl_eew_ps CFD_DUMMY Dummy
dummy_wcaap_incl_eew_ps CFD_DUMMY Dummy
wt_no TTSE_WT_NO Op. Card No.
wt_desc TTSE_WT_DESC Description
shift_chief TTSE_APPROVED_BY Shift Chief
guardian TTSE_MONITORED_BY OT Guardian
operator TTSE_OPERATED_BY OT Operator
on_duty TTSE_VERIFIED_BY On Duty Responsible
start_date TTSE_DATE_START OT Start on
start_time TTSE_TIME_START Time
end_date TTSE_DATE_END OT End on
end_time TTSE_TIME_END Time
approve_date TTSE_APPROVE_DATE Approved on
approve_time TTSE_APPROVE_TIME Approval time

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]
    DATEFR,                        -- Valid from [WCEDATEFR]
    TIMEFR,                        -- ValidFrm Time [WCETIMEFR]
    DATETO,                        -- Valid to [WCEDATETO]
    TIMETO,                        -- Valid-To Time [WCETIMETO]
    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]
    CRNAME,                        -- Created by [WCECRNAME]
    CRDATE,                        -- Created on [WCECRDATE]
    CRTIME,                        -- Created at [WCECRTIME]
    CHNAME,                        -- Changed By [WCECHNAME]
    CHDATE,                        -- Changed on [WCECHDATE]
    CHTIME,                        -- Last Changed at [WCECHTIME]
    PSPEL,                         -- WBS Element [PS_PSP_PNR]
    AUFNT,                         -- Subnetwork of [CO_TEILNET]
    VORNR,                         -- Activity [CN_VORNRT]
    BDATE,                         -- Bas. start date [CO_GSTRP]
    BTIME,                         -- Start time [CO_GSUZP]
    EDATE,                         -- Basic fin. date [CO_GLTRP]
    ETIME,                         -- Basic Fin. Time [CO_GLUZP]
    TSDATE,                        -- Sched. start [CO_GSTRS]
    TSTIME,                        -- SchedStartTime [CO_GSUZS]
    TFDATE,                        -- Sched. finish [CO_GLTRS]
    TFTIME,                        -- Finish time [CO_GLUZS]
    ESDATE,                        -- Date [WCEDATE]
    ESTIME,                        -- Time [WCETIME]
    EFDATE,                        -- Date [WCEDATE]
    EFTIME,                        -- Time [WCETIME]
    LSDATE,                        -- Date [WCEDATE]
    LSTIME,                        -- Time [WCETIME]
    LFDATE,                        -- Date [WCEDATE]
    LFTIME,                        -- Time [WCETIME]
    PSDATE,                        -- Date [WCEDATE]
    PSTIME,                        -- Time [WCETIME]
    PFDATE,                        -- Date [WCEDATE]
    PFTIME,                        -- Time [WCETIME]
    ASDATE,                        -- Actual start [CO_GSTRI]
    ASTIME,                        -- ActualStart [CO_GSUZI]
    AFDATE,                        -- Actual finish [CO_GLTRI]
    AFTIME,                        -- ActEndTime [WCEAFTIME]
    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]
    DUMMY_WCAHE_TMPL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_WCAAP_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    WT_NO,                         -- Op. Card No. [TTSE_WT_NO]
    WT_DESC,                       -- Description [TTSE_WT_DESC]
    SHIFT_CHIEF,                   -- Shift Chief [TTSE_APPROVED_BY]
    GUARDIAN,                      -- OT Guardian [TTSE_MONITORED_BY]
    OPERATOR,                      -- OT Operator [TTSE_OPERATED_BY]
    ON_DUTY,                       -- On Duty Responsible [TTSE_VERIFIED_BY]
    START_DATE,                    -- OT Start on [TTSE_DATE_START]
    START_TIME,                    -- Time [TTSE_TIME_START]
    END_DATE,                      -- OT End on [TTSE_DATE_END]
    END_TIME,                      -- Time [TTSE_TIME_END]
    APPROVE_DATE,                  -- Approved on [TTSE_APPROVE_DATE]
    APPROVE_TIME,                  -- Approval time [TTSE_APPROVE_TIME]
    PRIMARY KEY (MANDT, WCNR)
);

Learn More