A_StatisticalKeyFigureText

DDL: A_STATISTICALKEYFIGURETEXT SQL: AFISTSTCKEYFIGT Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Statistical Key Figure Text

A_StatisticalKeyFigureText is a Basic CDS View that provides data about "Statistical Key Figure Text" in SAP S/4HANA. It reads from 1 data source (I_StatisticalKeyFigureText) and exposes 5 fields with key fields Language, ControllingArea, StatisticalKeyFigure. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_StatisticalKeyFigureText I_StatisticalKeyFigureText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_StatisticalKeyFigure _StatisticalKeyFigure $projection.ControllingArea = _StatisticalKeyFigure.ControllingArea and $projection.StatisticalKeyFigure = _StatisticalKeyFigure.StatisticalKeyFigure

Annotations (14)

NameValueLevelField
EndUserText.label Statistical Key Figure Text view
AbapCatalog.sqlViewName AFISTSTCKEYFIGT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED 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
AbapCatalog.compiler.compareFilter true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY ControllingArea ControllingArea Controlling Area
KEY StatisticalKeyFigure StatisticalKeyFigure Statistical Key Figure
StatisticalKeyFigureName StatisticalKeyFigureName Statistical Key Figure Name
_StatisticalKeyFigure _StatisticalKeyFigure

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 A_StatisticalKeyFigureText.
-- 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: AFISTSTCKEYFIGT

CREATE VIEW A_StatisticalKeyFigureText AS
SELECT
  Language,
  ControllingArea,
  StatisticalKeyFigure,
  StatisticalKeyFigureName
FROM I_StatisticalKeyFigureText
LEFT OUTER JOIN A_StatisticalKeyFigure AS _StatisticalKeyFigure ON ControllingArea = _StatisticalKeyFigure.ControllingArea AND StatisticalKeyFigure = _StatisticalKeyFigure.StatisticalKeyFigure  -- association [1..1]
;

Learn More