I_CMPLRQVERSSUBSTANCELIST

CDS View
8 Fields 17 CDS Views

Substance List View

I_CMPLRQVERSSUBSTANCELIST is a CDS View in S/4HANA. Substance List View. It contains 8 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
I_CmplRqVersRgtyListDimn view inner COMPOSITE Dimension Monitoring List
I_CmplRqVersSubstListAssgmt view inner COMPOSITE Substance List Assignment View
I_CmplRqVersSubstListName view inner COMPOSITE Compliance Req Substance List Name with Language Fallback
P_CmplRqLatestSubstanceList view inner COMPOSITE
P_CmplRqSubstanceListMaxDate view from COMPOSITE
P_CmplRqVersListTypeCount view from CONSUMPTION
P_DstctSubAsSubLiChkRstrcnList view inner CONSUMPTION
P_ListSubstGrpMemberFBAllLang view_entity inner COMPOSITE
P_NameOnGrpMbrListRptblQty view_entity inner COMPOSITE
P_NameOnListFallbackInternal view inner COMPOSITE
P_NameOnListRptblQtyInternal view_entity inner COMPOSITE
P_NewestActvtdCmplRqSubstLst view_entity from COMPOSITE
P_NmbrOfSubstAssmtInvtryList view inner CONSUMPTION
P_NmbrOfSubstAssmtRstrcnList view inner CONSUMPTION
P_US_AllRptblQtyCFR view from COMPOSITE
R_CmRqVsDngrsGdsSubstListTP view_entity from TRANSACTIONAL Substance List - TP
R_CmRqVsPrdMktySubstListTP view_entity from TRANSACTIONAL Substance List for PMA - TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY SubstanceList SubstanceList 3
KEY SubstanceListUUID SubstanceListUUID 2
_OfficialName _OfficialName 1
_SubstanceListTypeText _SubstanceListTypeText 1
_Text _Text 1
CmplRqVers CmplRqVers 1
CmplRqVersUUID CmplRqVersSubstListUUID,CmplRqVersUUID 2
SubstanceListType SubstanceListType 5

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.

-- Substance List View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSSUBSTANCELIST (
    SUBSTANCELIST,
    SUBSTANCELISTUUID,
    _OFFICIALNAME,
    _SUBSTANCELISTTYPETEXT,
    _TEXT,
    CMPLRQVERS,
    CMPLRQVERSUUID,
    SUBSTANCELISTTYPE,
    PRIMARY KEY (SUBSTANCELIST, SUBSTANCELISTUUID)
);

Learn More