I_PMRPRECEIPTBASIC

CDS View
26 Fields 6 CDS Views

Receipt used in pMRP

I_PMRPRECEIPTBASIC is a CDS View in S/4HANA. Receipt used in pMRP. It contains 26 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_PMRPReceipt view_entity from COMPOSITE Receipt used in pMRP
I_PMRPRequirementKPI view left_outer COMPOSITE KPIs of a Requirement used in pMRP
P_PMRPReceiptSos view_entity from COMPOSITE Number of Sos per Receipt
P_PMRPReceiptWithIssue view from COMPOSITE Receipt with issue no SOS
P_PMRPRequirement view from COMPOSITE Requirements including TLD used in pMRP
P_PMRPTopLevelDemandSoSIssue1 view from COMPOSITE pMRP Sos Issue for TLD Prepare

Fields (26)

KeyField CDS FieldsUsed in Views
KEY PMRPSimulation PMRPSimulation 3
KEY ReceiptInternalID PMRPNodeID,ReceiptInternalID 3
_AlternativePMRPReceipt _AlternativePMRPReceipt 1
_MRPArea _MRPArea 1
_Plant _Plant 1
_Product _Product 1
_Simulation _Simulation 1
_TopLevelDemand _TopLevelDemand 1
_UnitOfMeasure _UnitOfMeasure 1
MRPArea MRPArea 3
PeggedRequirementInternalID PeggedRequirementInternalID 1
Plant Plant 3
PMRPCmbndBOMTopLvlDmndFactor PMRPCmbndBOMTopLvlDmndFactor 1
PMRPNmbrOfRqmtProductionDays PMRPNmbrOfRqmtProductionDays 1
PMRPReceiptCategory PMRPReceiptCategory 2
PMRPReceiptQuantity PMRPReceiptQuantity 2
PMRPReceiptSupplyEndDate PMRPReceiptSupplyEndDate 2
PMRPSourceOfSupplyInternalID PMRPSourceOfSupplyInternalID 2
Product Product 3
PullInQuantity PullInQuantity 2
QuotaArrangementPercent QuotaArrangementPercent 2
ReceiptEndDate ReceiptEndDate 3
ReceiptStartDate ReceiptStartDate 3
RequiredQuantity RequiredQuantity 2
TopLevelDemandInternalID TopLevelDemandInternalID 2
UnitOfMeasure UnitOfMeasure 3

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 used in pMRP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PMRPRECEIPTBASIC (
    PMRPSIMULATION,
    RECEIPTINTERNALID,
    _ALTERNATIVEPMRPRECEIPT,
    _MRPAREA,
    _PLANT,
    _PRODUCT,
    _SIMULATION,
    _TOPLEVELDEMAND,
    _UNITOFMEASURE,
    MRPAREA,
    PEGGEDREQUIREMENTINTERNALID,
    PLANT,
    PMRPCMBNDBOMTOPLVLDMNDFACTOR,
    PMRPNMBROFRQMTPRODUCTIONDAYS,
    PMRPRECEIPTCATEGORY,
    PMRPRECEIPTQUANTITY,
    PMRPRECEIPTSUPPLYENDDATE,
    PMRPSOURCEOFSUPPLYINTERNALID,
    PRODUCT,
    PULLINQUANTITY,
    QUOTAARRANGEMENTPERCENT,
    RECEIPTENDDATE,
    RECEIPTSTARTDATE,
    REQUIREDQUANTITY,
    TOPLEVELDEMANDINTERNALID,
    UNITOFMEASURE,
    PRIMARY KEY (PMRPSIMULATION, RECEIPTINTERNALID)
);

Learn More