I_WorkCenterProdCostCube

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_WorkCenterProdCostCube.
-- 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: IFIWCPRODCSTCUB
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_Language : sylangu, P_CurrencyRole : fac_crcyrole

CREATE VIEW I_WorkCenterProdCostCube AS
SELECT
  WorkCenterInternalID,
  OrderOperation,
  OrderID,
  GLAccount,
  Material,
  Plant,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  CompanyCode,
  WorkCenter,
  cast(COALESCE(_Material._Text[1: Language = $parameters.P_Language].MaterialName, '') as fis_material_text) AS MaterialName,
  _Plant.PlantName AS PlantName,
  ControllingArea,
  cast( _ControllingArea.ControllingAreaName as fis_bezei preserving type ) AS ControllingAreaName,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  BusinessArea,
  ProfitCenter,
  _GLAccount.ChartOfAccounts AS ChartOfAccounts,
  OrderDescription,
  OrderCategory,
  OrderType,
  ReferenceOrder,
  MfgOrderHasMultipleItems,
  '' AS ControllingObjectStatus,
  cast(MRPPlant as fis_co_pwerk) AS MRPPlant,
  UnitOfMeasure,
  DisplayCurrency,
  DebitPlanCostInDspCrcy,
  DebitPlnFxdCostInDspCrcy,
  DebitPlnVarblCostInDspCrcy,
  DebitActlCostInDspCrcy,
  DebitActlFxdCostInDspCrcy,
  DebitActlVarblCostInDspCrcy,
  DebitActlPlnDiffCostInDspCrcy,
  cast( '0' as fis_dr_cocrcy_actlplndiffpct ) AS DebitActlPlanDiffPercent,
  ActualQtyInCostSourceUnit,
  PlanQtyInCostSourceUnit,
  ActlPlanDiffQuantity,
  cast(COALESCE(_WorkCenter._Text[1: Language = $parameters.P_Language].WorkCenterText, '') as workcentertext) AS WorkCenterText,
  cast(COALESCE(_GLAccount._Text[1: Language = $parameters.P_Language].GLAccountName, '') as txt20_skat) AS GLAccountName,
  cast( _CostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_kostl_name ) AS CostCenterName,
  cast( _CostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterDescription as fis_kostl_ltext ) AS CostCenterDescription,
  cast( _ActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as ktext ) AS CostCtrActivityTypeName,
  cast( _ActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeDesc as ltext ) AS CostCtrActivityTypeDesc,
  _OrderType._Text[1: Language = $parameters.P_Language].OrderTypeName AS OrderTypeName
FROM I_WorkCenterProductCost
INNER JOIN I_Ledger AS _Ledger ON /* join condition not captured in parsed metadata */
;