I_SAFETYINSTRUCTION

CDS View
3 Fields 16 CDS Views

Safety Instruction Interface View

I_SAFETYINSTRUCTION is a CDS View in S/4HANA. Safety Instruction Interface View. It contains 3 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_EquipSafetyInstructionFDP view from CONSUMPTION SI for Equip.: Root Cons. View for FDP
C_EquipSafetyInstructionIDVH view from CONSUMPTION Equip Safety Instruction ID
C_GenericSafetyInstructionFDP view from CONSUMPTION Generic SI: Root Consump. View for FDP
C_GnrcSafetyInstructionIDVH view from CONSUMPTION Generic Safety Instruction ID
C_SafetyInstructionIDVH view from CONSUMPTION Chemical Safety Instruction ID
C_SubstSafetyInstructionFDP view from CONSUMPTION SI for Subst.: Root Cons. View for FDP
C_SubstSafetyInstructionIDVH view from CONSUMPTION Subst Safety Instruction ID
I_ReldSafetyInstructionIDVH view_entity from COMPOSITE Equip Safety Instruction ID
I_SafetyInstructionTP view from TRANSACTIONAL FSI: Transactional View
I_SftyRlvtChgAffcdObjAddlInfo view inner COMPOSITE SRC: Affected Object Additional Info
I_SftyRlvtChgAffcdObjUser view left_outer COMPOSITE SRC: Relevant Affected Objects for Users
I_SftyRlvtChgAffcdObjUser_2 view inner COMPOSITE SRC: Relevant Affected Objects for Users
P_GnrcSftyInstrnStrucById view_entity inner CONSUMPTION SI Structure for Generic SIs
P_ReldSafetyInstructionAtLoc view_entity from COMPOSITE Private view SI at location
P_ReldSafetyInstructionAtLoc view_entity union_all COMPOSITE Private view SI at location
P_SftyInstrnChapterStrucInfo view inner CONSUMPTION Private view to get SI chapter structure info

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser SafetyRelevantChgNotifProcgUsr 1
KEY FactoryEHSLocationUUID EHSLocationUUID 1
KEY SafetyInstructionUUID SafetyInstructionUUID,SftyRlvtChgAffcdObjRelatedUUID 4

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 Instruction Interface View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SAFETYINSTRUCTION (
    CREATEDBYUSER,
    FACTORYEHSLOCATIONUUID,
    SAFETYINSTRUCTIONUUID,
    PRIMARY KEY (CREATEDBYUSER, FACTORYEHSLOCATIONUUID, SAFETYINSTRUCTIONUUID)
);

Learn More