I_ASSETKEYFIGURESETSPEC

CDS View

Fixed Asset Key Figure Set Specification

I_ASSETKEYFIGURESETSPEC is a CDS View in S/4HANA. Fixed Asset Key Figure Set Specification. It contains 6 fields. 26 CDS views read from this table.

Used by 26 CDS view(s) 6 fields

CDS Views using this table (26)

ViewTypeJoinVDMDescription
C_RO_SAFTFixedAssetTransCube view inner CONSUMPTION RO SAFT Fixed Asset Transaction - Cube
FAA_SDM_BALANCE01 view inner Asset balance cube 01
FAA_UPA_MIG_BAL_OLD01 view_entity inner Balance cube for old asset 01
FAA_UPA_MIG_BALANCE01 view_entity inner Asset balance cube 01
FAA_UPA_MIG_DA_KFC_ACDOCA01 view_entity inner Aggregate ACDOCA for derived area 01
FAA_UPA_MIG_DA_KFC_DOCIT01 view_entity inner Aggregate DOC_IT for derived area 01
FAA_UPA_MIG_DI_BALANCE01 view_entity inner DOC_IT balance layer 01
FAA_UPA_MIG_DI_KFC_ACDOCA01 view_entity inner Aggregate ACDOCA for tech ledger 01
FAA_UPA_MIG_DI_KFC_DOCIT01 view_entity inner Aggregate DOC_IT for tech ledger 01
I_ActlHistSheetHierKeyFigSpec view from COMPOSITE Key Figure Spec. of Asset History Sheet Hierarchy (Actual)
I_ActualAssetBalWithTmpPlanVal view_entity inner COMPOSITE Actual asset balance with temp. plan values
I_AssetSortedKeyFigureSetSpec view from BASIC Sorted Fixed Asset Key Figure Set Specification
I_FixedAssetValWithTmpPlanVal view inner COMPOSITE Fixed Asset values with temp. plan values
I_PlanHistSheetHierKeyFigSpec view from COMPOSITE Key Figure Spec. of Asset History Sheet Hierarchy (Plan)
P_AssetBalanceCube2 view_entity inner COMPOSITE
P_AssetHistorySheetCube1 view_entity inner COMPOSITE
P_AssetHistorySheetCube3 view_entity inner COMPOSITE
P_AUDIT_AT_AstSrtKeyFigSetSpec view from COMPOSITE
P_DartFixedAssetValue view inner COMPOSITE
P_FixedAssetAHSValue view inner COMPOSITE
P_FixedAssetDepreciationList2 view_entity inner COMPOSITE
P_FixedAssetDepreciationListKF view inner COMPOSITE
P_FixedAssetTransaction view inner COMPOSITE
P_FixedAssetTransaction2 view_entity inner COMPOSITE
P_FixedAssetValue view inner COMPOSITE
P_FixedAssetValueForToFsclPerd view inner COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 16
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 15
_AssetKeyFigure _AssetKeyFigure 3
_AssetKeyFigureSet _AssetKeyFigureSet 3
AssetAccountingSortedKeyFigure AssetAccountingSortedKeyFigure 7
AssetAcctgKeyFigureSortSqnc AssetAcctgKeyFigureSortSqnc 1 
@AbapCatalog: {sqlViewName: 'IASTKEYFSETSPEC', preserveKey: true}
@EndUserText.label: 'Fixed Asset Key Figure Set Specification'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_AssetKeyFigureSetSpec
  as select from faac_kfcset_spec as faac_kfcset_spec

  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..*] to I_AssetKeyFigureSetSpecText as _Text              on  $projection.AssetAccountingKeyFigureSet = _Text.AssetAccountingKeyFigureSet
                                                                          and $projection.AssetAccountingKeyFigure    = _Text.AssetAccountingKeyFigure

{
      @ObjectModel.foreignKey.association: '_AssetKeyFigureSet'
  key key_figure_set           as AssetAccountingKeyFigureSet,
      @ObjectModel.foreignKey.association: '_AssetKeyfigure'
      @ObjectModel.text.association: '_Text'
  key key_figure_code          as AssetAccountingKeyFigure,

      sorted_key_figure_code   as AssetAcctgKeyFigureSortSqnc,
      zero_amount_kf_is_hidden as ZeroBalAmountKeyFigureIsHidden,
      sorted_kfc               as AssetAccountingSortedKeyFigure,

      _AssetKeyFigureSet,
      _AssetKeyFigure,
      _Text
}

Learn More