P_CMPLRQVERSLISTGRPASSGMTUNION

CDS View
7 Fields 5 CDS Views

Listed Substance Group Assignment

P_CMPLRQVERSLISTGRPASSGMTUNION is a CDS View in S/4HANA. Listed Substance Group Assignment. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CmplRqVersSubstListGrpAssgmt view from COMPOSITE Listed Substance Group Assignment
P_ListSubstGrpMemberFBAllLang view_entity from COMPOSITE Substance group member
P_NameOnGrpMbrListRptblQty view_entity from COMPOSITE Internal View for the CFR49 Name on List for Rptbl Qty
P_SubstanceGrpAssgmt view_entity from CONSUMPTION Substance Group Assignment
P_US_RptQtyListSubstGrpMember view_entity from COMPOSITE CRV Group which contains Substance

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersUUID CmplRqVersUUID 4
KEY ListedSubstance ListedSubstance,ListedSubstanceID 4
KEY ListedSubstanceGroup ListedSubstanceGroup,ListedSubstanceGroupID 4
KEY ListedSubstanceGroupUUID ListedSubstanceGroupUUID 4
KEY SubstanceGrpAssgmtUUID SubstanceGrpAssgmtUUID 3
SubstanceGroupAssignment SubstanceGroupAssignment 1
SubstanceListUUID SubstanceListUUID 4

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 Group Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CMPLRQVERSLISTGRPASSGMTUNION (
    CMPLRQVERSUUID,
    LISTEDSUBSTANCE,
    LISTEDSUBSTANCEGROUP,
    LISTEDSUBSTANCEGROUPUUID,
    SUBSTANCEGRPASSGMTUUID,
    SUBSTANCEGROUPASSIGNMENT,
    SUBSTANCELISTUUID,
    PRIMARY KEY (CMPLRQVERSUUID, LISTEDSUBSTANCE, LISTEDSUBSTANCEGROUP, LISTEDSUBSTANCEGROUPUUID, SUBSTANCEGRPASSGMTUUID)
);

Learn More