I_CMPLRQVERSTHLDLISTITM

CDS View
8 Fields 3 CDS Views

Thresholds at Listed Substances on Substance Lists

I_CMPLRQVERSTHLDLISTITM is a CDS View in S/4HANA. Thresholds at Listed Substances on Substance Lists. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CmplRqVersRgtyListItmName view from COMPOSITE Regulatory list specific name of listed substances
P_CmplRqVersThldListItmDtls view from COMPOSITE Details of Threshold based Substance Lists
P_SubstanceSubstListUnion view_entity union_all CONSUMPTION Substance Lists of Substances

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CmplRqVers CmplRqVers 1
KEY ListedSubstance ListedSubstance 2
KEY SubstanceListItmUUID SubstanceListItmUUID 2
KEY SubstanceListUUID SubstanceListUUID 3
CmplRqVersUUID CmplRqVersUUID 2
SubstanceListItmAddlInfo SubstanceListItmAddlInfo 2
SubstanceListItmThreshold SubstanceListItmThreshold 1
SubstanceListItmThresholdUoM SubstanceListItmThresholdUoM 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.

-- Thresholds at Listed Substances on Substance Lists
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSTHLDLISTITM (
    CMPLRQVERS,
    LISTEDSUBSTANCE,
    SUBSTANCELISTITMUUID,
    SUBSTANCELISTUUID,
    CMPLRQVERSUUID,
    SUBSTANCELISTITMADDLINFO,
    SUBSTANCELISTITMTHRESHOLD,
    SUBSTANCELISTITMTHRESHOLDUOM,
    PRIMARY KEY (CMPLRQVERS, LISTEDSUBSTANCE, SUBSTANCELISTITMUUID, SUBSTANCELISTUUID)
);

Learn More