I_CMPLRQVERSTHLDLISTITM

CDS View
8 Fields 4 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. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CmplRqVersRgtyListItmName view from COMPOSITE Regulatory list specific name of listed substances
I_CmplRqVersSubstListGrpSubst view from BASIC Substance Group per Substance List
P_CmplRqVersThldListItmDtls view from COMPOSITE
P_SubstanceSubstListUnion view_entity union_all CONSUMPTION Substance Lists of Substances

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CmplRqVers CmplRqVers 1
KEY CmplRqVersUUID CmplRqVersUUID 3
KEY ListedSubstance ListedSubstance,ListedSubstanceGroup 3
KEY SubstanceListItmUUID SubstanceListItmUUID 2
KEY SubstanceListUUID SubstanceListUUID 4
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,
    CMPLRQVERSUUID,
    LISTEDSUBSTANCE,
    SUBSTANCELISTITMUUID,
    SUBSTANCELISTUUID,
    SUBSTANCELISTITMADDLINFO,
    SUBSTANCELISTITMTHRESHOLD,
    SUBSTANCELISTITMTHRESHOLDUOM,
    PRIMARY KEY (CMPLRQVERS, CMPLRQVERSUUID, LISTEDSUBSTANCE, SUBSTANCELISTITMUUID, SUBSTANCELISTUUID)
);

Learn More