P_PMRPRECEIPTWITHISSUE

CDS View

Receipt with issue no SOS

P_PMRPRECEIPTWITHISSUE is a CDS View in S/4HANA. Receipt with issue no SOS. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_PMRPIssueByNoSOS1 view_entity from COMPOSITE pMRP No Source Of Supply Issue Impact
P_PMRPIssueByNoSOSBuckets view_entity from COMPOSITE pMRP No Source Of Supply Issue Impact
P_PMRPProdNoSOSMissingQty1 view_entity from COMPOSITE pMRP Top Level Product missing quantity due to no SOS
P_PMRPTopLvlProdSlackByNoSOS view_entity from COMPOSITE Calculate Slack for Top Level Product by NoSOS

Fields (5)

KeyField CDS FieldsUsed in Views
KEY MRPArea MRPArea 4
KEY Plant Plant 4
KEY PMRPSimulation PMRPSimulation 4
KEY Product Product 4
UnitOfMeasure UnitOfMeasure 2

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.

-- Receipt with issue no SOS
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PMRPRECEIPTWITHISSUE (
    MRPAREA,
    PLANT,
    PMRPSIMULATION,
    PRODUCT,
    UNITOFMEASURE,
    PRIMARY KEY (MRPAREA, PLANT, PMRPSIMULATION, PRODUCT)
);