P_PMRPRequirement

DDL: P_PMRPREQUIREMENT Type: view_entity COMPOSITE Package: PMRP_ENGINE
49 Fields 2 Data Sources

Requirements including TLD used in pMRP

P_PMRPRequirement is a Composite CDS View that provides data about "Requirements including TLD used in pMRP" in SAP S/4HANA. It reads from 2 data sources (I_PMRPReceiptBasic, I_PMRPRequirementBasic) and exposes 49 fields with key fields PMRPSimulation, PMRPNodeID, PMRPNodeID. Part of development package PMRP_ENGINE.

Data Sources (2)

SourceAliasJoin Type
I_PMRPReceiptBasic receipt from
I_PMRPRequirementBasic rqmt inner

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Requirements including TLD used in pMRP view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation I_PMRPReceiptBasic PMRPSimulation Simulation ID
KEY PMRPNodeID I_PMRPReceiptBasic ReceiptInternalID Top-Level Demand ID
ReceiptInternalIDendasPMRPParentNodeID
ReceiptInternalID I_PMRPReceiptBasic ReceiptInternalID Receipt ID
RequirementInternalID pegged_rqmt RequirementInternalID Requirement ID
Product I_PMRPReceiptBasic Product Product Sold
Plant I_PMRPReceiptBasic Plant Valuation Area
MRPArea I_PMRPReceiptBasic MRPArea MRP Area
PMRPReceiptCategory I_PMRPReceiptBasic PMRPReceiptCategory Order Category
ReceiptStartDate I_PMRPReceiptBasic ReceiptStartDate Start Date
ReceiptEndDate I_PMRPReceiptBasic ReceiptEndDate Requirement End Date
PMRPReceiptSupplyEndDate I_PMRPReceiptBasic PMRPReceiptSupplyEndDate Requirement End Date
PMRPSourceOfSupplyInternalID I_PMRPReceiptBasic PMRPSourceOfSupplyInternalID Source of Supply ID
RequirementStartDate pegged_rqmt RequirementStartDate Start Date
RequirementEndDate pegged_rqmt RequirementEndDate Requirement End Date
RequiredQuantity pegged_rqmt RequiredQuantity Requirement qty
PMRPReceiptQuantity I_PMRPReceiptBasic PMRPReceiptQuantity Receipt Quantity
PullInQuantity I_PMRPReceiptBasic PullInQuantity Pull-In Quantity
AvailableStockQuantity pegged_rqmt AvailableStockQuantity Available Quantity
CoveredByStockQuantity pegged_rqmt CoveredByStockQuantity Quantity Covered
UnitOfMeasure I_PMRPReceiptBasic UnitOfMeasure Unit Protected Qty
QuotaArrangementPercent I_PMRPReceiptBasic QuotaArrangementPercent Quota Percent
PMRPRequirementCategory pegged_rqmt PMRPRequirementCategory Order Category
PMRPSimulation Simulation ID
KEY PMRPNodeID I_PMRPRequirementBasic TopLevelDemandInternalID Top-Level Demand ID
PMRPParentNodeID 0
ReceiptInternalID 0 Receipt ID
RequirementInternalID I_PMRPRequirementBasic RequirementInternalID Requirement ID
ParentReceiptInternalID 0
GrandParentRqmtInternalID 0
Product I_PMRPRequirementBasic Product Product Sold
Plant I_PMRPRequirementBasic Plant Valuation Area
MRPArea I_PMRPRequirementBasic MRPArea MRP Area
PMRPReceiptCategory I_PMRPRequirementBasic PMRPRequirementCategory Order Category
ReceiptStartDate I_PMRPRequirementBasic RequirementStartDate Start Date
ReceiptEndDate I_PMRPRequirementBasic RequirementEndDate Requirement End Date
PMRPReceiptSupplyEndDate I_PMRPRequirementBasic RequirementEndDate Requirement End Date
PMRPSourceOfSupplyInternalID Source of Supply ID
RequirementStartDate I_PMRPRequirementBasic RequirementStartDate Start Date
RequirementEndDate I_PMRPRequirementBasic RequirementEndDate Requirement End Date
RequiredQuantity I_PMRPRequirementBasic RequiredQuantity Requirement qty
PMRPReceiptQuantity 0 Receipt Quantity
PullInQuantity 0 Pull-In Quantity
AvailableStockQuantity I_PMRPRequirementBasic AvailableStockQuantity Available Quantity
CoveredByStockQuantity I_PMRPRequirementBasic CoveredByStockQuantity Quantity Covered
UnitOfMeasure I_PMRPRequirementBasic UnitOfMeasure Unit Protected Qty
QuotaArrangementPercent 0 Quota Percent
PMRPRequirementCategory I_PMRPRequirementBasic PMRPRequirementCategory Order Category
TopLevelDemandInternalID I_PMRPRequirementBasic TopLevelDemandInternalID Top-Level Demand ID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PMRPRequirement.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_PMRPRequirement AS
SELECT
  receipt.PMRPSimulation AS PMRPSimulation,
  receipt.ReceiptInternalID AS PMRPNodeID,
  receipt.ReceiptInternalID AS ReceiptInternalID,
  pegged_rqmt.RequirementInternalID AS RequirementInternalID,
  receipt.Product AS Product,
  receipt.Plant AS Plant,
  receipt.MRPArea AS MRPArea,
  receipt.PMRPReceiptCategory AS PMRPReceiptCategory,
  receipt.ReceiptStartDate AS ReceiptStartDate,
  receipt.ReceiptEndDate AS ReceiptEndDate,
  receipt.PMRPReceiptSupplyEndDate AS PMRPReceiptSupplyEndDate,
  receipt.PMRPSourceOfSupplyInternalID AS PMRPSourceOfSupplyInternalID,
  pegged_rqmt.RequirementStartDate AS RequirementStartDate,
  pegged_rqmt.RequirementEndDate AS RequirementEndDate,
  pegged_rqmt.RequiredQuantity AS RequiredQuantity,
  receipt.PMRPReceiptQuantity AS PMRPReceiptQuantity,
  receipt.PullInQuantity AS PullInQuantity,
  pegged_rqmt.AvailableStockQuantity AS AvailableStockQuantity,
  pegged_rqmt.CoveredByStockQuantity AS CoveredByStockQuantity,
  receipt.UnitOfMeasure AS UnitOfMeasure,
  receipt.QuotaArrangementPercent AS QuotaArrangementPercent,
  pegged_rqmt.PMRPRequirementCategory AS PMRPRequirementCategory,
  0 AS PMRPParentNodeID,
  0 AS ParentReceiptInternalID,
  0 AS GrandParentRqmtInternalID,
  rqmt.TopLevelDemandInternalID AS TopLevelDemandInternalID
FROM I_PMRPReceiptBasic AS receipt
INNER JOIN I_PMRPRequirementBasic AS rqmt ON /* join condition not captured in parsed metadata */
;

Learn More