I_LSTDSUBSTWTHVARANDGRP

CDS View
3 Fields 6 CDS Views

Listed Substance View

I_LSTDSUBSTWTHVARANDGRP is a CDS View in S/4HANA. Listed Substance View. It contains 3 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_HzdsSubstInvtryHzdsIngrdntVH view from CONSUMPTION Value help for Hazardous Ingredients
I_CmplRqVersSubstListGrpSubst view inner BASIC Substance Group per Substance List
I_ListedSubstance view from COMPOSITE Listed Substance View
I_ListedSubstanceGroup view from BASIC Listed Substance Group View
I_ListedSubstMigrationVH view from COMPOSITE Listed Substance Migration
P_NameOnGrpMbrListRptblQty view_entity inner COMPOSITE

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ListedSubstanceUUID ListedSubstanceUUID 2
CASNumber CASNumber 2
ECNumber ECNumber 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.

-- Listed Substance View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LSTDSUBSTWTHVARANDGRP (
    LISTEDSUBSTANCEUUID,
    CASNUMBER,
    ECNUMBER,
    PRIMARY KEY (LISTEDSUBSTANCEUUID)
);

Learn More