I_StatisticalKeyFigureTP

DDL: I_STATISTICALKEYFIGURETP SQL: IFISTATKEYFIGTP Type: view TRANSACTIONAL Package: ODATA_STATISTICALKEYFIGURE_V2
21 Fields 1 Data Sources 1 Associations

Statistical Key Figure Master Record

I_StatisticalKeyFigureTP is a Transactional CDS View that provides data about "Statistical Key Figure Master Record" in SAP S/4HANA. It reads from 1 data source (P_StatisticalKeyFigure) and exposes 21 fields with key fields StatisticalKeyFigure, ControllingArea. It has 1 association to related views. Part of development package ODATA_STATISTICALKEYFIGURE_V2.

Data Sources (1)

SourceAliasJoin Type
P_StatisticalKeyFigure P_StatisticalKeyFigure from

Associations (1)

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

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName IFISTATKEYFIGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.draft.sharing #PUBLIC view
ObjectModel.draft.concurrentEditing true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence TKA03_DRAFT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Statistical Key Figure Master Record view

Fields (21)

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

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 I_StatisticalKeyFigureTP.
-- 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: IFISTATKEYFIGTP

CREATE VIEW I_StatisticalKeyFigureTP AS
SELECT
  StatisticalKeyFigure,
  ControllingArea,
  StatisticalKeyFigure AS StatisticalKeyFigureForEdit,
  ControllingArea AS ControllingAreaForEdit,
  StstcKeyFigQuantityUnit,
  StstcKeyFigCategory,
  StstclKeyFigureOrigin,
  LogsInformationSystemTable,
  LogsInfoSystemKeyFigure,
  StstclKeyFigureIsCurrency,
  StstclKeyFigProcgPlndValType,
  StstclKeyFigProcgActlValType,
  StatisticalKeyFigureName,
  ControllingAreaName,
  UnitOfMeasureLongName,
  StstcKeyFigCategoryDesc
FROM P_StatisticalKeyFigure
LEFT OUTER JOIN I_StatisticalKeyFigureTextTP AS _StatisticalKeyFigureText ON StatisticalKeyFigure = _StatisticalKeyFigureText.StatisticalKeyFigure AND ControllingArea = _StatisticalKeyFigureText.ControllingArea  -- association [1..*]
;

Learn More