P_US_ALLRPTBLQTYGRPITEMSUBSAP

CDS View

Thresholds List. Subs. (SAP Cont) with GrpMember+SubstUUID

P_US_ALLRPTBLQTYGRPITEMSUBSAP is a CDS View in S/4HANA. Thresholds List. Subs. (SAP Cont) with GrpMember+SubstUUID. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_US_AllRptblQtyCFR view inner COMPOSITE All Reportable Quantity for 49 CFR

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CmplRqVersUUID CmplRqVersUUID 1
KEY SubstanceUUID SubstanceUUID 1
ResponsibleUnit ResponsibleUnit 1
SubstanceListItmThreshold 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.

-- Thresholds List. Subs. (SAP Cont) with GrpMember+SubstUUID
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_US_ALLRPTBLQTYGRPITEMSUBSAP (
    CMPLRQVERSUUID,
    SUBSTANCEUUID,
    RESPONSIBLEUNIT,
    SUBSTANCELISTITMTHRESHOLD,
    PRIMARY KEY (CMPLRQVERSUUID, SUBSTANCEUUID)
);