I_WORKPERMITSAFETYCERTIFICATE

CDS View
13 Fields 2 CDS Views

Safety Certificate in Work Permit

I_WORKPERMITSAFETYCERTIFICATE is a CDS View in S/4HANA. Safety Certificate in Work Permit. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WrkPmtSftyCertApproval view inner COMPOSITE Wrk Pmt Sfty Cert Approval
R_WrkPmtSafetyCertificateTP view_entity from TRANSACTIONAL Safety Certificate in Work Permit

Fields (13)

KeyField CDS FieldsUsed in Views
KEY SafetyCertificateInternalID SafetyCertificateInternalID 1
KEY WorkPermitInternalID WorkPermitInternalID 2
MaintenancePlanningPlant MaintenancePlanningPlant 1
SafetyCertificate SafetyCertificate 1
SafetyCertificateType SafetyCertificateType 1
SftyCertDesc SftyCertDesc 2
SftyCertificateTypeDescription SftyCertificateTypeDescription 1
SftyCertProcessingContext SftyCertProcessingContext 1
SftyCertWrkPmtObjectType SftyCertWrkPmtObjectType 1
ValidFromDateTime ValidFromDateTime 1
ValidToDateTime ValidToDateTime 1
WorkPermit WorkPermit 2
WorkPermitObjectType WorkPermitObjectType 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.

-- Safety Certificate in Work Permit
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKPERMITSAFETYCERTIFICATE (
    SAFETYCERTIFICATEINTERNALID,
    WORKPERMITINTERNALID,
    MAINTENANCEPLANNINGPLANT,
    SAFETYCERTIFICATE,
    SAFETYCERTIFICATETYPE,
    SFTYCERTDESC,
    SFTYCERTIFICATETYPEDESCRIPTION,
    SFTYCERTPROCESSINGCONTEXT,
    SFTYCERTWRKPMTOBJECTTYPE,
    VALIDFROMDATETIME,
    VALIDTODATETIME,
    WORKPERMIT,
    WORKPERMITOBJECTTYPE,
    PRIMARY KEY (SAFETYCERTIFICATEINTERNALID, WORKPERMITINTERNALID)
);

Learn More