SFTYCERTAPPRV_D

Transparent Table Application Table
25 Fields 1 CDS Views

Draft table for entity R_WRKPMTSFTYCERTAPPROVALTP

SFTYCERTAPPRV_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTSFTYCERTAPPROVALTP. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WrkPmtSftyCertApprovalDraft view_entity from BASIC Wrk Pmt Sfty Cert Approval Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY safetycertificateinternalid j_objnr Object number
KEY numberofsftycertapprovals i_count Counter
KEY workpermitinternalid j_objnr Object number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
workpermit wcewapinr Application
safetycertificateapprovalcode pmsog Permit
safetycertificate wcewcnr WC Document
sftycertdesc wcestxt Short Text
creationdate erdat Created On
createdbyuser ernam Created By
lastchangeddate aedat Changed On
lastchangedbyuser aenam Changed By
sftycertificateapprovalcomment ptweworkpermitapprovalcomment Approval Comment
sftycertapprovaldescription gntxt Permit Text
sftycertificateapprovalstatus ptweworkpermitapprovalstatus Approval Status
textobjectkey tdobname Text Name
plainlongtext esh_e_sr_longtext Long Text
sftycertsftyrqmtcritltycode eam_criticality Criticality
maintenanceplanningplant iwerk Planning Plant
safetycertificatetype wceusage Usage
sftycertificatetypedescription ptwesftycerttext Sfty Cert Type Desc
domaintext val_text Short Description
sftycertapprvlisprocrelevant ptwesftycertapprvprocessind Proc Relvncy Ind

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_WRKPMTSFTYCERTAPPROVALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SFTYCERTAPPRV_D (
    MANDT,                           -- Client [mandt]
    SAFETYCERTIFICATEINTERNALID,     -- Object number [j_objnr]
    NUMBEROFSFTYCERTAPPROVALS,       -- Counter [i_count]
    WORKPERMITINTERNALID,            -- Object number [j_objnr]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    WORKPERMIT,                      -- Application [wcewapinr]
    SAFETYCERTIFICATEAPPROVALCODE,   -- Permit [pmsog]
    SAFETYCERTIFICATE,               -- WC Document [wcewcnr]
    SFTYCERTDESC,                    -- Short Text [wcestxt]
    CREATIONDATE,                    -- Created On [erdat]
    CREATEDBYUSER,                   -- Created By [ernam]
    LASTCHANGEDDATE,                 -- Changed On [aedat]
    LASTCHANGEDBYUSER,               -- Changed By [aenam]
    SFTYCERTIFICATEAPPROVALCOMMENT,  -- Approval Comment [ptweworkpermitapprovalcomment]
    SFTYCERTAPPROVALDESCRIPTION,     -- Permit Text [gntxt]
    SFTYCERTIFICATEAPPROVALSTATUS,   -- Approval Status [ptweworkpermitapprovalstatus]
    TEXTOBJECTKEY,                   -- Text Name [tdobname]
    PLAINLONGTEXT,                   -- Long Text [esh_e_sr_longtext]
    SFTYCERTSFTYRQMTCRITLTYCODE,     -- Criticality [eam_criticality]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [iwerk]
    SAFETYCERTIFICATETYPE,           -- Usage [wceusage]
    SFTYCERTIFICATETYPEDESCRIPTION,  -- Sfty Cert Type Desc [ptwesftycerttext]
    DOMAINTEXT,                      -- Short Description [val_text]
    SFTYCERTAPPRVLISPROCRELEVANT,    -- Proc Relvncy Ind [ptwesftycertapprvprocessind]
    PRIMARY KEY (MANDT, SAFETYCERTIFICATEINTERNALID, NUMBEROFSFTYCERTAPPROVALS, WORKPERMITINTERNALID, DRAFTUUID)
);

Learn More