/MERP/PP_PO_HEADER

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 /MERP/PP_PO_HEADER.
-- 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: /MERP/PP_POHEADR

CREATE VIEW /MERP/PP_PO_HEADER AS
SELECT
  aufk.aufnr AS OrderID,
  cast(aufk.autyp as pph_autyp preserving type) AS OrderCategory,
  aufk.auart AS OrderType,
  aufk.werks AS Plant,
  aufk.loekz AS IsMarkedForDeletion,
  cast(afko.plnbez as billofoperationsmaterial preserving type) AS Material,
  afko.gstri AS ActualStartDate,
  afko.gsuzi AS ActualStartTime,
  afko.gltri AS ActualEndDate,
  afko.gstrs AS ScheduledStartDate,
  afko.gsuzs AS ScheduledStartTime,
  afko.gltrs AS ScheduledEndDate,
  afko.gluzs AS ScheduledEndTime,
  aufk.objnr AS ObjectNum,
  afko.aufpl AS OrderInternalID,
  afko.fevor AS ProductionSupervisor,
  afko.maufnr AS SuperiorOdrer,
  afko.igmng AS ConfirmedQuantity,
  afko.dispo AS MRPController,
  afpo.verid AS ProductionVersion,
  aufk.kokrs AS ControllingArea,
  afko.getri AS ConfirmedEndDate,
  afko.geuzi AS ConfirmedEndTime,
  afko.gmein AS UnitOfMeasure,
  afpo.wemng AS GRQuantity,
  afko.gamng AS TotalQuantity,
  afko.gasmg AS PlannedScrapQuantity,
  afko.iasmg AS QualityIssueScrap,
  afpo.iamng AS ExpectedDeviationQuantity,
  cast(totalquantity-plannedscrapquantity-grquantity-expecteddeviationquantity as openquan) AS OpenQuantity,
  case totalquantity when 0 then 0 else DIVISION((qualityissuescrap * 100), totalquantity, 1) end as QualityIssueInPercent AS totalquantity1endasQualityIssueInPercent,
  MissingComponents.MissingComponentMaterial AS MissingComponentMaterial,
  MissingComponents.NumberOfComponentsMissing AS NumberOfComponentsMissing
FROM aufk
INNER JOIN /MERP/PP_PO_STATUS_AGGR AS status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /MERP/PP_PO_QUANTITY_ISSUE AS QuantityIssue ON OrderID = QuantityIssue.OrderID AND Plant = QuantityIssue.Plant AND ProductionSupervisor = QuantityIssue.ProductionSupervisor  -- association [1..1]
LEFT OUTER JOIN /MERP/PP_PO_MissingComponents AS MissingComponents ON OrderID = MissingComponents.ManufacturingOrder AND Plant = MissingComponents.ProductionPlant AND ProductionSupervisor = MissingComponents.ProductionSupervisor  -- association [0..1]
;