C_ActualCostRateTimeline

DDL: C_ACTUALCOSTRATETIMELINE SQL: CFIACTCOSTRATETL Type: view CONSUMPTION
27 Fields 4 Data Sources

Actual Cost Rate Timeline

C_ActualCostRateTimeline is a Consumption CDS View that provides data about "Actual Cost Rate Timeline" in SAP S/4HANA. It reads from 4 data sources (I_FiscalYearPeriodForLedger, I_FiscalYearPeriodForCmpnyCode, I_ActualCostRate, I_ActualCostRate) and exposes 27 fields with key fields CompanyCode, CostCenter, ActivityType, FiscalYearPeriod, FiscalYear.

Data Sources (4)

SourceAliasJoin Type
I_FiscalYearPeriodForLedger _Ledger inner
I_FiscalYearPeriodForCmpnyCode _Ledger inner
I_ActualCostRate _Rate from
I_ActualCostRate _Rate union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFIACTCOSTRATETL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Actual Cost Rate Timeline view
VDM.viewType #CONSUMPTION view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_ActualCostRate CompanyCode Receiver Company Code
KEY CostCenter CostCenter Cost Center
KEY ActivityType ActivityType Activity Type
KEY FiscalYearPeriod
KEY FiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod Tax period
KEY CostRateScaleFactor CostRateScaleFactor
KEY Ledger I_ActualCostRate Ledger Ledger
ControllingArea ControllingArea Controlling Area
CostRateVarblAmount CostRateVarblAmount
CostRateTotalAmount CostRateTotalAmount
CostRateFixedAmount CostRateFixedAmount
Currency Currency Valuation Crcy
CompanyCode Receiver Company Code
KEY CostCenter CostCenter Cost Center
KEY ActivityType ActivityType Activity Type
KEY FiscalYearPeriod
KEY FiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod Tax period
KEY CostRateScaleFactor CostRateScaleFactor
KEY Ledger I_ActualCostRate Ledger Ledger
ControllingArea ControllingArea Controlling Area
CostRateVarblAmount CostRateVarblAmount
CostRateTotalAmount CostRateTotalAmount
CostRateFixedAmount CostRateFixedAmount
Currency Currency Valuation Crcy
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit

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_ActualCostRateTimeline.
-- 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: CFIACTCOSTRATETL

CREATE VIEW C_ActualCostRateTimeline AS
SELECT
  _Rate.CompanyCode AS CompanyCode,
  CostCenter,
  ActivityType,
  cast(_Ledger.FiscalYearPeriod as fins_fyearperiod) AS FiscalYearPeriod,
  _Ledger.FiscalYear AS FiscalYear,
  _Ledger.FiscalPeriod AS FiscalPeriod,
  CostRateScaleFactor,
  _Rate.Ledger AS Ledger,
  ControllingArea,
  CostRateVarblAmount,
  CostRateTotalAmount,
  CostRateFixedAmount,
  Currency,
  CostCtrActivityTypeQtyUnit
FROM I_ActualCostRate AS _Rate
INNER JOIN I_FiscalYearPeriodForLedger AS _Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalYearPeriodForCmpnyCode AS _Ledger ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_ActualCostRate
;

Learn More