I_HZDSSUBSTINVENTORYITEM

CDS View
4 Fields 6 CDS Views

HSI: Item Interface View

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_ChemicalOfHzdsSubstInvtryVH view inner CONSUMPTION Chemical from hazardous substance inventory value help
I_HzdsSubstInventoryInfo view from COMPOSITE HSI Info: Composite View
I_HzdsSubstInventoryItemCount view from COMPOSITE HSI: Count of Substance Inventory Items
I_HzdsSubstInventoryItemTP view from TRANSACTIONAL HSI: Item Transactional View
I_HzdsSubstInvtryCmpltdItmCnt view from COMPOSITE Basic View for Number of Completed Items
P_FactoryJargonForSubstance view inner COMPOSITE Factory Jargon for Chemicals

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ChemicalUUID ChemicalUUID 1
KEY HzdsSubstInventoryItemUUID HzdsSubstInventoryItemUUID 2
KEY HzdsSubstInventoryUUID HzdsSubstInventoryUUID 2
FactoryJargonForSubstance FactoryJargonForSubstance 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: Item Interface View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_HZDSSUBSTINVENTORYITEM (
    CHEMICALUUID,
    HZDSSUBSTINVENTORYITEMUUID,
    HZDSSUBSTINVENTORYUUID,
    FACTORYJARGONFORSUBSTANCE,
    PRIMARY KEY (CHEMICALUUID, HZDSSUBSTINVENTORYITEMUUID, HZDSSUBSTINVENTORYUUID)
);

Learn More