I_SAFETYCERTIFICATEAPPROVAL

CDS View

Approvals for Safety Certificate

I_SAFETYCERTIFICATEAPPROVAL is a CDS View in S/4HANA. Approvals for Safety Certificate. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_WrkPmtSftyCertApproval view from COMPOSITE Wrk Pmt Sfty Cert Approval
R_SafetyCertificateApprovalTP view_entity from TRANSACTIONAL Approval root entity
R_SftyCertTemplateApprovalTP view_entity from TRANSACTIONAL Safety Certificate Template Approval

Fields (18)

KeyField CDS FieldsUsed in Views
KEY NumberOfSftyCertApprovals NumberOfSftyCertApprovals 1
KEY SafetyCertificateInternalID SafetyCertificateInternalID 1
_ApprovalDetails _ApprovalDetails 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
DomainText DomainText 1
LastChangedByUser LastChangedByUser 1
LastChangedDate LastChangedDate 1
MaintenancePlanningPlant MaintenancePlanningPlant 1
SafetyCertificate SafetyCertificate 1
SafetyCertificateApprovalCode SafetyCertificateApprovalCode 1
SafetyCertificateType SafetyCertificateType 1
SftyCertApprovalDescription SftyCertApprovalDescription 1
SftyCertApprvlIsProcRelevant SftyCertApprvlIsProcRelevant 1
SftyCertHasLongText SftyCertHasLongText 1
SftyCertificateApprovalComment SftyCertificateApprovalComment 1
SftyCertificateApprovalStatus SftyCertificateApprovalStatus 1
TextObjectKey TextObjectKey 1

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.

-- Approvals for Safety Certificate
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SAFETYCERTIFICATEAPPROVAL (
    NUMBEROFSFTYCERTAPPROVALS,
    SAFETYCERTIFICATEINTERNALID,
    _APPROVALDETAILS,
    CREATEDBYUSER,
    CREATIONDATE,
    DOMAINTEXT,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    MAINTENANCEPLANNINGPLANT,
    SAFETYCERTIFICATE,
    SAFETYCERTIFICATEAPPROVALCODE,
    SAFETYCERTIFICATETYPE,
    SFTYCERTAPPROVALDESCRIPTION,
    SFTYCERTAPPRVLISPROCRELEVANT,
    SFTYCERTHASLONGTEXT,
    SFTYCERTIFICATEAPPROVALCOMMENT,
    SFTYCERTIFICATEAPPROVALSTATUS,
    TEXTOBJECTKEY,
    PRIMARY KEY (NUMBEROFSFTYCERTAPPROVALS, SAFETYCERTIFICATEINTERNALID)
);