SFTYCERWRKPMT_D

Transparent Table Application Table
20 Fields 2 CDS Views

Draft table for entity R_SAFETYCERTIFICATEWRKPMTTP

SFTYCERWRKPMT_D is an SAP database table in S/4HANA. Draft table for entity R_SAFETYCERTIFICATEWRKPMTTP. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SftyCertWorkPermitDraft view_entity from EXTENSION Safety Certificate Work Permit Drft- Ext
R_SftyCertWorkPermitDraft view_entity from BASIC Safety Certificate Work Permit Draft

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY safetycertificateinternalid j_objnr Object number
KEY workpermitinternalid j_objnr Object number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
safetycertificate wcewcnr WC Document
workpermit wcewapinr Application
maintenanceplanningplant iwerk Planning Plant
workpermittype wceusage Usage
workpermitprocessingstatus ptweworkpermitprocessingstatus Processing State
workcenter pph_arbpl Work Center
validfromdatetime timestamp Time Stamp
validtodatetime timestamp Time Stamp
sftycertwrkpmtobjecttype wcechildart 2nd ObjTyp
workpermitobjecttype wcefatherart 1st ObjTyp
sftycertprocessingcontext ptwewrkpmtprocessingcontext Processing Context
isreferencedocument ptweisreferencedocument
operationworkcenterinternalid cr_objid Object ID
objecttypecode cr_objty Object Type
workcentertext workcentertext Work Center Text

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_SAFETYCERTIFICATEWRKPMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SFTYCERWRKPMT_D (
    MANDT,                          -- Client [mandt]
    SAFETYCERTIFICATEINTERNALID,    -- Object number [j_objnr]
    WORKPERMITINTERNALID,           -- Object number [j_objnr]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    SAFETYCERTIFICATE,              -- WC Document [wcewcnr]
    WORKPERMIT,                     -- Application [wcewapinr]
    MAINTENANCEPLANNINGPLANT,       -- Planning Plant [iwerk]
    WORKPERMITTYPE,                 -- Usage [wceusage]
    WORKPERMITPROCESSINGSTATUS,     -- Processing State [ptweworkpermitprocessingstatus]
    WORKCENTER,                     -- Work Center [pph_arbpl]
    VALIDFROMDATETIME,              -- Time Stamp [timestamp]
    VALIDTODATETIME,                -- Time Stamp [timestamp]
    SFTYCERTWRKPMTOBJECTTYPE,       -- 2nd ObjTyp [wcechildart]
    WORKPERMITOBJECTTYPE,           -- 1st ObjTyp [wcefatherart]
    SFTYCERTPROCESSINGCONTEXT,      -- Processing Context [ptwewrkpmtprocessingcontext]
    ISREFERENCEDOCUMENT,            -- ptweisreferencedocument
    OPERATIONWORKCENTERINTERNALID,  -- Object ID [cr_objid]
    OBJECTTYPECODE,                 -- Object Type [cr_objty]
    WORKCENTERTEXT,                 -- Work Center Text [workcentertext]
    PRIMARY KEY (MANDT, SAFETYCERTIFICATEINTERNALID, WORKPERMITINTERNALID, DRAFTUUID)
);

Learn More