C_ServiceCostRateTimeline

DDL: C_SERVICECOSTRATETIMELINE SQL: CFISRCOSTTIM Type: view CONSUMPTION
33 Fields 4 Data Sources

Service Cost Rate Timeline Chart

C_ServiceCostRateTimeline is a Consumption CDS View that provides data about "Service Cost Rate Timeline Chart" in SAP S/4HANA. It reads from 4 data sources (I_FiscalYearPeriodForLedger, I_FiscalYearPeriodForCmpnyCode, I_ServiceCostRate_2, I_ServiceCostRate_2) and exposes 33 fields with key fields CompanyCode, CostCenter, TimeSheetOvertimeCategory, ActivityType, FiscalYearPeriod.

Data Sources (4)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFISRCOSTTIM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Service Cost Rate Timeline Chart 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 (33)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_ServiceCostRate_2 CompanyCode Receiver Company Code
KEY CostCenter CostCenter Cost Center
KEY TimeSheetOvertimeCategory TimeSheetOvertimeCategory
KEY ActivityType ActivityType Activity Type
KEY FiscalYearPeriod
KEY FiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod Tax period
KEY IsIntercompanyRate IsIntercompanyRate
KEY ReceivingCompanyCode ReceivingCompanyCode Rcvg Co Code
KEY WorkItem WorkItem Work Item ID
KEY WBSElementExternalID WBSElementExternalID WBS Element External ID
KEY CostRateScaleFactor CostRateScaleFactor
KEY Ledger I_ServiceCostRate_2 Ledger Ledger
ControllingArea ControllingArea Controlling Area
CostRateVarblAmount
Currency Currency Valuation Crcy
CompanyCode Receiver Company Code
KEY CostCenter CostCenter Cost Center
KEY TimeSheetOvertimeCategory TimeSheetOvertimeCategory
KEY ActivityType ActivityType Activity Type
KEY FiscalYearPeriod
KEY FiscalYear I_FiscalYearPeriodForCmpnyCode FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscalYearPeriodForCmpnyCode FiscalPeriod Tax period
KEY IsIntercompanyRate IsIntercompanyRate
KEY ReceivingCompanyCode ReceivingCompanyCode Rcvg Co Code
KEY WorkItem WorkItem Work Item ID
KEY WBSElementExternalID WBSElementExternalID WBS Element External ID
KEY CostRateScaleFactor CostRateScaleFactor
KEY Ledger I_ServiceCostRate_2 Ledger Ledger
ControllingArea ControllingArea Controlling Area
CostRateVarblAmount
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_ServiceCostRateTimeline.
-- 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: CFISRCOSTTIM

CREATE VIEW C_ServiceCostRateTimeline AS
SELECT
  _Rate.CompanyCode AS CompanyCode,
  CostCenter,
  TimeSheetOvertimeCategory,
  ActivityType,
  cast(_Ledger.FiscalYearPeriod as fins_fyearperiod) AS FiscalYearPeriod,
  _Ledger.FiscalYear AS FiscalYear,
  _Ledger.FiscalPeriod AS FiscalPeriod,
  IsIntercompanyRate,
  ReceivingCompanyCode,
  WorkItem,
  WBSElementExternalID,
  CostRateScaleFactor,
  _Rate.Ledger AS Ledger,
  ControllingArea,
  cast( CostRateVarblAmount as fco_cost_rate preserving type ) AS CostRateVarblAmount,
  Currency,
  CostCtrActivityTypeQtyUnit
FROM I_ServiceCostRate_2 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_ServiceCostRate_2
;

Learn More