SFTYCERTTAPRSG_D

Transparent Table Application Table
33 Fields 2 CDS Views

Draft table for entity R_SFTYCERTTMPLAPPRVLSEGMENTTP

SFTYCERTTAPRSG_D is an SAP database table in S/4HANA. Draft table for entity R_SFTYCERTTMPLAPPRVLSEGMENTTP. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SftyCertTmplApprvlHistDraft view_entity from EXTENSION Sfty Cert Tmpl Apprvl Sgmt - Extn
R_SftyCertTmplApprvlSgmtDraft view_entity from BASIC Sfty Cert Tmpl Apprvl Sgmt Draft

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY safetycertificateinternalid J_OBJNR Object number
KEY sftycertapprovalsegmentvalue I_COUNT Counter
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
sftycertapprovalenteredbyuser GENNAME Entered by
sftycertapprovalentrydate GENDATUM Created on
sftycertapprovalentrytime GENVTIME Entered At
approvaldatetime TIMESTAMP Time Stamp
sftycertapprovedfromdate GENVDATE App.fr date
sftycertapprovedtodate GENBDATE App.to date
sftycertapprovedfromtime GENVTIME Entered At
sftycertapprovedtotime GENBTIME AppToTime
sftycertapprovaldactvtdbyusr GENINAME Deactivated by
sftycertapprvldeactivationdate GENIDATE Deactivated on
sftycertapprvldeactivationtime GENITIME Deactivated at
sftycertrevokedatetime TIMESTAMP Time Stamp
sftycertapprvlsgmtisinactive GENIAKT Permit inactive
sftycertificateapprovalcomment PTWEWORKPERMITAPPROVALCOMMENT Approval Comment
sftycertapprovaldescription GNTXT Permit Text
textobjectkey TDOBNAME Text Name
sftycertrevokelongtextkey TDOBNAME Text Name
plainlongtext ESH_E_SR_LONGTEXT Long Text
sftycertrevokelongtext ESH_E_SR_LONGTEXT Long 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_SFTYCERTTMPLAPPRVLSEGMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SFTYCERTTAPRSG_D (
    MANDT,                           -- Client [MANDT]
    SAFETYCERTIFICATEINTERNALID,     -- Object number [J_OBJNR]
    SFTYCERTAPPROVALSEGMENTVALUE,    -- Counter [I_COUNT]
    NUMBEROFSFTYCERTAPPROVALS,       -- Counter [I_COUNT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    SAFETYCERTIFICATEAPPROVALCODE,   -- Permit [PMSOG]
    SAFETYCERTIFICATE,               -- WC Document [WCEWCNR]
    SFTYCERTAPPROVALENTEREDBYUSER,   -- Entered by [GENNAME]
    SFTYCERTAPPROVALENTRYDATE,       -- Created on [GENDATUM]
    SFTYCERTAPPROVALENTRYTIME,       -- Entered At [GENVTIME]
    APPROVALDATETIME,                -- Time Stamp [TIMESTAMP]
    SFTYCERTAPPROVEDFROMDATE,        -- App.fr date [GENVDATE]
    SFTYCERTAPPROVEDTODATE,          -- App.to date [GENBDATE]
    SFTYCERTAPPROVEDFROMTIME,        -- Entered At [GENVTIME]
    SFTYCERTAPPROVEDTOTIME,          -- AppToTime [GENBTIME]
    SFTYCERTAPPROVALDACTVTDBYUSR,    -- Deactivated by [GENINAME]
    SFTYCERTAPPRVLDEACTIVATIONDATE,  -- Deactivated on [GENIDATE]
    SFTYCERTAPPRVLDEACTIVATIONTIME,  -- Deactivated at [GENITIME]
    SFTYCERTREVOKEDATETIME,          -- Time Stamp [TIMESTAMP]
    SFTYCERTAPPRVLSGMTISINACTIVE,    -- Permit inactive [GENIAKT]
    SFTYCERTIFICATEAPPROVALCOMMENT,  -- Approval Comment [PTWEWORKPERMITAPPROVALCOMMENT]
    SFTYCERTAPPROVALDESCRIPTION,     -- Permit Text [GNTXT]
    TEXTOBJECTKEY,                   -- Text Name [TDOBNAME]
    SFTYCERTREVOKELONGTEXTKEY,       -- Text Name [TDOBNAME]
    PLAINLONGTEXT,                   -- Long Text [ESH_E_SR_LONGTEXT]
    SFTYCERTREVOKELONGTEXT,          -- Long Text [ESH_E_SR_LONGTEXT]
    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, SAFETYCERTIFICATEINTERNALID, SFTYCERTAPPROVALSEGMENTVALUE, NUMBEROFSFTYCERTAPPROVALS, DRAFTUUID)
);

Learn More