I_RFM_MfgOrderDuration

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 I_RFM_MfgOrderDuration.
-- 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: IRFMMFGORDERDURN

CREATE VIEW I_RFM_MfgOrderDuration AS
SELECT
  _Duration.ManufacturingOrder AS ManufacturingOrder,
  _Duration.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  _Duration.ManufacturingOrderType AS ManufacturingOrderType,
  _Duration.ManufacturingOrderText AS ManufacturingOrderText,
  _Duration.MfgOrderInternalID AS OrderInternalBillOfOperations,
  _Duration.ReferenceOrder AS ReferenceOrder,
  _Duration.PlanningPlant AS MRPPlant,
  _Duration._PlanningPlant.PlantName AS MRPPlantName,
  _Duration.MRPArea AS MRPArea,
  _Duration._MRPArea.MRPAreaText AS MRPAreaText,
  _Duration.MRPController AS MRPController,
  _Duration._MRPController.MRPControllerName AS MRPControllerName,
  _Duration.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  _Duration.ControllingArea AS ControllingArea,
  _Duration.ProfitCenter AS ProfitCenter,
  _Duration.CostCenter AS CostCenter,
  _Duration.GLAccount AS GLAccount,
  _Duration.FunctionalArea AS FunctionalArea,
  _Duration.ProductionPlant AS ProductionPlant,
  _Duration._ProductionPlant.PlantName AS ProductionPlantName,
  _Duration.ProductionSupervisor AS ProductionSupervisor,
  _Duration.SalesOrder AS SalesDocument,
  _Duration.SalesOrderItem AS SalesDocumentItem,
  _WBSElementBasicData2.WBSDescription AS WBSDescription,
  _Duration.ProductionVersion AS ProductionVersion,
  _ProductionVersion2.ProductionVersionText AS ProductionVersionText,
  _ProductionVersion2.ProductionLine AS ProductionLine,
  _Duration.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  cast(_Duration.ProdnProcgIsFlexible as mpe_flexible_processing preserving type) AS ProdnProcgIsFlexible,
  _Duration.SuperiorOrder AS MfgOrderSuperiorMfgOrder,
  _Duration.BasicSchedulingType AS BasicSchedulingType,
  _Duration._BasicSchedulingType._Text[1: Language = $session.system_language].SchedulingTypeName AS SchedulingTypeName,
  $session.system_date AS CurrentDate,
  case when _isReleased.StatusCode is null then '' else 'X' end AS OrderIsReleased,
  case when _isConfirmed.StatusCode is null then '' else 'X' end AS OrderIsConfirmed,
  case when _isPartConf.StatusCode is null then '' else 'X' end AS OrderIsPartiallyConfirmed,
  _Duration.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  _Duration.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  _Duration.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  _Duration.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  _Duration.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  _Duration.CreationDate AS MfgOrderCreationDate,
  _Duration.LastChangeDate AS LastChangeDate,
  _Duration.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  _Duration.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  _Duration.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  _Duration.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  _Duration.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  _Duration.ProductionUnit AS ProductionUnit,
  _Duration.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  _Duration.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  cast(_Duration.MfgOrderPlannedTotalQty - _Duration.MfgOrderPlannedScrapQty as plannedyieldquantity) AS MfgOrderPlannedYieldQty,
  _Duration.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  _Duration.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  _Duration.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  _Duration.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  _Duration.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  cast (_Duration.MfgOrderPlannedTotalQty-_Duration.MfgOrderPlannedScrapQty-_Duration.ActualDeliveredQuantity-_Duration.ExpectedDeviationQuantity as openquan) AS OrderOpenQuantity,
  _Duration.Material AS Material,
  _Duration._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _Duration.EffectivityParameterVariant AS EffectivityParameterVariant,
  _Duration.Batch AS Batch,
  _OrderLongText.PlainLongText AS OrderLongText,
  _Duration._MfgOrderType._Text[1: Language=$session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  _Duration.StorageLocation AS StorageLocation,
  _Duration.StockSegment AS StockSegment,
  _Duration._RFM_MasterProductOrder.CombinedProductionOrder AS CombinedProductionOrder,
  _Duration.MasterProductionOrder AS MasterProductionOrder,
  _Duration.ProductSeasonYear AS ProductSeasonYear,
  _Duration.ProductSeason AS ProductSeason,
  _Duration.ProductCollection AS ProductCollection,
  _Duration.ProductTheme AS ProductTheme,
  _Duration._Material.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _Duration._Material.ProductCategory AS ProductCategory,
  _Duration._Material.MaterialType AS MaterialType,
  _Duration._Material.MaterialGroup AS MaterialGroup,
  _Duration._Material.ProductCharacteristic1 AS ProductCharacteristic1,
  _Duration._Material.ProductCharacteristic2 AS ProductCharacteristic2,
  _Duration._Material.ProductCharacteristic3 AS ProductCharacteristic3,
  ObjectInternalID,
  _Duration._ProductionPlant AS _Plant,
  _Duration._PlanningPlant AS _MRPPlant
FROM I_ManufacturingOrder AS _Duration
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _isReleased ON _isReleased.StatusObject = _Duration.ObjectInternalID AND _isReleased.StatusCode = 'I0002' AND _isReleased.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _isConfirmed ON _isConfirmed.StatusObject = _Duration.ObjectInternalID AND _isConfirmed.StatusCode = 'I0009' AND _isConfirmed.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _isPartConf ON _isPartConf.StatusObject = _Duration.ObjectInternalID AND _isPartConf.StatusCode = 'I0010' AND _isPartConf.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderLongText AS _OrderLongText ON ManufacturingOrder = _OrderLongText.OrderID  -- association [0..1]
;