P_US_ALLRPTBLQTYCFRGRPITEMSAP

CDS View
7 Fields 2 CDS Views

Thresholds at List. Subs. SAP Content Only) with Grp Members

P_US_ALLRPTBLQTYCFRGRPITEMSAP is a CDS View in S/4HANA. Thresholds at List. Subs. SAP Content Only) with Grp Members. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_NameOnGrpMbrListRptblQty view_entity inner COMPOSITE Internal View for the CFR49 Name on List for Rptbl Qty
P_US_AllRptblQtyGrpItemSubSAP view_entity from COMPOSITE Thresholds List. Subs. (SAP Cont) with GrpMember+SubstUUID

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CmplRqVers CmplRqVers 1
KEY CmplRqVersUUID CmplRqVersUUID 1
KEY SubstanceListUUID SubstanceListUUID 1
ListedSubstance ListedSubstance 1
SubstanceListItmThreshold SubstanceListItmThreshold 2
SubstanceListItmThresholdUoM SubstanceListItmThresholdUoM 1
SubstanceListType SubstanceListType 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.

-- Thresholds at List. Subs. SAP Content Only) with Grp Members
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_US_ALLRPTBLQTYCFRGRPITEMSAP (
    CMPLRQVERS,
    CMPLRQVERSUUID,
    SUBSTANCELISTUUID,
    LISTEDSUBSTANCE,
    SUBSTANCELISTITMTHRESHOLD,
    SUBSTANCELISTITMTHRESHOLDUOM,
    SUBSTANCELISTTYPE,
    PRIMARY KEY (CMPLRQVERS, CMPLRQVERSUUID, SUBSTANCELISTUUID)
);

Learn More