I_RealTimeWorkInProcess

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_RealTimeWorkInProcess.
-- 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: IRTWIPREPORTING
-- Parameters: P_KeyDate : fins_fperiod_enddate, P_Ledger : fins_ledger, P_CurrencyRole : fac_crcyrole

CREATE VIEW I_RealTimeWorkInProcess AS
SELECT
  OrderID,
  CompanyCode,
  ObjectInternalID,
  ControllingArea,
  OrderDescription,
  MfgOrderHasMultipleItems,
  CombnOrdCombinationIdentifier,
  RequestOrderType,
  CombinedOrder,
  SuperiorOrder,
  Material,
  _Material.ProductGroup AS MaterialGroup,
  _Material.ProductHierarchy AS ProductHierarchy,
  OrderCategory,
  cast(OrderType as fco_rtwip_prod_order_type preserving type ) AS OrderType,
  Plant,
  ProfitCenter,
  FunctionalArea,
  StorageLocation,
  MRPArea,
  MRPPlant,
  _RepresentativeOrderItem.SalesOrder AS SalesOrder,
  _RepresentativeOrderItem.SalesOrderItem AS SalesOrderItem,
  cast(_RepresentativeOrderItem.WBSElementInternalID as fco_ebpr_wbs_element_int_id preserving type ) AS WBSElementInternalID,
  cast(OrderPlannedTotalQty as fco_tot_plan_output_quantity) AS OrderPlannedTotalQty,
  UnitOfMeasure,
  cast(CompletedQuantityToDate as fco_rtwip_completed_quantity) AS CompletedQuantityToDate,
  cast(ActualOutputQuantity as fis_tot_actual_output_quantity) AS ActualOutputQuantity,
  PercentageOfCompletion,
  OrderCostsOutstandingInPercent,
  RatioUnit,
  cast(TotalWIPAmountInDspCrcy as fco_eb_totalwipamt_in_dspcrcy) AS TotalWIPAmountInDspCrcy,
  WIPCostInDspCrcy,
  PlanCostAmountInDspCrcy,
  ReservesUnrealizedCostsAmount,
  ProducedAmountInDspCrcy,
  CostToCompleteAmountInDspCrcy,
  DisplayCurrency,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate
FROM P_EBWIP_OrderCost4
LEFT OUTER JOIN I_OrderType AS _ProductionOrderType ON OrderType = _ProductionOrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [1..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductCostCtrlgOrderItem AS _RepresentativeOrderItem ON OrderID = _RepresentativeOrderItem.OrderID AND _RepresentativeOrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductHierarchyText AS _ProductHierarchyText ON producthierarchy = _ProductHierarchyText.ProductHierarchy  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MRPPlant ON MRPPlant = _MRPPlant.Plant  -- association [0..1]
;