C_StatisticalKeyFigureQ0001

DDL: C_STATISTICALKEYFIGUREQ0001 SQL: CFISTKEYFIGQ0001 Type: view CONSUMPTION Package: FINS_FIS_FICO_APPS
7 Fields 1 Data Sources

Statistical Key Figure

C_StatisticalKeyFigureQ0001 is a Consumption CDS View that provides data about "Statistical Key Figure" in SAP S/4HANA. It reads from 1 data source (I_StatisticalKeyFigure) and exposes 7 fields with key fields StatisticalKeyFigure, ControllingArea. Part of development package FINS_FIS_FICO_APPS.

Data Sources (1)

SourceAliasJoin Type
I_StatisticalKeyFigure I_StatisticalKeyFigure from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CFISTKEYFIGQ0001 view
EndUserText.label Statistical Key Figure view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatisticalKeyFigure StatisticalKeyFigure Statistical Key Figure
KEY ControllingArea ControllingArea Controlling Area
StstcKeyFigQuantityUnit StstcKeyFigQuantityUnit Quantity Unit
StstcKeyFigCategory StstcKeyFigCategory Category
StatisticalKeyFigureName
StstcKeyFigCategoryDesc
ControllingAreaName _ControllingArea ControllingAreaName Long Text

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_StatisticalKeyFigureQ0001.
-- 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: CFISTKEYFIGQ0001
-- Parameters: P_Language : sylangu

CREATE VIEW C_StatisticalKeyFigureQ0001 AS
SELECT
  StatisticalKeyFigure,
  ControllingArea,
  StstcKeyFigQuantityUnit,
  StstcKeyFigCategory,
  _Text[1: Language = $parameters.P_Language].StatisticalKeyFigureName AS StatisticalKeyFigureName,
  _StatisticalKeyFigureCat._Text[1: Language = $parameters.P_Language].StstcKeyFigCategoryDesc AS StstcKeyFigCategoryDesc,
  _ControllingArea.ControllingAreaName AS ControllingAreaName
FROM I_StatisticalKeyFigure
;

Learn More