I_HZDSSUBSTINVENTORY

CDS View
4 Fields 10 CDS Views

HSI: Interface View

I_HZDSSUBSTINVENTORY is a CDS View in S/4HANA. HSI: Interface View. It contains 4 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ChemicalOfHzdsSubstInvtryVH view inner CONSUMPTION Chemical from hazardous substance inventory value help
C_HzdsSubstInventoryFreeLoc view left_outer CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view left_outer CONSUMPTION HSI: Location Value Help
I_BldngForHzdsSubstInvtryActv view from COMPOSITE HSI: Buildings belong to active HSI
I_HzdsSubstInventoryCountry view from BASIC Hazardous Substance Inventory Country
I_HzdsSubstInventoryTP view from TRANSACTIONAL HSI: 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_FactoryJargonForSubstance view from COMPOSITE Factory Jargon for Chemicals

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser SafetyRelevantChgNotifProcgUsr 1
KEY EHSLocationUUID EHSLocationUUID 2
HzdsSubstInventoryStatus HzdsSubstInventoryStatus 2
HzdsSubstInventoryUUID HzdsSubstInventoryUUID,SftyRlvtChgAffcdObjRelatedUUID 2

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.

-- HSI: Interface View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_HZDSSUBSTINVENTORY (
    CREATEDBYUSER,
    EHSLOCATIONUUID,
    HZDSSUBSTINVENTORYSTATUS,
    HZDSSUBSTINVENTORYUUID,
    PRIMARY KEY (CREATEDBYUSER, EHSLOCATIONUUID)
);

Learn More