P_PMRPIssueByCause

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_PMRPIssueByCause.
-- 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_PMRPIssueByCause AS
SELECT
  PMRPSimulation,
  PMRPResourceInternalID,
  cast(' ' as matnr preserving type) AS Product,
  cast( Plant as werks_d preserving type ) AS Plant,
  cast(' ' as berid preserving type) AS MRPArea,
  cast('0000000000' as pmrp_flexcon_id preserving type) AS PMRPFlexibleConstraint,
  ' ' AS PMRPSupplyGroup,
  ' ' AS PMRPSupplyGroupCategory,
  cast('1' as pmrp_issue_category) AS PMRPIssueCategory,
  PMRPNmbrOfAffcdTopLvlDemands,
  PMRPIssueImpactScore,
  cast(0 as pmrp_delvry_perf) AS TopLvlDmndUndrdelivRatioInPct,
  cast(0 as pmrp_nosos_missing_quantity) AS PMRPNoSOSMissingQuantity,
  cast(0 as pmrp_missing_quantity) AS PMRPConstraintMissingQuantity,
  cast(0 as pmrp_constraint_overload) AS PMRPConstraintMaxOverloadPct,
  PMRPNumberOfAffectedBuckets,
  cast(0 as pmrp_resource_overload) AS PMRPResourceMaxOverloadPercent,
  UnitOfMeasure
FROM P_PMRPIssueByResource
;