I_OrderRealTimeProductionCost

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_OrderRealTimeProductionCost.
-- 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: IEBORDRTPRODCST
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_PlanningCategory : fcom_category, P_CurrencyRole : fis_curtp

CREATE VIEW I_OrderRealTimeProductionCost AS
SELECT
  OrderID,
  ObjectInternalID,
  OrderType,
  OrderCategory,
  ExternalOrder,
  OrderDescription,
  OrderSettlementTriggerType,
  Plant,
  CompanyCode,
  cast(_RepresentativeOrderItem.BaseUnit as fis_meinh) AS BaseUnit,
  RatioUnit,
  Ledger,
  ControllingArea,
  BusinessArea,
  ProfitCenter,
  ResponsibleCostCenter,
  _RepresentativeOrderItem.ProductionVersion AS ProductionVersion,
  IsMarkedForDeletion,
  MfgOrderHasMultipleItems,
  CombnOrdCombinationIdentifier,
  CombinedOrder,
  SuperiorOrder,
  MfgOrderIsPartOfCollvOrder,
  RequestOrderType,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  PlannedReleaseDate,
  PlannedCompletionDate,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  TechnicalCompletionDate,
  Material,
  _Material.ProductGroup AS MaterialGroup,
  _Material.ProductHierarchy AS ProductHierarchy,
  cast(_RepresentativeOrderItem.MRPPlant as fis_co_pwerk) AS MRPPlant,
  cast(_RepresentativeOrderItem.StorageLocation as fis_lgort_d) AS StorageLocation,
  _RepresentativeOrderItem.OrderItem AS OrderItem,
  _RepresentativeOrderItem.ValuationType AS ValuationType,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualDeliveryDate,
  ActualReleasedDate,
  ControllingObjectStatus,
  OrderKeyStatus,
  DisplayCurrency,
  ValidityDate,
  _RepresentativeOrderItem.SalesOrder AS SalesOrder,
  _RepresentativeOrderItem.SalesOrderItem AS SalesOrderItem,
  cast(_RepresentativeOrderItem.WBSElementInternalID as fco_ebpr_wbs_element_int_id preserving type ) AS WBSElementInternalID,
  CreditActlCostInDspCrcy,
  DebitActlCostInDspCrcy,
  ActlCostInDspCrcy,
  CrdtActlFxdCostInDspCrcy,
  DebitActlFxdCostInDspCrcy,
  ActlFixedCostInDspCrcy,
  DebitActlVarblCostInDspCrcy,
  CrdtActlVarblCostIndDspCrcy,
  ActlVarblCostInDspCrcy,
  CreditPlanCostInDspCrcy,
  DebitPlanCostInDspCrcy,
  CrdtPlnFxdCostInDspCrcy,
  DebitPlnFxdCostInDspCrcy,
  DebitPlnVarblCostInDspCrcy,
  CrdtPlnVarblCostInDspCrcy,
  PlanVarblCostInDspCrcy,
  PlanCostInDspCrcy,
  PlanFixedCostInDspCrcy,
  CrdtTargetCostInDspCrcy,
  DebitTargetCostInDspCrcy,
  TargetCostInDspCrcy,
  CrdtPlanCtrlCostInDspCrcy,
  DebitPlanCtrlCostInDspCrcy,
  PlanCtrlCostInDspCrcy,
  CrdtActlCtrlCostInDspCrcy,
  DebitActlCtrlCostInDspCrcy,
  ActlCtrlCostInDspCrcy,
  WIPCostInDspCrcy,
  UnrlzdCostRsrvAmtInDspCrcy,
  TotalWIPAmountInDspCrcy,
  cast(CostVarianceInDspCrcy as fco_eb_totalvarcamt_in_dspcrcy) AS CostVarianceInDspCrcy,
  cast(InptPrVarcAmtInDspCrcy as fis_inptprvarcamt_in_dspcrcy) AS InptPrVarcAmtInDspCrcy,
  cast(InptQtyVarcAmtInDspCrcy as fis_inptqtyvarcamt_in_dspcrcy) AS InptQtyVarcAmtInDspCrcy,
  cast(RsceUsgeVarcAmtInDspCrcy as fis_rsceusgevarcamt_in_dspcrcy) AS RsceUsgeVarcAmtInDspCrcy,
  cast(OutpPrVarcAmtInDspCrcy as fco_eb_outprvarcamt_in_dspcrcy) AS OutpPrVarcAmtInDspCrcy,
  cast(LotSizeVarcAmtInDspCrcy as fis_lotsizevarcamt_in_dspcrcy) AS LotSizeVarcAmtInDspCrcy,
  cast(RmngVarcAmtInDspCrcy as fco_eb_rmngvarcamt_in_dspcrcy) AS RmngVarcAmtInDspCrcy,
  DebitActlPlnDiffCostInDspCrcy,
  DebitActlPlanDiffPercent,
  DebitActlTgtDiffCostInDspCrcy,
  DebitActlTgtDiffPercent,
  PlanOutputQuantity,
  ActualOutputQuantity,
  ActlPlanDiffOutputQuantity,
  ActlPlanDiffOutpQtyPercent
FROM P_EBOrderProductionCost3v2
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MRPPlant ON MRPPlant = _MRPPlant.Plant  -- 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_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_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_OrderTypeText AS _OrderTypeText ON OrderType = _OrderTypeText.OrderType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCategoryText ON OrderCategory = _OrderCategoryText.OrderCategory  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_CostingVariantText AS _ActlCostsCostingVariantText ON ActualCostsCostingVariant = _ActlCostsCostingVariantText.CostingVariant  -- association [0..*]
LEFT OUTER JOIN I_CostingVariantText AS _PlndCostsCostingVariantText ON PlannedCostsCostingVariant = _PlndCostsCostingVariantText.CostingVariant  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON MaterialGroup = _ProductGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityDate >= _ProfitCenterText.ValidityStartDate AND ValidityDate <= _ProfitCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _ResponsibleCostCenterText ON ControllingArea = _ResponsibleCostCenterText.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenterText.CostCenter AND ValidityDate >= _ResponsibleCostCenterText.ValidityStartDate AND ValidityDate <= _ResponsibleCostCenterText.ValidityEndDate  -- association [0..*]
;