R_ActualCostSplittingResult

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 R_ActualCostSplittingResult.
-- 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.

CREATE VIEW R_ActualCostSplittingResult AS
SELECT
  _Item.Uuid AS ActualCostSplittingResultUUID,
  _Header.RunUuid AS ActlCostRateCalcRunUUID,
  _Header.Rbukrs AS CompanyCode,
  _CompanyCode.ControllingArea AS ControllingArea,
  _Header.Kostl AS CostCenter,
  cast( _Header.Gjahr as fis_gjahr_no_conv ) AS FiscalYear,
  _Header.Poper AS FiscalPeriod,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _Header.Kstar AS CostElement,
  _Header.Scnam AS SplittingStructure,
  _Header.Ksczuo AS SplittingAssignment,
  _Header.Screg AS SplittingRule,
  _Header.Scprz AS SplittingMethod,
  _Header.BadiPrzfx AS NumberOfFixedCostPercentage,
  _Header.Wkgbtr AS ActualCostAmtInGlobalCrcy,
  _Header.Kwaer AS GlobalCurrency,
  _Header.Whgbtr AS ActualCostAmtInCCCrcy,
  _Header.Hwaer AS CompanyCodeCurrency,
  _Header.Wagbtr AS ActualCostAmtInFreeDfndCrcy1,
  _Header.Awaer AS FreeDefinedCurrency1,
  _Item.Lstar AS CostCtrActivityType,
  _Item.Lilbtr AS CostCtrActivityTypeActualQty,
  _Item.Leinh AS CostCtrActivityTypeQtyUnit,
  _Item.Wkgbtr AS TotalAmountInGlobalCurrency,
  _Item.Wkfbtr AS FixedAmountInGlobalCrcy,
  cast( _Item.Wkgbtr - _Item.Wkfbtr as fco_ksii_wkv_splt ) AS VariableAmountInGlobalCrcy,
  _Item.Whgbtr AS TotalAmountInCoCodeCrcy,
  _Item.Whgbtr AS FixedAmountInCoCodeCrcy,
  cast( _Item.Whgbtr - _Item.Whfbtr as fco_ksii_whv_splt ) AS VariableAmountInCoCodeCrcy,
  _Item.Wagbtr AS TotAmtInFreelyDfndCtrlgCrcy1,
  _Item.Wafbtr AS FixedAmountInFDCrcy1,
  cast( _Item.Wagbtr - _Item.Wafbtr as fco_ksii_wav_splt ) AS VariableAmountInFDCrcy1,
  _SplittingMethodText.SplittingMethodText AS SplittingMethodText,
  case when _Header.Screg = '+++' then _EquallySplittingRuleText.SplittingRuleText else _SplittingRuleText.SplittingRuleText end as SplittingRuleText AS SplittingRuleTextendasSplittingRuleText,
  _SplittingAssignmentText.SplittingAssignmentText AS SplittingAssignmentText
FROM P_ActCostRateCalcSpltH AS _Header
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.ControllingArea = controllingarea AND _CostCenter.CostCenter = CostCenter AND _CostCenter.ValidityEndDate >= $session.system_date AND _CostCenter.ValidityStartDate <= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccount ON _GLAccount.ChartOfAccounts = chartofaccounts AND _GLAccount.GLAccount = CostElement  -- association [1..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _ActivityType ON _ActivityType.ControllingArea = controllingarea AND _ActivityType.CostCtrActivityType = CostCtrActivityType AND _ActivityType.ValidityEndDate >= $session.system_date AND _ActivityType.ValidityStartDate <= $session.system_date  -- association [1..1]
LEFT OUTER JOIN P_ActlCostSplittingMethodText AS _SplittingMethodText ON _SplittingMethodText.StructureType = 'C' AND _SplittingMethodText.SplittingMethod = SplittingMethod AND _SplittingMethodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_ActlCostSplittingRuleText AS _SplittingRuleText ON _SplittingRuleText.StructureType = 'C' AND _SplittingRuleText.SplittingRule = SplittingRule AND _SplittingRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_EquallySplittingRuleText AS _EquallySplittingRuleText ON _EquallySplittingRuleText.SplittingRule = SplittingRule AND _EquallySplittingRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_ActlCostSplittingAssgmtText AS _SplittingAssignmentText ON _SplittingAssignmentText.StructureType = 'C' AND _SplittingAssignmentText.SplittingStructure = SplittingStructure AND _SplittingAssignmentText.SplittingAssignment = SplittingAssignment AND _SplittingAssignmentText.Language = $session.system_language  -- association [0..1]
;