P_PMRPRequirementHierarchy

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_PMRPRequirementHierarchy.
-- 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.
-- SQL view name: PPMRPRQMTHIER

CREATE VIEW P_PMRPRequirementHierarchy AS
SELECT
  rqmt.PMRPSimulation AS PMRPSimulation,
  PMRPNodeID,
  PMRPParentNodeID,
  ReceiptInternalID,
  ParentReceiptInternalID,
  RequirementInternalID,
  Product,
  Plant,
  MRPArea,
  PMRPReceiptCategory,
  ReceiptStartDate,
  ReceiptEndDate,
  PMRPSourceOfSupplyInternalID,
  RequirementStartDate,
  RequirementEndDate,
  PMRPReceiptSupplyEndDate,
  RequiredQuantity,
  AvailableStockQuantity,
  CoveredByStockQuantity,
  UnitOfMeasure,
  QuotaArrangementPercent,
  PMRPRequirementCategory,
  TopLevelDemandInternalID,
  PMRPBucketCategory,
  PMRPReferencePlan,
  OriglQuotaArrangementPercent,
  AlternativeItemPriority,
  _TopLevelDemand.BucketInternalID AS BucketInternalID,
  _Product._Text[Language = $session.system_language].ProductName AS ProductName,
  _Plant.PlantName AS PlantName,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _PMRPProduct.MRPController AS MRPController,
  _SourceOfSupply.PMRPSourceOfSupplyName AS PMRPSourceOfSupplyName,
  _PMRPProduct._PMRPController.MRPControllerName AS MRPControllerName,
  _PMRPProduct.MRPProcedure AS MRPProcedure,
  _SourceOfSupply.InHouseProductionTime AS InHouseProductionTime,
  _SourceOfSupply.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  _SourceOfSupply.GoodsReceiptDuration AS GoodsReceiptDuration,
  cast('' as abap.char( 20 )) AS PMRPTimeFrameText,
  cast(_PMRPReceiptKPI.NumberOfIssues as abap.char(20)) AS NumberOfIssues,
  cast(0 as pmrp_missing_quantity) AS PMRPMissingReceiptQuantity,
  cast(0 as pmrp_delta_quantity) AS PMRPDeltaQuantity,
  cast(0 as pmrp_number_of_sos) AS NumberOfSourcesOfSupply,
  cast(0 as pmrp_criticality_indicator) AS PMRPReceiptCriticality
FROM I_PMRPRequirement AS rqmt
LEFT OUTER JOIN P_PMRPRequirementHierarchy AS _ParentRequirement ON _ParentRequirement.PMRPSimulation = PMRPSimulation AND _ParentRequirement.PMRPNodeID = PMRPParentNodeID AND _ParentRequirement.TopLevelDemandInternalID = TopLevelDemandInternalID  -- association [0..1]
;