C_ActualCostSplittingResult

DDL: C_ACTUALCOSTSPLITTINGRESULT Type: view_entity CONSUMPTION Package: FINS_CO_UTIL_EXC
43 Fields 1 Data Sources 3 Associations 2 OData Services

Act Cost Rate Calc Spliting Result

C_ActualCostSplittingResult is a Consumption CDS View that provides data about "Act Cost Rate Calc Spliting Result" in SAP S/4HANA. It reads from 1 data source (R_ActualCostSplittingResult) and exposes 43 fields with key field ActualCostSplittingResultUUID. It has 3 associations to related views. It is exposed through 2 OData services (ASQL_F9080, UI_ACTUALCOSTRATECALCULATION). Part of development package FINS_CO_UTIL_EXC.

Data Sources (1)

SourceAliasJoin Type
R_ActualCostSplittingResult R_ActualCostSplittingResult from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_Currency _FreeDefinedCurrency1 $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Act Cost Rate Calc Spliting Result view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.applySupportedForAggregation #FULL view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F9080 ASQL_F9080 C2 NOT_RELEASED
UI_ACTUALCOSTRATECALCULATION UI_ACTUALCOSTRATECALCULATION V4 C1 NOT_RELEASED

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ActualCostSplittingResultUUID ActualCostSplittingResultUUID Waste Partner UUID
ActlCostRateCalcRunUUID ActlCostRateCalcRunUUID
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
CostCenterName
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Fiscal Period
CostElement CostElement G/L Account
GLAccountName
SplittingStructure SplittingStructure Structure Name
SplittingAssignment SplittingAssignment Splitting Assignment
SplittingAssignmentText SplittingAssignmentText
SplittingRule SplittingRule Splitting Rule
SplittingRuleText SplittingRuleText
SplittingMethod SplittingMethod Method
SplittingMethodText SplittingMethodText
NumberOfFixedCostPercentage NumberOfFixedCostPercentage
ActualCostAmtInGlobalCrcy ActualCostAmtInGlobalCrcy Total Costs in Global Currency
GlobalCurrency GlobalCurrency Global Currency
ActualCostAmtInCCCrcy ActualCostAmtInCCCrcy Total Costs in Company Code Currency
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
ActualCostAmtInFreeDfndCrcy1 ActualCostAmtInFreeDfndCrcy1 Total Costs in Freely Dfnd Crcy1
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
CostCtrActivityType CostCtrActivityType Activity Type
CostCtrActivityTypeName
CostCtrActivityTypeActualQty CostCtrActivityTypeActualQty Actual Activity
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit Unit
TotalAmountInGlobalCurrency TotalAmountInGlobalCurrency Distributed Costs on Acty in Global Crcy
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy Distributed Fixed Costs in Global Crcy
VariableAmountInGlobalCrcy VariableAmountInGlobalCrcy Distributed Varbl Costs in Global Crcy
TotalAmountInCoCodeCrcy TotalAmountInCoCodeCrcy Distributed Costs on Acty in CoCd Crcy
FixedAmountInCoCodeCrcy FixedAmountInCoCodeCrcy Distributed Fixed Costs in CoCd Crcy
VariableAmountInCoCodeCrcy VariableAmountInCoCodeCrcy Distributed Varbl Costs in CoCd Crcy
TotAmtInFreelyDfndCtrlgCrcy1 TotAmtInFreelyDfndCtrlgCrcy1 Distributed Costs on Acty in Free Crcy 1
FixedAmountInFDCrcy1 FixedAmountInFDCrcy1 Distributed Fixed Costs in Freely Crcy 1
VariableAmountInFDCrcy1 VariableAmountInFDCrcy1 Distributed Varbl Costs in Freely Crcy 1
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_GlobalCurrency _GlobalCurrency
_FreeDefinedCurrency1 _FreeDefinedCurrency1
_CostCenter _CostCenter

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_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 C_ActualCostSplittingResult AS
SELECT
  ActualCostSplittingResultUUID,
  ActlCostRateCalcRunUUID,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ControllingArea,
  CostCenter,
  _CostCenter._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  FiscalYear,
  FiscalPeriod,
  CostElement,
  _GLAccount._Text[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  SplittingStructure,
  SplittingAssignment,
  SplittingAssignmentText,
  SplittingRule,
  SplittingRuleText,
  SplittingMethod,
  SplittingMethodText,
  NumberOfFixedCostPercentage,
  ActualCostAmtInGlobalCrcy,
  GlobalCurrency,
  ActualCostAmtInCCCrcy,
  CompanyCodeCurrency,
  ActualCostAmtInFreeDfndCrcy1,
  FreeDefinedCurrency1,
  CostCtrActivityType,
  _ActivityType._Text[1: Language = $session.system_language].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  CostCtrActivityTypeActualQty,
  CostCtrActivityTypeQtyUnit,
  TotalAmountInGlobalCurrency,
  FixedAmountInGlobalCrcy,
  VariableAmountInGlobalCrcy,
  TotalAmountInCoCodeCrcy,
  FixedAmountInCoCodeCrcy,
  VariableAmountInCoCodeCrcy,
  TotAmtInFreelyDfndCtrlgCrcy1,
  FixedAmountInFDCrcy1,
  VariableAmountInFDCrcy1
FROM R_ActualCostSplittingResult
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
;

Learn More