C_StatisticalKeyFigure

DDL: C_STATISTICALKEYFIGURE SQL: CFISTATKEYFIGTP Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Statistical Key Figure Master Record

C_StatisticalKeyFigure is a Consumption CDS View that provides data about "Statistical Key Figure Master Record" in SAP S/4HANA. It reads from 1 data source (I_StatisticalKeyFigureTP) and exposes 18 fields with key fields StatisticalKeyFigure, ControllingArea. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_StatisticalKeyFigureTP I_StatisticalKeyFigureTP from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_StatisticalKeyFigureText _StatisticalKeyFigureText $projection.StatisticalKeyFigure = _StatisticalKeyFigureText.StatisticalKeyFigure and $projection.ControllingArea = _StatisticalKeyFigureText.ControllingArea

Annotations (25)

NameValueLevelField
AbapCatalog.sqlViewName CFISTATKEYFIGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
Consumption.semanticObject StaisticalKeyFigure view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
UI.headerInfo.typeName Statistical Key Figure view
UI.headerInfo.typeNamePlural Statistical Key Figures view
UI.headerInfo.title.label Statistical Key Figure view
UI.headerInfo.title.value StatisticalKeyFigureForEdit view
UI.headerInfo.description.value StatisticalKeyFigureName view
UI.textArrangement #TEXT_LAST view
EndUserText.label Statistical Key Figure Master Record view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY StatisticalKeyFigure StatisticalKeyFigure Statistical Key Figure
KEY ControllingArea ControllingArea Controlling Area
StatisticalKeyFigureForEdit StatisticalKeyFigureForEdit Statistical Key Figure
ControllingAreaForEdit ControllingAreaForEdit Controlling Area
StatisticalKeyFigureName StatisticalKeyFigureName Statistical Key Figure Name
StstcKeyFigQuantityUnit StstcKeyFigQuantityUnit Quantity Unit
StstcKeyFigCategory StstcKeyFigCategory Category
LogsInformationSystemTable LogsInformationSystemTable
LogsInfoSystemKeyFigure LogsInfoSystemKeyFigure
UnitOfMeasureLongName UnitOfMeasureLongName
StstcKeyFigCategoryDesc StstcKeyFigCategoryDesc
ControllingAreaName ControllingAreaName Long Text
UnitOfMeasure_E _UnitOfMeasure UnitOfMeasure_E
_ControllingArea _ControllingArea
_StatisticalKeyFigureCat _StatisticalKeyFigureCat
_StatisticalKeyFigureText _StatisticalKeyFigureText
_Text _Text
_UnitOfMeasure _UnitOfMeasure

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_StatisticalKeyFigure.
-- 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: CFISTATKEYFIGTP

CREATE VIEW C_StatisticalKeyFigure AS
SELECT
  StatisticalKeyFigure,
  ControllingArea,
  StatisticalKeyFigureForEdit,
  ControllingAreaForEdit,
  StatisticalKeyFigureName,
  StstcKeyFigQuantityUnit,
  StstcKeyFigCategory,
  LogsInformationSystemTable,
  LogsInfoSystemKeyFigure,
  UnitOfMeasureLongName,
  StstcKeyFigCategoryDesc,
  ControllingAreaName,
  _UnitOfMeasure.UnitOfMeasure_E AS UnitOfMeasure_E
FROM I_StatisticalKeyFigureTP
LEFT OUTER JOIN C_StatisticalKeyFigureText AS _StatisticalKeyFigureText ON StatisticalKeyFigure = _StatisticalKeyFigureText.StatisticalKeyFigure AND ControllingArea = _StatisticalKeyFigureText.ControllingArea  -- association [1..*]
;

Learn More