I_PMRPREQUIREMENTBASIC

CDS View
14 Fields 7 CDS Views

Requirement used in pMRP

I_PMRPREQUIREMENTBASIC is a CDS View in S/4HANA. Requirement used in pMRP. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_PMRPReceiptItem view_entity from BASIC Receipt Item used in pMRP
I_PMRPRequirementKPI view_entity from COMPOSITE KPIs of a Requirement used in pMRP
I_PMRPSimlnTopLevelDemand view_entity inner BASIC Top Level Demand in pMRP
P_PMRPRequirement view_entity inner COMPOSITE Requirements including TLD used in pMRP
P_PMRPTopLvlProdSlackByNoSOS view_entity inner COMPOSITE Calculate Slack for Top Level Product by NoSOS
P_PMRPTopLvlProdSlackByRsce0 view_entity inner COMPOSITE Calculate Slack for Top Level Product by Resource
R_PMRPCostCtrPlanRequirement view_entity from COMPOSITE PMRP Cost Center Planning Requirement

Fields (14)

KeyField CDS FieldsUsed in Views
KEY Plant Plant,TopLevelPlant 5
KEY PMRPSimulation PMRPSimulation 2
KEY Product Product,TopLevelProduct 4
KEY TopLevelDemandInternalID PMRPNodeID,TopLevelDemandInternalID 2
AvailableStockQuantity AvailableStockQuantity 1
CoveredByStockQuantity CoveredByStockQuantity 2
MRPArea MRPArea,TopLevelMRPArea 4
PMRPOpenQuantity PMRPOpenQuantity 1
PMRPRequirementCategory PMRPReceiptCategory,PMRPRequirementCategory 1
RequiredQuantity RequiredQuantity,SimulatedRequiredQuantity 4
RequirementEndDate PMRPReceiptSupplyEndDate,ReceiptEndDate,RequirementEndDate 1
RequirementInternalID RequirementInternalID 1
RequirementStartDate ReceiptStartDate,RequirementStartDate 2
UnitOfMeasure UnitOfMeasure 5

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.

-- Requirement used in pMRP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PMRPREQUIREMENTBASIC (
    PLANT,
    PMRPSIMULATION,
    PRODUCT,
    TOPLEVELDEMANDINTERNALID,
    AVAILABLESTOCKQUANTITY,
    COVEREDBYSTOCKQUANTITY,
    MRPAREA,
    PMRPOPENQUANTITY,
    PMRPREQUIREMENTCATEGORY,
    REQUIREDQUANTITY,
    REQUIREMENTENDDATE,
    REQUIREMENTINTERNALID,
    REQUIREMENTSTARTDATE,
    UNITOFMEASURE,
    PRIMARY KEY (PLANT, PMRPSIMULATION, PRODUCT, TOPLEVELDEMANDINTERNALID)
);

Learn More