I_StatisticalKeyFigureTP

DDL: I_STATISTICALKEYFIGURETP SQL: IFISTATKEYFIGTP Type: view TRANSACTIONAL

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.

1 data source(s) 21 fields

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
KEY ControllingArea ControllingArea
StatisticalKeyFigureForEdit StatisticalKeyFigure
ControllingAreaForEdit ControllingArea
StstcKeyFigQuantityUnit StstcKeyFigQuantityUnit
StstcKeyFigCategory StstcKeyFigCategory
StstclKeyFigureOrigin StstclKeyFigureOrigin
LogsInformationSystemTable LogsInformationSystemTable
LogsInfoSystemKeyFigure LogsInfoSystemKeyFigure
StstclKeyFigureIsCurrency StstclKeyFigureIsCurrency
StstclKeyFigProcgPlndValType StstclKeyFigProcgPlndValType
StstclKeyFigProcgActlValType StstclKeyFigProcgActlValType
StatisticalKeyFigureName StatisticalKeyFigureName
ControllingAreaName ControllingAreaName
UnitOfMeasureLongName UnitOfMeasureLongName
StstcKeyFigCategoryDesc StstcKeyFigCategoryDesc
_ControllingArea _ControllingArea
_StatisticalKeyFigureCat _StatisticalKeyFigureCat
_Text _Text
_UnitOfMeasure _UnitOfMeasure
_StatisticalKeyFigureText _StatisticalKeyFigureText 
@AbapCatalog.sqlViewName: 'IFISTATKEYFIGTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #TRANSACTIONAL

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

// BOPF

@ObjectModel.modelCategory: #BUSINESS_OBJECT
@ObjectModel.compositionRoot: true

// Draft Related Annotations

@ObjectModel.draftEnabled: true
@ObjectModel.draft.sharing: #PUBLIC
@ObjectModel.draft.concurrentEditing: true

@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.semanticKey: [ 'StatisticalKeyFigure', 'ControllingArea' ]
@ObjectModel.writeDraftPersistence: 'TKA03_DRAFT'

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: 'EXTERNAL_CALCULATION'
@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION'

@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@EndUserText.label: 'Statistical Key Figure Master Record'
define view I_StatisticalKeyFigureTP as select from P_StatisticalKeyFigure
  association [1..*] to I_StatisticalKeyFigureTextTP as _StatisticalKeyFigureText on  $projection.StatisticalKeyFigure = _StatisticalKeyFigureText.StatisticalKeyFigure
                                                                                  and $projection.ControllingArea = _StatisticalKeyFigureText.ControllingArea 
  {
  //I_StatisticalKeyFigure

  key StatisticalKeyFigure, 
  key ControllingArea, 
  @ObjectModel.mandatory: true
  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  @ObjectModel.editableFieldFor: 'StatisticalKeyFigure'
  StatisticalKeyFigure as StatisticalKeyFigureForEdit,
  @ObjectModel.mandatory: true
  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  @ObjectModel.editableFieldFor: 'ControllingArea'
  ControllingArea as ControllingAreaForEdit,
  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  StstcKeyFigQuantityUnit, 
  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  StstcKeyFigCategory, 
  StstclKeyFigureOrigin,
  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION' 
  LogsInformationSystemTable, 
  @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  LogsInfoSystemKeyFigure, 
  StstclKeyFigureIsCurrency, 
  StstclKeyFigProcgPlndValType, 
  StstclKeyFigProcgActlValType, 
  StatisticalKeyFigureName,
  ControllingAreaName,
  UnitOfMeasureLongName,
  StstcKeyFigCategoryDesc,
  /* Associations */ 
  //I_StatisticalKeyFigure 

  _ControllingArea, 
  _StatisticalKeyFigureCat, 
  _Text, 
  _UnitOfMeasure,
  
  @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]
  _StatisticalKeyFigureText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_STATISTICALKEYFIGURE"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_STATISTICALKEYFIGURECAT",
"I_STATISTICALKEYFIGURETEXT",
"I_STATISTICALKEYFIGURETEXTTP",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_STATISTICALKEYFIGURE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More