pp_mrp_read_mfg_order_comp

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 pp_mrp_read_mfg_order_comp.
-- 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: V_MRP_MFG_COMP

CREATE VIEW pp_mrp_read_mfg_order_comp AS
SELECT
  res.rsnum AS Reservation,
  res.rspos AS ReservationItem,
  res.rsart AS RecordType,
  res.bdart AS RequirementType,
  res.matnr AS Material,
  res.werks AS MRPPlant,
  res.umwrk AS SupplyingPlant,
  res.bdter AS RequirementDate,
  res.bdmng AS OrderedQuantity,
  res.enmng AS WithdrawnQuantity,
  res.bdmng - res.enmng AS OpenQuantity,
  res.vmeng AS CommittedQuantity,
  res.meins AS MaterialBaseUnit,
  res.lifnr AS Vendor,
  mat.ekgrp AS PurchasingGroup,
  mat.beskz AS MaterialProcurementCategory,
  mpt.sobes AS MaterialProcurementType,
  res.webaz AS MaterialGoodsReceiptDuration,
  mat.plifz AS MaterialPlannedDeliveryDurn,
  mat.dzeit AS MaterialPlannedProductionDurn,
  mat.wzeit AS MatTotalReplenishmentLeadDurn,
  mat.bstfe AS MaterialFixedLotSizeQuantity,
  mat.bstmi AS MaterialMinLotSizeQuantity,
  mat.bstma AS MaterialMaxLotSizeQuantity,
  mat.bstrf AS MaterialRoundingQuantity,
  mat.rdprf AS MaterialRoundingProfile,
  ord.aufnr AS ManufacturingOrder,
  ord.autyp AS ManufacturingOrderCategory,
  ord.auart AS ManufacturingOrderType,
  ord.aprio AS ManufacturingOrderImportance,
  pos.plnum AS PlannedOrder,
  ord.werks AS ProductionPlant,
  ord.dispo AS MRPController,
  ord.fevor AS ProductionSupervisor,
  pos.verid AS ProductionVersion,
  prv.text1 AS ProductionVersionText,
  prv.mdv01 AS ProductionLine,
  ord.prodnet AS IsPartOfCollectiveOrder,
  ord.maufnr AS SuperiorOrder,
  top.aufnr AS TopLevelOrder,
  tpp.matnr AS TopLevelOrderMaterial,
  case ord.autyp when '10' then '' when '30' then '' when '40' then ord.rsnid end as ResourceNetwork AS rsnidendasResourceNetwork,
  pos.sobkz AS InventorySpecialStock,
  pos.kdauf AS SalesOrder,
  pos.kdpos AS SalesOrderItem,
  vbk.auart AS SalesOrderType,
  vbp.matnr AS SalesOrderItemMaterial,
  vbk.kunnr AS Customer,
  pos.projn AS WBSElementInternalID,
  psp.posid AS WBSElement,
  psp.post1 AS WBSDescription,
  psp.vernr AS WBSResponsiblePerson,
  psp.verna AS WBSResponsiblePersonName,
  psp.psphi AS ProjectInternalID,
  pro.pspid AS Project,
  pro.post1 AS ProjectDescription,
  ord.gamng AS OrderPlannedTotalQty,
  ord.gasmg AS OrderPlannedScrapQty,
  pos.iamng AS OrderExpectedDeviationQty,
  pos.wemng AS GoodsReceiptQuantity,
  (ord.gamng - ord.gasmg - pos.iamng - pos.wemng) AS OrderOpenQuantity,
  ord.gstrp AS OrderPlannedStartDate,
  ord.gltrp AS OrderPlannedEndDate,
  ord.gstri AS OrderActualStartDate,
  ord.getri AS OrderActualEndDate,
  ord.ftrmi AS OrderActualReleaseDate,
  ord.gstrs AS OrderScheduledStartDate,
  ord.gltrs AS OrderScheduledEndDate,
  ord.ftrms AS OrderScheduledReleaseDate,
  aih.artpr AS MaintenanceOrderPriorityType,
  aih.priok AS MaintenanceOrderPriority,
  aih.iwerk AS MaintenancePlanningPlant,
  aih.ingpr AS MaintenancePlannerGroup,
  aih.revnr AS MaintenanceRevision,
  aih.warpl AS MaintenancePlan,
  aih.qmnum AS MaintenanceNotification,
  ord.vaplz AS MaintenanceWorkCenter,
  ord.wawrk AS MaintenanceWorkCenterPlant,
  aih.ilart AS ActivityType,
  prt.parnr AS ResponsiblePerson
FROM caufv AS ord
LEFT OUTER JOIN afpo AS pos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN afih AS aih ON /* join condition not captured in parsed metadata */
INNER JOIN resb AS res ON /* join condition not captured in parsed metadata */
INNER JOIN t460a AS mpt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mkal AS prv ON /* join condition not captured in parsed metadata */
INNER JOIN afpo AS tpp ON /* join condition not captured in parsed metadata */
INNER JOIN proj AS pro ON /* join condition not captured in parsed metadata */
INNER JOIN vbap AS vbp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ihpa AS prt ON /* join condition not captured in parsed metadata */
;