P_StatisticalKeyFigure

DDL: P_STATISTICALKEYFIGURE SQL: PFISTATKEYFIG Type: view COMPOSITE Package: ODATA_STATISTICALKEYFIGURE_V2

Statistical Key Figure

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

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_StatisticalKeyFigure I_StatisticalKeyFigure from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFISTATKEYFIG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY StatisticalKeyFigure StatisticalKeyFigure
KEY ControllingArea ControllingArea
StstcKeyFigQuantityUnit
StstcKeyFigCategory
StstclKeyFigureOrigin StstclKeyFigureOrigin
LogsInformationSystemTable
LogsInfoSystemKeyFigure LogsInfoSystemKeyFigure
StstclKeyFigureIsCurrency StstclKeyFigureIsCurrency
StstclKeyFigProcgPlndValType StstclKeyFigProcgPlndValType
StstclKeyFigProcgActlValType StstclKeyFigProcgActlValType
ControllingAreaName _ControllingArea ControllingAreaName
StatisticalKeyFigureName
StstcKeyFigCategoryDesc
UnitOfMeasureLongName
_ControllingArea _ControllingArea
_StatisticalKeyFigureCat _StatisticalKeyFigureCat
_Text _Text
_UnitOfMeasure _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'PFISTATKEYFIG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_StatisticalKeyFigure as select from I_StatisticalKeyFigure {
  //I_StatisticalKeyFigure 

  key StatisticalKeyFigure, 
  key ControllingArea, 
  @Semantics.unitOfMeasure  
  cast (StstcKeyFigQuantityUnit as fis_ui_seinh preserving type ) as StstcKeyFigQuantityUnit, 
  cast (StstcKeyFigCategory as fis_ui_grtyp preserving type) as StstcKeyFigCategory, 
  StstclKeyFigureOrigin, 
  cast ( LogsInformationSystemTable as fco_gstru preserving type ) as LogsInformationSystemTable, 
  LogsInfoSystemKeyFigure, 
  StstclKeyFigureIsCurrency, 
  StstclKeyFigProcgPlndValType, 
  StstclKeyFigProcgActlValType, 
  _ControllingArea.ControllingAreaName,
  cast(_Text[1:Language = $session.system_language].StatisticalKeyFigureName as fis_ui_stagr_text) as StatisticalKeyFigureName,
  _StatisticalKeyFigureCat._Text[1:Language = $session.system_language].StstcKeyFigCategoryDesc,
  _UnitOfMeasure._Text[1:Language = $session.system_language].UnitOfMeasureLongName,
  /* Associations */ 
  //I_StatisticalKeyFigure 

  _ControllingArea, 
  _StatisticalKeyFigureCat, 
  _Text, 
  _UnitOfMeasure
}

Learn More