I_CMPLRQVERSRGTYLISTITMENHCD

CDS View
9 Fields 2 CDS Views

Enhanced composite view for the items of a regulatory list

I_CMPLRQVERSRGTYLISTITMENHCD is a CDS View in S/4HANA. Enhanced composite view for the items of a regulatory list. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CmplRqVersThldListItmDtls view inner COMPOSITE
P_DstctSubAsSubLiChkRstrcnList view inner CONSUMPTION

Fields (9)

KeyField CDS FieldsUsed in Views
KEY SubstanceListItmUUID SubstanceListItmUUID 1
CASNumber CASNumber 2
ECNumber ECNumber 1
ListedSubstanceCndn ListedSubstanceCndn 1
ListedSubstanceCndnName ListedSubstanceCndnName 2
ListedSubstanceIsGroup ListedSubstanceIsGroup 1
ListedSubstanceName ListedSubstanceName 1
MolecularFormula MolecularFormula 1
SubstanceListItmAddlInfo SubstanceListItmAddlInfo 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.

-- Enhanced composite view for the items of a regulatory list
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSRGTYLISTITMENHCD (
    SUBSTANCELISTITMUUID,
    CASNUMBER,
    ECNUMBER,
    LISTEDSUBSTANCECNDN,
    LISTEDSUBSTANCECNDNNAME,
    LISTEDSUBSTANCEISGROUP,
    LISTEDSUBSTANCENAME,
    MOLECULARFORMULA,
    SUBSTANCELISTITMADDLINFO,
    PRIMARY KEY (SUBSTANCELISTITMUUID)
);

Learn More