P_CMPLRQVERSETABLTHRESHOLDLIST

CDS View

Compliance Requirement Direct Access to ETable

P_CMPLRQVERSETABLTHRESHOLDLIST is a CDS View in S/4HANA. Compliance Requirement Direct Access to ETable. It contains 4 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_ListSubstGrpMemberFBAllLang view_entity inner COMPOSITE Substance group member
P_NameOnGrpMbrListRptblQty view_entity inner COMPOSITE Internal View for the CFR49 Name on List for Rptbl Qty
P_US_AllRptblQtyCFRGrpItemSAP view_entity from COMPOSITE Thresholds at List. Subs. SAP Content Only) with Grp Members
P_US_RptQtyListSubstGrpMember view_entity inner COMPOSITE CRV Group which contains Substance
R_CmRqVsDngrsGdsThldListItmTP view_entity from TRANSACTIONAL Threshold List - TP
R_CmRqVsPrdMktyThldListItmTP view_entity from TRANSACTIONAL Threshold List for PMA - TP

Fields (4)

KeyField CDS FieldsUsed in Views
KEY bco_id CmplRqVers 1
KEY parent_key SubstanceListUUID 1
KEY root_key CmplRqVersUUID 1
value SubstanceListItmThreshold 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 Requirement Direct Access to ETable
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CMPLRQVERSETABLTHRESHOLDLIST (
    BCO_ID,
    PARENT_KEY,
    ROOT_KEY,
    VALUE,
    PRIMARY KEY (BCO_ID, PARENT_KEY, ROOT_KEY)
);