C_RealTimeProdnCostCompGroup

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_RealTimeProdnCostCompGroup.
-- 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: CEBORDRTPRODCCG
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_Ledger : fins_ledger, P_CurrencyRole : fis_curtp, P_PlanningCategory : fcom_category, P_CostComponentStructure : ck_elesmhk

CREATE VIEW C_RealTimeProdnCostCompGroup AS
SELECT
  Ledger,
  CompanyCode,
  OrderID,
  ControllingArea,
  OrderDescription,
  ObjectInternalID,
  ProfitCenter,
  BusinessArea,
  ResponsibleCostCenter,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  IsMarkedForDeletion,
  ExternalOrder,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualDeliveryDate,
  ActualReleasedDate,
  TechnicalCompletionDate,
  MRPPlant,
  StorageLocation,
  ProductionVersion,
  SalesOrder,
  SalesOrderItem,
  ValuationType,
  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,
  Material,
  _Material.ProductGroup AS MaterialGroup,
  _Material.ProductHierarchy AS ProductHierarchy,
  Plant,
  ControllingObjectStatus,
  OrderKeyStatus,
  cast(_SystemStatusText[1: Language = $session.system_language].SystemStatusName as fco_status_name ) AS SystemStatusName,
  cast(_OrderGroupStatus[1: Language = $session.system_language].OrderStatusShortText as fco_status_name ) AS OrderStatusShortText,
  OrderCategory,
  OrderType,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  DisplayCurrency,
  MfgOrderHasMultipleItems,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _LedgerText[1: Language = $session.system_language].LedgerName AS LedgerName,
  _Plant.PlantName AS PlantName,
  cast(_MRPPlant.PlantName as fco_rtwip_planning_plant_name) AS MRPPlantName,
  _Material._ProductGroupText[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _Material._ProductHierarchyText[1: Language = $session.system_language].ProductHierarchyText AS ProductHierarchyText,
  cast(_ProductText[1: Language = $session.system_language].ProductName as fco_rtwip_prod_desc) AS MaterialName,
  _OrderTypeText[1: Language = $session.system_language].OrderTypeName AS OrderTypeName,
  _OrderCategoryText[1: Language = $session.system_language].OrderCategoryName AS OrderCategoryName,
  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,
  ActualOutputQuantity,
  BaseUnit,
  cast('%' as msehi) AS RatioUnit,
  cast (TotalAmountInDisplayCrcy as fis_dr_totactlcost_in_dspcrcy preserving type) AS TotalAmountInDisplayCrcy,
  CostCompGrp1AmountInDC,
  CostCompGrp2AmountInDC,
  CostCompGrp3AmountInDC,
  CostCompGrp4AmountInDC,
  CostCompGrp5AmountInDC,
  CostCompGrp6AmountInDC,
  CostCompGrp7AmountInDC,
  CostCompGrp8AmountInDC,
  CostCompGrp9AmountInDC,
  CostCompGrp10AmountInDC,
  CostCompGrp11AmountInDC,
  CostCompGrp12AmountInDC,
  CostCompGrp13AmountInDC,
  CostCompGrp14AmountInDC,
  CostCompGrp15AmountInDC,
  CostCompGrp16AmountInDC,
  CostCompGrp17AmountInDC,
  CostCompGrp18AmountInDC,
  CostCompGrp19AmountInDC,
  CostCompGrp20AmountInDC,
  CostCompGrp21AmountInDC,
  CostCompGrp22AmountInDC,
  CostCompGrp23AmountInDC,
  CostCompGrp24AmountInDC,
  CostCompGrp25AmountInDC,
  CostCompGrp26AmountInDC,
  CostCompGrp27AmountInDC,
  CostCompGrp28AmountInDC,
  CostCompGrp29AmountInDC,
  CostCompGrp30AmountInDC,
  CostCompGrp31AmountInDC,
  CostCompGrp32AmountInDC,
  CostCompGrp33AmountInDC,
  CostCompGrp34AmountInDC,
  CostCompGrp35AmountInDC,
  CostCompGrp36AmountInDC,
  CostCompGrp37AmountInDC,
  CostCompGrp38AmountInDC,
  CostCompGrp39AmountInDC,
  CostCompGrp40AmountInDC,
  :P_FromFiscalYearPeriod AS FromFiscalYearPeriod,
  :P_ToFiscalYearPeriod AS ToFiscalYearPeriod,
  cast(:P_PlanningCategory as fcom_category preserving type) AS PlanningCategory
FROM P_EBPC_COGM_CCGroup
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 I_Product AS _Material ON Material = _Material.Product  -- 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_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- 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_ProductionVersionBasic AS _ProductionVersion ON Material = _ProductionVersion.Product AND Plant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- 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_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _ResponsibleCostCenterText ON ControllingArea = _ResponsibleCostCenterText.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenterText.CostCenter AND _ResponsibleCostCenterText.ValidityStartDate <= $session.system_date AND _ResponsibleCostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;