WRKPMTSFTYCERT_D

Transparent Table Application Table
17 Fields 2 CDS Views

Draft table for entity R_WRKPMTSAFETYCERTIFICATETP

WRKPMTSFTYCERT_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTSAFETYCERTIFICATETP. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtSftyCertDraft view_entity from EXTENSION Work Permit Safety Certificate Draft-Ext
R_WrkPmtSftyCertDraft view_entity from BASIC Work Permit Safety Certificate - Draft

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workpermitinternalid j_objnr Object number
KEY safetycertificateinternalid j_objnr Object number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
workpermitobjecttype wcefatherart 1st ObjTyp
sftycertwrkpmtobjecttype wcechildart 2nd ObjTyp
sftycertprocessingcontext ptwewrkpmtprocessingcontext Processing Context
safetycertificatetype wceusage Usage
sftycertificatetypedescription ptwesftycerttext Sfty Cert Type Desc
validfromdatetime timestamp Time Stamp
validtodatetime timestamp Time Stamp
workpermit wcewapinr Application
safetycertificate wcewcnr WC Document
sftycertdesc wcestxt Short Text
maintenanceplanningplant iwerk Planning Plant
sftycertprocessingstatustext val_text Short Description

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.

-- Draft table for entity R_WRKPMTSAFETYCERTIFICATETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTSFTYCERT_D (
    MANDT,                           -- Client [mandt]
    WORKPERMITINTERNALID,            -- Object number [j_objnr]
    SAFETYCERTIFICATEINTERNALID,     -- Object number [j_objnr]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    WORKPERMITOBJECTTYPE,            -- 1st ObjTyp [wcefatherart]
    SFTYCERTWRKPMTOBJECTTYPE,        -- 2nd ObjTyp [wcechildart]
    SFTYCERTPROCESSINGCONTEXT,       -- Processing Context [ptwewrkpmtprocessingcontext]
    SAFETYCERTIFICATETYPE,           -- Usage [wceusage]
    SFTYCERTIFICATETYPEDESCRIPTION,  -- Sfty Cert Type Desc [ptwesftycerttext]
    VALIDFROMDATETIME,               -- Time Stamp [timestamp]
    VALIDTODATETIME,                 -- Time Stamp [timestamp]
    WORKPERMIT,                      -- Application [wcewapinr]
    SAFETYCERTIFICATE,               -- WC Document [wcewcnr]
    SFTYCERTDESC,                    -- Short Text [wcestxt]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [iwerk]
    SFTYCERTPROCESSINGSTATUSTEXT,    -- Short Description [val_text]
    PRIMARY KEY (MANDT, WORKPERMITINTERNALID, SAFETYCERTIFICATEINTERNALID, DRAFTUUID)
);

Learn More