I_CMPLRQVERSGRPASSGMT

CDS View

Compliance Req for E- and S- Tables

I_CMPLRQVERSGRPASSGMT is a CDS View in S/4HANA. Compliance Req for E- and S- Tables. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_CmplRqVersListGrpAssgmtUnion view from COMPOSITE Listed Substance Group Assignment
P_SubstanceSubstListUnion view_entity from CONSUMPTION Substance Lists of Substances
R_CmplRqVersSDSGrpAssgmtTP view_entity from TRANSACTIONAL Assignment of Listed Subst to Group - TP

Fields (4)

KeyField CDS FieldsUsed in Views
KEY SubstanceGrpAssgmtUUID SubstanceGrpAssgmtUUID,UUID 2
CmplRqVersUUID CmplRqVersUUID 2
ListedSubstance ListedSubstance 1
ListedSubstanceGroupUUID ListedSubstanceGroupUUID 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.

-- Compliance Req for E- and S- Tables
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMPLRQVERSGRPASSGMT (
    SUBSTANCEGRPASSGMTUUID,
    CMPLRQVERSUUID,
    LISTEDSUBSTANCE,
    LISTEDSUBSTANCEGROUPUUID,
    PRIMARY KEY (SUBSTANCEGRPASSGMTUUID)
);