SCTMPLWPTMPL_D

Transparent Table Application Table
19 Fields 2 CDS Views

Draft table for entity R_SFTYCERTTMPLWRKPMTTEMPLATETP

SCTMPLWPTMPL_D is an SAP database table in S/4HANA. Draft table for entity R_SFTYCERTTMPLWRKPMTTEMPLATETP. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SftyCertTmplWrkPmtTmplDraft view_entity from EXTENSION Sfty Cert Tmpl Wrk Pmt Template - Extn
R_SftyCertTmplWrkPmtTmplDraft view_entity from BASIC Sfty Cert Tmpl Wrk Pmt Template

Fields (19)

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
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_SFTYCERTTMPLWRKPMTTEMPLATETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCTMPLWPTMPL_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]
    OPERATIONWORKCENTERINTERNALID,  -- Object ID [cr_objid]
    OBJECTTYPECODE,                 -- Object Type [cr_objty]
    WORKCENTERTEXT,                 -- Work Center Text [workcentertext]
    PRIMARY KEY (MANDT, SAFETYCERTIFICATEINTERNALID, WORKPERMITINTERNALID, DRAFTUUID)
);

Learn More