I_AssetKeyFigureHierarchy

DDL: I_ASSETKEYFIGUREHIERARCHY Type: view BASIC Package: FINS_FAA_CFG_DB

Fixed Asset Key Figure Hierarchy

I_AssetKeyFigureHierarchy is a Basic CDS View (Dimension) that provides data about "Fixed Asset Key Figure Hierarchy" in SAP S/4HANA. It reads from 1 data source (P_TF_AssetKeyFigureHierarchy) and exposes 7 fields with key fields AssetAccountingKeyFigureSet, AssetAcctgKeyFigureHierarchy, ValidityEndDate. It has 2 associations to related views. Part of development package FINS_FAA_CFG_DB.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
P_TF_AssetKeyFigureHierarchy P_TF_AssetKeyFigureHierarchy from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_AssetKeyFigureSet _AssetKeyFigureSet $projection.AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet
[0..*] I_AssetKeyFigureHierarchyText _Text $projection.AssetAccountingKeyFigureSet = _Text.AssetAccountingKeyFigureSet and $projection.AssetAcctgKeyFigureHierarchy = _Text.AssetAcctgKeyFigureHierarchy

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFASSETKFHIER view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Fixed Asset Key Figure Hierarchy view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.representativeKey AssetAcctgKeyFigureHierarchy view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet
KEY AssetAcctgKeyFigureHierarchy AssetAcctgKeyFigureHierarchy
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
LastChangeTime LastChangeTime
_AssetKeyFigureSet _AssetKeyFigureSet
_Text _Text 
@AbapCatalog: {sqlViewName: 'IFASSETKFHIER', preserveKey: true}
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Fixed Asset Key Figure Hierarchy'
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@ObjectModel: { representativeKey: 'AssetAcctgKeyFigureHierarchy',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #L,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions: true}

define view I_AssetKeyFigureHierarchy
  as select from P_TF_AssetKeyFigureHierarchy( P_SAPClient : $session.client )

  association [0..1] to I_AssetKeyFigureSet           as _AssetKeyFigureSet on  $projection.AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet
  association [0..*] to I_AssetKeyFigureHierarchyText as _Text              on  $projection.AssetAccountingKeyFigureSet  = _Text.AssetAccountingKeyFigureSet
                                                                            and $projection.AssetAcctgKeyFigureHierarchy = _Text.AssetAcctgKeyFigureHierarchy
{
          @ObjectModel.foreignKey.association: '_AssetKeyFigureSet'
  key     AssetAccountingKeyFigureSet,
          @ObjectModel.text.association: '_Text'
  key     AssetAcctgKeyFigureHierarchy,
          @Semantics.businessDate.to: true
  key     ValidityEndDate,

          @Semantics.businessDate.from: true
          ValidityStartDate,
          @Semantics.systemDateTime.lastChangedAt: true
          LastChangeTime,

          _AssetKeyFigureSet,
          _Text
}

Learn More