C_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 C_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: CEBORDRTPRODCST
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_Ledger : fins_ledger, P_PlanningCategory : fcom_category, P_CurrencyRole : fac_crcyrole

CREATE VIEW C_OrderRealTimeProductionCost AS
SELECT
  cast(OrderID as fco_rtwip_production_order) AS OrderID,
  ObjectInternalID,
  OrderType,
  OrderCategory,
  OrderSettlementTriggerType,
  _TrggTypeText.DomainValue AS DomainValue,
  IsMarkedForDeletion,
  ExternalOrder,
  OrderDescription,
  Plant,
  CompanyCode,
  BaseUnit,
  cast(RatioUnit as fco_rt_prod_costs_prcntg_unit preserving type ) AS RatioUnit,
  :P_FromFiscalYearPeriod AS FromFiscalYearPeriod,
  :P_ToFiscalYearPeriod AS ToFiscalYearPeriod,
  cast(:P_PlanningCategory as fcom_category preserving type ) AS PlanningCategory,
  cast(Ledger as fins_ledger) AS Ledger,
  ControllingArea,
  BusinessArea,
  ProfitCenter,
  ResponsibleCostCenter,
  MfgOrderHasMultipleItems,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  TechnicalCompletionDate,
  cast(Material as fco_rtwip_product preserving type ) AS Material,
  _ProductGroupText[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  MaterialGroup,
  ProductHierarchy,
  cast(_ProductHierarchyText[1: Language = $session.system_language].ProductHierarchyText as producthierarchytext) AS ProductHierarchyText,
  MRPPlant,
  StorageLocation,
  ProductionVersion,
  ValuationType,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualDeliveryDate,
  ActualReleasedDate,
  ControllingObjectStatus,
  cast(_OrderGroupStatus[1: Language = $session.system_language].OrderStatusShortText as fco_status_name ) AS OrderStatusShortText,
  OrderKeyStatus,
  cast(_SystemStatusText[1: Language = $session.system_language].SystemStatusName as fco_status_name ) AS SystemStatusName,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  cast(_WBSElement.WBSElementExternalID as fco_ebpr_wbs_element_ext_id) AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  cast(_WBSElement._Project.ProjectExternalID as cats_cpr_extid) AS ProjectExternalID,
  _WBSElement._Project.ProjectDescription AS ProjectDescription,
  DisplayCurrency,
  CreditActlCostInDspCrcy,
  DebitActlCostInDspCrcy,
  ActlCostInDspCrcy,
  DebitActlVarblCostInDspCrcy,
  CrdtActlVarblCostIndDspCrcy,
  ActlVarblCostInDspCrcy,
  CrdtActlFxdCostInDspCrcy,
  DebitActlFxdCostInDspCrcy,
  ActlFixedCostInDspCrcy,
  CreditPlanCostInDspCrcy,
  DebitPlanCostInDspCrcy,
  CrdtPlnFxdCostInDspCrcy,
  DebitPlnFxdCostInDspCrcy,
  CrdtPlnVarblCostInDspCrcy,
  DebitPlnVarblCostInDspCrcy,
  PlanCostInDspCrcy,
  PlanFixedCostInDspCrcy,
  PlanVarblCostInDspCrcy,
  CrdtTargetCostInDspCrcy,
  DebitTargetCostInDspCrcy,
  TargetCostInDspCrcy,
  CrdtPlanCtrlCostInDspCrcy,
  DebitPlanCtrlCostInDspCrcy,
  PlanCtrlCostInDspCrcy,
  CrdtActlCtrlCostInDspCrcy,
  DebitActlCtrlCostInDspCrcy,
  ActlCtrlCostInDspCrcy,
  CostVarianceInDspCrcy,
  InptPrVarcAmtInDspCrcy,
  InptQtyVarcAmtInDspCrcy,
  RsceUsgeVarcAmtInDspCrcy,
  ScrapVarcAmtInDspCrcy,
  MixedPrVarcAmtInDspCrcy,
  OutpPrVarcAmtInDspCrcy,
  LotSizeVarcAmtInDspCrcy,
  RmngVarcAmtInDspCrcy,
  WIPCostInDspCrcy,
  UnrlzdCostRsrvAmtInDspCrcy,
  TotalWIPAmountInDspCrcy,
  PlanOutputQuantity,
  ActualOutputQuantity,
  DebitActlPlnDiffCostInDspCrcy,
  DebitActlPlanDiffPercent,
  DebitActlTgtDiffCostInDspCrcy,
  DebitActlTgtDiffPercent,
  DspCrcyActlTgtDiffPct,
  PlnCtrlTgtDiffCostInDspCrcy,
  DspCrcyPlnCtrlTgtDiffPct,
  ActlCtrlTgtDiffCostInDspCrcy,
  DspCrcyActlCtrlTgtDiffPct,
  ActlPlanDiffOutputQuantity,
  ActlPlanDiffOutpQtyPercent,
  _LedgerText[1: Language = $session.system_language].LedgerName AS LedgerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _OrderTypeText[1: Language = $session.system_language].OrderTypeName AS OrderTypeName,
  _OrderCategoryText[1: Language = $session.system_language].OrderCategoryName AS OrderCategoryName,
  _Plant.PlantName AS PlantName,
  cast(_MRPPlant.PlantName as fco_rtwip_planning_plant_name) AS MRPPlantName,
  cast(_ProductText[1: Language = $session.system_language].ProductName as fco_rtwip_prod_desc) AS MaterialName,
  cast(_StorageLocation.StorageLocationName as fco_rtwip_storage_loc_name preserving type ) AS StorageLocationName,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _ProfitCenterText[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  cast(_ResponsibleCostCenterText[1: Language = $session.system_language ].CostCenterName as fco_resp_cost_center_text) AS ResponsibleCostCenterName,
  cast(_ActlCostsCostingVariantText[1: Language = $session.system_language].CostingVariantName as fco_actl_costs_cost_var_name) AS ActlCostsCostingVariantName,
  cast(_PlndCostsCostingVariantText[1: Language = $session.system_language].CostingVariantName as fco_plnd_costs_cost_var_name) AS PlndCostsCostingVariantName,
  cast(_BusinessAreaText[1: Language = $session.system_language ].BusinessAreaName as fco_bus_area_text) AS BusinessAreaName
FROM I_OrderRealTimeProductionCost
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusText ON OrderKeyStatus = _SystemStatusText.SystemStatus  -- association [0..*]
LEFT OUTER JOIN C_RealTimeOrderGroupStatusVH AS _OrderGroupStatus ON ControllingObjectStatus = _OrderGroupStatus.ControllingObjectStatus  -- association [0..*]
LEFT OUTER JOIN C_RealTmeOrdJointProductionT AS _JointProductionText ON MfgOrderHasMultipleItems = _JointProductionText.MfgOrderHasMultipleItems  -- association [0..*]
LEFT OUTER JOIN I_ProductionVersionBasic AS _ProductionVersion ON Material = _ProductionVersion.Product AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_MfgOrdSettlmtTrggrType AS _TrggTypeText ON OrderSettlementTriggerType = _TrggTypeText.OrderSettlementTriggerType  -- association [0..1]
;