SFTYCERTTAPPRV_D

Transparent Table Application Table
30 Fields 2 CDS Views

Draft table for entity R_SFTYCERTTEMPLATEAPPROVALTP

SFTYCERTTAPPRV_D is an SAP database table in S/4HANA. Draft table for entity R_SFTYCERTTEMPLATEAPPROVALTP. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SftyCertTmplApprovalDraft view_entity from EXTENSION Sfty Cert Tmpl Approval - Extension
R_SftyCertTmplApprovalDraft view_entity from BASIC Sfty Cert Tmpl Approval Draft

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY safetycertificateinternalid J_OBJNR Object number
KEY numberofsftycertapprovals I_COUNT Counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
safetycertificateapprovalcode PMSOG Permit
safetycertificate WCEWCNR WC Document
sftycerthaslongtext KZLTG Long 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
sftycertapprovalismandatory WCEFLGMAND App. Mandatory
sftycertapprvlhierlevelvalue WCEHILVL Hierarchy Level
sftycertapprvlmandtext abap.char
textobjectkey TDOBNAME Text Name
plainlongtext ESH_E_SR_LONGTEXT Long Text
sftycertsftyrqmtcritltycode EAM_CRITICALITY Criticality
maintenanceplanningplant IWERK Planning Plant
safetycertificatetype WCEUSAGE Usage
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
dummy_sc_tmpl_apr_incl_eew_ps CFD_DUMMY Dummy

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_SFTYCERTTEMPLATEAPPROVALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SFTYCERTTAPPRV_D (
    MANDT,                           -- Client [MANDT]
    SAFETYCERTIFICATEINTERNALID,     -- Object number [J_OBJNR]
    NUMBEROFSFTYCERTAPPROVALS,       -- Counter [I_COUNT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    SAFETYCERTIFICATEAPPROVALCODE,   -- Permit [PMSOG]
    SAFETYCERTIFICATE,               -- WC Document [WCEWCNR]
    SFTYCERTHASLONGTEXT,             -- Long text [KZLTG]
    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]
    SFTYCERTAPPROVALISMANDATORY,     -- App. Mandatory [WCEFLGMAND]
    SFTYCERTAPPRVLHIERLEVELVALUE,    -- Hierarchy Level [WCEHILVL]
    SFTYCERTAPPRVLMANDTEXT,          -- abap.char
    TEXTOBJECTKEY,                   -- Text Name [TDOBNAME]
    PLAINLONGTEXT,                   -- Long Text [ESH_E_SR_LONGTEXT]
    SFTYCERTSFTYRQMTCRITLTYCODE,     -- Criticality [EAM_CRITICALITY]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    SAFETYCERTIFICATETYPE,           -- Usage [WCEUSAGE]
    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]
    DUMMY_SC_TMPL_APR_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SAFETYCERTIFICATEINTERNALID, NUMBEROFSFTYCERTAPPROVALS, DRAFTUUID)
);

Learn More