I_AssetKeyFigHierarchyNodeText

DDL: I_ASSETKEYFIGHIERARCHYNODETEXT Type: view BASIC Package: FINS_FAA_CFG_DB

Fixed Asset Key Figure Hierarchy Node Text

I_AssetKeyFigHierarchyNodeText is a Basic CDS View that provides data about "Fixed Asset Key Figure Hierarchy Node Text" in SAP S/4HANA. It reads from 1 data source (P_TF_AssetKeyFigHierNodeText) and exposes 10 fields with key fields AssetAccountingKeyFigureSet, AssetAcctgKeyFigureHierarchy, HierarchyNode, ValidityEndDate, Language. It has 3 associations to related views. Part of development package FINS_FAA_CFG_DB.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
P_TF_AssetKeyFigHierNodeText P_TF_AssetKeyFigHierNodeText from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_AssetKeyFigureSet _AssetKeyFigureSet $projection.AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet
[1..*] I_AssetKeyFigureHierarchy _Hierarchy $projection.AssetAccountingKeyFigureSet = _Hierarchy.AssetAccountingKeyFigureSet and $projection.AssetAcctgKeyFigureHierarchy = _Hierarchy.AssetAcctgKeyFigureHierarchy
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFASSETKFHIERNT view
AbapCatalog.preserveKey true view
EndUserText.label Fixed Asset Key Figure Hierarchy Node Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.representativeKey HierarchyNode view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet
KEY AssetAcctgKeyFigureHierarchy AssetAcctgKeyFigureHierarchy
KEY HierarchyNode HierarchyNode
KEY ValidityEndDate ValidityEndDate
KEY Language Language
HierarchyNodeText HierarchyNodeText
ValidityStartDate ValidityStartDate
_AssetKeyFigureSet _AssetKeyFigureSet
_Hierarchy _Hierarchy
_Language _Language 
@AbapCatalog: {sqlViewName: 'IFASSETKFHIERNT', preserveKey: true}
@EndUserText.label: 'Fixed Asset Key Figure Hierarchy Node Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ObjectModel: { representativeKey: 'HierarchyNode',
                dataCategory: #TEXT,
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_AssetKeyFigHierarchyNodeText
  as select from P_TF_AssetKeyFigHierNodeText( P_SAPClient : $session.client )

  association [0..1] to I_AssetKeyFigureSet       as _AssetKeyFigureSet on  $projection.AssetAccountingKeyFigureSet = _AssetKeyFigureSet.AssetAccountingKeyFigureSet
  association [1..*] to I_AssetKeyFigureHierarchy as _Hierarchy         on  $projection.AssetAccountingKeyFigureSet  = _Hierarchy.AssetAccountingKeyFigureSet
                                                                        and $projection.AssetAcctgKeyFigureHierarchy = _Hierarchy.AssetAcctgKeyFigureHierarchy
  association [0..1] to I_Language                as _Language          on  $projection.Language = _Language.Language
{
        @ObjectModel.foreignKey.association: '_AssetKeyFigureSet'
  key   AssetAccountingKeyFigureSet,
        @ObjectModel.foreignKey.association: '_Hierarchy'
  key   AssetAcctgKeyFigureHierarchy,
  key   HierarchyNode,
        @Semantics.businessDate.to: true
  key   ValidityEndDate,
        @Semantics.language
        @ObjectModel.foreignKey.association: '_Language'
  key   Language,

        @Semantics.text
        HierarchyNodeText,
        @Semantics.businessDate.from: true
        ValidityStartDate,

        _AssetKeyFigureSet,
        _Hierarchy,
        _Language
}

Learn More