C_StatKeyFigCostCenter

DDL: C_STATKEYFIGCOSTCENTER SQL: CWUSKFCC Type: view CONSUMPTION
18 Fields 1 Data Sources

Cost Centers

C_StatKeyFigCostCenter is a Consumption CDS View that provides data about "Cost Centers" in SAP S/4HANA. It reads from 1 data source (P_StatKeyFigCostCenter) and exposes 18 fields with key fields StatKeyFigWhereUsedObjType, ControllingArea, Ledger, ControllingObject, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
P_StatKeyFigCostCenter P_StatKeyFigCostCenter from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CWUSKFCC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Centers view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY StatKeyFigWhereUsedObjType
KEY ControllingArea ControllingArea Controlling Area
KEY Ledger Ledger Ledger
KEY ControllingObject ControllingObject Object number
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY ControllingValueType ControllingValueType
KEY ControllingVersion ControllingVersion
KEY StatisticalKeyFigure StatisticalKeyFigure Statistical Key Figure
KEY ControllingKeySubNumber ControllingKeySubNumber
KEY ControllingBusTransacType ControllingBusTransacType CO Bus. Transaction
KEY ValidityEndDate _CostCenter ValidityEndDate ValidTo
StatKeyFigVarForLogsInfoSystem StatKeyFigVarForLogsInfoSystem
StatisticalKeyFigureName
ControllingValueTypeName
ControllingVersionText
CostCenter _CostCenter CostCenter Cost Center
CostCenterName
ValidityStartDate _CostCenter ValidityStartDate Validity Start Date

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_StatKeyFigCostCenter.
-- 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: CWUSKFCC

CREATE VIEW C_StatKeyFigCostCenter AS
SELECT
  cast ('2CC' as statkeyfigwhereusedobjtypevh) AS StatKeyFigWhereUsedObjType,
  ControllingArea,
  Ledger,
  ControllingObject,
  FiscalYear,
  ControllingValueType,
  ControllingVersion,
  StatisticalKeyFigure,
  ControllingKeySubNumber,
  ControllingBusTransacType,
  _CostCenter.ValidityEndDate AS ValidityEndDate,
  StatKeyFigVarForLogsInfoSystem,
  _StatisticalKeyFigure._Text[1: Language = $session.system_language].StatisticalKeyFigureName AS StatisticalKeyFigureName,
  _ControllingValueType._Text[1: Language = $session.system_language].ControllingValueTypeName AS ControllingValueTypeName,
  _ControllingVersion._Text[1: Language = $session.system_language].ControllingVersionText AS ControllingVersionText,
  _CostCenter.CostCenter AS CostCenter,
  _CostCenter._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  _CostCenter.ValidityStartDate AS ValidityStartDate
FROM P_StatKeyFigCostCenter
;

Learn More