WRKPMTTSFTYCTT_D

Transparent Table Application Table
27 Fields 2 CDS Views

Draft table for entity R_WRKPMTTMPLSFTYCERTTEMPLATETP

WRKPMTTSFTYCTT_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTTMPLSFTYCERTTEMPLATETP. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtTmplSftyCertTmplDraft view_entity from EXTENSION Wrk Pmt Tmpl Sfty Cert Tmpl - Extn
R_WrkPmtTmplSftyCertTmplDraft view_entity from BASIC Wrk Pmt Tmpl Sfty Cert Tmpl Draft

Fields (27)

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
workpermit WCEWAPINR Application
wrkpmtmgmtobjsubtype WCETYP Object Type
safetycertificate WCEWCNR WC Document
sftycertdesc WCESTXT Short Text
maintenanceplanningplant IWERK Planning Plant
safetycertificatetype WCEUSAGE Usage
workcenter PPH_ARBPL Work Center
validfromdatetime TIMESTAMP Time Stamp
validtodatetime TIMESTAMP Time Stamp
sftycertwrkpmtobjecttype WCECHILDART 2nd ObjTyp
workpermitobjecttype WCEFATHERART 1st ObjTyp
sftycertprocessingstatus PTWDSFTYCERTPROCESSINGSTATUS Proc Stat Sfty Cert
sftycertprocessingcontext PTWEWRKPMTPROCESSINGCONTEXT Processing Context
operationworkcenterinternalid CR_OBJID Object ID
objecttypecode CR_OBJTY Object Type
workcentertext WORKCENTERTEXT Work Center Text
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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_WRKPMTTMPLSFTYCERTTEMPLATETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTTSFTYCTT_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]
    WORKPERMIT,                     -- Application [WCEWAPINR]
    WRKPMTMGMTOBJSUBTYPE,           -- Object Type [WCETYP]
    SAFETYCERTIFICATE,              -- WC Document [WCEWCNR]
    SFTYCERTDESC,                   -- Short Text [WCESTXT]
    MAINTENANCEPLANNINGPLANT,       -- Planning Plant [IWERK]
    SAFETYCERTIFICATETYPE,          -- Usage [WCEUSAGE]
    WORKCENTER,                     -- Work Center [PPH_ARBPL]
    VALIDFROMDATETIME,              -- Time Stamp [TIMESTAMP]
    VALIDTODATETIME,                -- Time Stamp [TIMESTAMP]
    SFTYCERTWRKPMTOBJECTTYPE,       -- 2nd ObjTyp [WCECHILDART]
    WORKPERMITOBJECTTYPE,           -- 1st ObjTyp [WCEFATHERART]
    SFTYCERTPROCESSINGSTATUS,       -- Proc Stat Sfty Cert [PTWDSFTYCERTPROCESSINGSTATUS]
    SFTYCERTPROCESSINGCONTEXT,      -- Processing Context [PTWEWRKPMTPROCESSINGCONTEXT]
    OPERATIONWORKCENTERINTERNALID,  -- Object ID [CR_OBJID]
    OBJECTTYPECODE,                 -- Object Type [CR_OBJTY]
    WORKCENTERTEXT,                 -- Work Center Text [WORKCENTERTEXT]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, WORKPERMITINTERNALID, SAFETYCERTIFICATEINTERNALID, DRAFTUUID)
);

Learn More