I_AssetKeyFigureSetSpecText

DDL: I_ASSETKEYFIGURESETSPECTEXT Type: view BASIC

Asset Key Figure Set Specification Text

I_AssetKeyFigureSetSpecText is a Basic CDS View that provides data about "Asset Key Figure Set Specification Text" in SAP S/4HANA. It reads from 1 data source (faac_kfcsetspect) and exposes 7 fields with key fields Language, AssetAccountingKeyFigureSet, AssetAccountingKeyFigure. It has 3 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
faac_kfcsetspect faac_kfcsetspect from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_AssetKeyFigureSet _AssetKeyFigureSet $projection.AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet
[0..1] I_AssetKeyFigure _AssetKeyFigure $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IASTKEYFSETSPECT view
AbapCatalog.preserveKey true view
EndUserText.label Asset Key Figure Set Specification Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey AssetAccountingKeyFigure view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language faac_kfcsetspect langu
KEY AssetAccountingKeyFigureSet key_figure_set
KEY AssetAccountingKeyFigure key_figure_code
AssetAccountingKeyFigureText
_AssetKeyFigureSet _AssetKeyFigureSet
_AssetKeyFigure _AssetKeyFigure
_Language _Language 
@AbapCatalog: {sqlViewName: 'IASTKEYFSETSPECT', preserveKey: true}
@EndUserText.label: 'Asset Key Figure Set Specification Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { representativeKey: 'AssetAccountingKeyFigure',
                dataCategory: #TEXT,
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_AssetKeyFigureSetSpecText
  as select from faac_kfcsetspect

  association [0..1] to I_AssetKeyFigureSet as _AssetKeyFigureSet on $projection.AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet
  association [0..1] to I_AssetKeyFigure    as _AssetKeyFigure    on $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
  association [0..1] to I_Language          as _Language          on $projection.Language = _Language.Language
{
      @Semantics.language
  key faac_kfcsetspect.langu                                                         as Language,
      @ObjectModel.foreignKey.association: '_AssetKeyFigureSet'
  key key_figure_set                                                                 as AssetAccountingKeyFigureSet,
      @ObjectModel.foreignKey.association: '_AssetKeyfigure'
  key key_figure_code                                                                as AssetAccountingKeyFigure,

      @Semantics.text: true
      cast ( faac_kfcsetspect.key_figure_lname as fis_ltext_kfct preserving type )   as AssetAccountingKeyFigureText,

      _AssetKeyFigureSet,
      _AssetKeyFigure,
      _Language
}

Learn More