C_RFM_ManageCombinedMfgOrder

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_RFM_ManageCombinedMfgOrder.
-- 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_RFM_ManageCombinedMfgOrder AS
SELECT
  CombinedProductionOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  cast( '' as werks_name ) AS PlantName,
  cast( '00000000' as mfgorderscheduledstartdate ) AS MfgOrderScheduledStartDate,
  cast('00000000' as mfgorderscheduledenddate ) AS MfgOrderScheduledEndDate,
  cast('00000000' as mfgorderactualstartdate ) AS MfgOrderActualStartDate,
  cast('00000000' as mfgorderactualenddate ) AS MfgOrderActualEndDate,
  cast('00000000' as mfgorderconfirmedenddate) AS MfgOrderConfirmedEndDate,
  cast('00000000' as mfgorderplannedstartdate ) AS MfgOrderPlannedStartDate,
  cast('00000000' as mfgorderplannedenddate ) AS MfgOrderPlannedEndDate,
  cast('00000000' as mfgorderplannedreleasedate ) AS MfgOrderPlannedReleaseDate,
  cast('00000000' as mfgorderscheduledreleasedate ) AS MfgOrderScheduledReleaseDate,
  cast('00000000' as mfgorderactualreleasedate ) AS MfgOrderActualReleaseDate,
  cast('' as productionunit ) AS ProductionUnit,
  cast(0 as mfgorderplannedtotalqty ) AS MfgOrderPlannedTotalQty,
  cast(0 as mfgorderplannedscrapqty ) AS MfgOrderPlannedScrapQty,
  cast(0 as plannedyieldquantity ) AS MfgOrderPlannedYieldQty,
  cast(0 as co_igmng ) AS MfgOrderConfirmedYieldQty,
  cast(0 as co_iasmg ) AS MfgOrderConfirmedScrapQty,
  cast(0 as rmnga ) AS MfgOrderConfirmedReworkQty,
  cast(0 as co_wemng ) AS ActualDeliveredQuantity,
  cast(0 as openquan ) AS OrderOpenQuantity,
  cast('' as abap.char( 1 ) ) AS OrderIsCreated,
  cast('' as abap.char( 1 ) ) AS OrderIsReleased,
  cast('' as abap.char( 1 ) ) AS OrderIsPartiallyReleased,
  cast('' as abap.char( 1 ) ) AS OrderIsConfirmed,
  cast('' as abap.char( 1 ) ) AS OrderIsPartiallyConfirmed,
  cast('' as abap.char( 1 ) ) AS OrderIsDelivered,
  cast('' as abap.char( 1 ) ) AS OrderIsDeleted,
  cast('' as abap.char( 1 ) ) AS OrderIsTechnicallyCompleted,
  cast('' as abap.char( 1 ) ) AS OrderIsClosed,
  cast('' as abap.char( 1 ) ) AS OrderIsPartiallyDelivered,
  cast('' as abap.char( 1 ) ) AS MfgOrderIsToBeDeleted,
  cast( 0 as abap.int2 ) AS CreatedStatusQtyInPercent,
  cast( 0 as abap.int2 ) AS ReleasedStatusQtyInPercent,
  cast( 0 as abap.int2 ) AS ConfirmedStatusQtyInPercent,
  cast( 0 as abap.int2 ) AS DeliveredStatusQtyInPercent,
  cast( 0 as abap.int2 ) AS DeletedStatusQtyInPercent,
  cast( 0 as abap.int2 ) AS TechlyCmpltdStatusQtyInPercent,
  cast( 0 as abap.int2 ) AS ClosedStatusQtyInPercent,
  cast( '' as abap.char( 1 ) ) AS OrderHasQualityIssue,
  cast( '' as abap.char( 1 ) ) AS OrderHasMissingComponents,
  cast( '' as abap.char( 1 ) ) AS OrderHasProductionHold,
  cast( '' as abap.char( 1 ) ) AS OrderHasExecutionDelay,
  cast( '' as abap.char( 1 ) ) AS OrderHasDeviation,
  cast( '' as matnr ) AS Material,
  cast( '' as satnr ) AS CrossPlantConfigurableProduct,
  cast('' as fsh_mprod_ord) AS MasterProductionOrder,
  cast('' as aufnr) AS ManufacturingOrder,
  cast('' as co_pwerk ) AS MRPPlant,
  cast('' as matkl ) AS MaterialGroup,
  cast('' as rfm_pp_order_status) AS OrderStatusInternalID,
  cast(0 as rfm_pp_morder_count ) AS NumberOfMasterProductionOrders,
  cast(0 as rfm_pp_order_count ) AS NumberOfProductionOrders
FROM R_RFM_ManageCombinedMfgOrderTP
LEFT OUTER JOIN C_RFM_ManageMfgOrder AS _Order ON CombinedProductionOrder = _Order.CombinedProductionOrder  -- association [0..*]
LEFT OUTER JOIN C_RFM_ManageMasterMfgOrder AS _Master ON CombinedProductionOrder = _Master.CombinedProductionOrder  -- association [0..*]
LEFT OUTER JOIN C_RFM_CmbndMfgOrdOpComponents AS _Comp ON CombinedProductionOrder = _Comp.CombinedProductionOrder  -- association [0..*]
;