I_OrdHdrItmRealTimeProdnCost

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

CREATE VIEW I_OrdHdrItmRealTimeProdnCost AS
SELECT
  OrderID,
  OrderItem,
  OrderInternalID,
  ObjectInternalID,
  OrderType,
  OrderCategory,
  ExternalOrder,
  OrderDescription,
  Plant,
  CompanyCode,
  BaseUnit,
  RatioUnit,
  Ledger,
  ControllingArea,
  BusinessArea,
  ProfitCenter,
  ResponsibleCostCenter,
  cast(WBSElementInternalID as fco_ebpr_wbs_element_int_id preserving type ) AS WBSElementInternalID,
  ProductionVersion,
  SalesOrder,
  SalesOrderItem,
  Material,
  _Material.ProductGroup AS MaterialGroup,
  _Material.ProductHierarchy AS ProductHierarchy,
  MRPPlant,
  StorageLocation,
  ProductionUnit,
  ValuationType,
  IsMarkedForDeletion,
  MfgOrderHasMultipleItems,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  PlannedReleaseDate,
  PlannedCompletionDate,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  TechnicalCompletionDate,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualDeliveryDate,
  ActualReleasedDate,
  ControllingObjectStatus,
  OrderKeyStatus,
  DisplayCurrency,
  ValidityDate,
  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_EBOrderHdrItmProdnCost2v2
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_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..*]
;