P_PMRPIssueByUnderDelivery

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_PMRPIssueByUnderDelivery.
-- 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_PMRPIssueByUnderDelivery AS
SELECT
  underdlvissue.PMRPSimulation AS PMRPSimulation,
  underdlvissue.TopLevelProduct AS Product,
  underdlvissue.TopLevelPlant AS Plant,
  underdlvissue.TopLevelMRPArea AS MRPArea,
  underdlvissue.UnitOfMeasure AS UnitOfMeasure,
  cast(count(distinct underdlvissue.BucketInternalID) as pmrp_affected_buckets) AS PMRPNumberOfAffectedBuckets,
  cast(count(distinct underdlvissue.TopLevelDemandInternalID) as pmrp_affected_topleveldemands) AS PMRPNmbrOfAffcdTopLvlDemands,
  cast(sum(underdlvissue.PMRPIssueImpactScore) as pmrp_issue_impact_score) AS PMRPIssueImpactScore,
  cast(max(produnderdlv.PMRPDeliveryPerformance) as pmrp_delvry_perf) AS TopLvlDmndUndrdelivRatioInPct,
  cast(sum(underdlvissue.ActualAvailableQuantity) as pmrp_delta_quantity) AS PMRPDeltaQuantity
FROM P_PMRPIssueByProductUnderdlv AS underdlvissue
INNER JOIN P_PMRPProductUnderdelivery AS produnderdlv ON /* join condition not captured in parsed metadata */
;