C_MRPProductionOrderCard

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 C_MRPProductionOrderCard.
-- 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 C_MRPProductionOrderCard AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderItem,
  ManufacturingOrderCategory,
  MRPController,
  MRPControllerName,
  ProductionSupervisor,
  ProductionSupervisorName,
  ManufacturingOrderType,
  ManufacturingOrderTypeName,
  _StatusText.StatusName AS StatusName,
  MfgOrderPlannedStartDate,
  MfgOrderScheduledReleaseDate,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledEndDate,
  MfgOrderPlannedEndDate,
  MfgOrderActualStartDate,
  MaterialGoodsReceiptDuration,
  ProductionUnit,
  MfgOrderItemPlannedTotalQty,
  MfgOrderItemPlannedScrapQty,
  ExpectedDeviationQuantity,
  MfgOrderItemGoodsReceiptQty,
  cast(OpenQuantity as abap.quan(13, 3)) AS OpenQuantity,
  ProductionVersion,
  ProductionVersionText,
  ProductionLine,
  WorkCenterText,
  LeadingOrder,
  LeadingMfgOrderMaterial,
  LeadingMfgOrderMaterialName,
  WBSElement,
  WBSDescription,
  Project,
  ProjectDescription,
  ProjectResponsiblePerson,
  ProjectResponsiblePersonName,
  cast( concat( concat( ltrim( SDDocument, '0' ), '-' ), ltrim( SDDocumentItem, '0' ) ) as char17 ) AS MRPSalesOrderItemText,
  SoldToParty,
  CustomerName,
  SalesOrderItemMaterial,
  SalesOrderItemMaterialName,
  cast ( case when ProductionSupervisor is initial then 'X' else '' end as boolean preserving type ) AS UICT_ProductionSupervisor,
  cast ( case when MRPController is initial then 'X' else '' end as boolean preserving type ) AS UICT_MRPController,
  cast ( case when MfgOrderPlannedStartDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderPlannedStartDate,
  cast ( case when MfgOrderScheduledReleaseDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderSchedReleaseDate,
  cast ( case when MfgOrderScheduledStartDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderSchedStartDate,
  cast ( case when MfgOrderScheduledEndDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderScheduledEndDate,
  cast ( case when MfgOrderPlannedEndDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderPlannedEndDate,
  cast ( case when MfgOrderActualStartDate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderActualStartDate,
  cast ( case when MaterialGoodsReceiptDuration is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaterialGoodsReceiptDur,
  cast ( case when MfgOrderItemPlannedTotalQty is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderItmPlndTotalQty,
  cast ( case when MfgOrderPlannedScrapQty is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderPlannedScrapQty,
  cast ( case when ExpectedDeviationQuantity is initial then 'X' else '' end as boolean preserving type ) AS UICT_ExpectedDeviationQuantity,
  cast ( case when MfgOrderItemGoodsReceiptQty is initial then 'X' else '' end as boolean preserving type ) AS UICT_MfgOrderItmGoodsRcptQty,
  cast ( case when OpenQuantity is initial then 'X' else '' end as boolean preserving type ) AS UICT_OpenQuantity,
  cast ( case when ProductionVersion is initial then 'X' else '' end as boolean preserving type ) AS UICT_ProductionVersion,
  cast ( case when ProductionLine is initial then 'X' else '' end as boolean preserving type ) AS UICT_ProductionLine,
  cast ( case when LeadingOrder is initial then 'X' else '' end as boolean preserving type ) AS UICT_LeadingOrder,
  cast ( '' as boolean preserving type ) AS UICT_LeadingMfgOrderMaterial,
  cast ( '' as boolean preserving type ) AS UICT_WBSElement,
  cast ( '' as boolean preserving type ) AS UICT_ProjectResponsiblePerson,
  cast ( '' as boolean preserving type ) AS UICT_Project,
  cast ( case when SDDocument is initial then 'X' else '' end as boolean preserving type ) AS UICT_SalesOrder,
  cast ( '' as boolean preserving type ) AS UICT_SoldToParty,
  cast ( '' as boolean preserving type ) AS UICT_RelatedObjectsSection,
  ProductionPlant,
  Material,
  MaterialName,
  MfgOrderItemProductionUnit,
  SDDocument,
  Plant,
  MRPPlant
FROM P_MPEProdnOrderItemPover
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionLine AS _ProductionLine ON Plant = _ProductionLine.Plant AND ProductionLine = _ProductionLine.ProductionLine  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
;