I_ASSETKEYFIGURESPECIFICATION

CDS View

Asset Key Figure Specification

I_ASSETKEYFIGURESPECIFICATION is a CDS View in S/4HANA. Asset Key Figure Specification. It contains 7 fields. 21 CDS views read from this table.

Used by 21 CDS view(s) 7 fields

CDS Views using this table (21)

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 inner COMPOSITE Key Figure Spec. of Asset History Sheet Hierarchy (Actual)
I_ActualAssetBalWithTmpPlanVal view_entity inner COMPOSITE Actual asset balance with temp. plan values
I_FixedAssetValWithTmpPlanVal view inner COMPOSITE Fixed Asset values with temp. plan values
I_PlanHistSheetHierKeyFigSpec view inner COMPOSITE Key Figure Spec. of Asset History Sheet Hierarchy (Plan)
P_AssetBalanceCube2 view_entity inner COMPOSITE
P_AssetHistorySheetCube3 view_entity 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 (7)

KeyField CDS FieldsUsed in Views
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 9
KEY AssetAcctAnlytlTransClassfctn AssetAcctAnlytlTransClassfctn 2
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 2
_AssetAcctAnlytlTransClassfctn _AssetAcctAnlytlTransClassfctn 2
_AssetKeyFigure _AssetKeyFigure 2
_SubLedgerAccLineItemType _SubLedgerAccLineItemType 2
PlannedValueIsInclusive PlannedValueIsInclusive 2 
@AbapCatalog: {sqlViewName: 'IASSETKEYFIGSPEC', preserveKey: true}
@EndUserText.label: 'Asset Key Figure Specification'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #M,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_AssetKeyFigureSpecification
  as select from faac_kfc_spec

  association [0..1] to I_AssetKeyFigure           as _AssetKeyFigure                on $projection.AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure
  association [0..1] to I_AnlytlMovementCategory   as _AssetAcctAnlytlTransClassfctn on $projection.AssetAcctAnlytlTransClassfctn = _AssetAcctAnlytlTransClassfctn.AssetAcctAnlytlTransClassfctn
  association [0..1] to I_SubLedgerAccLineItemType as _SubLedgerAccLineItemType      on $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
{
      @ObjectModel.foreignKey.association: '_AssetKeyFigure'
  key faac_kfc_spec.key_figure_code as AssetAccountingKeyFigure,
      @ObjectModel.foreignKey.association: '_AssetAcctAnlytlTransClassfctn'
  key faac_kfc_spec.movcat          as AssetAcctAnlytlTransClassfctn,
      @ObjectModel.foreignKey.association: '_SubledgerAccLineItemType'
  key faac_kfc_spec.slalittype      as SubLedgerAcctLineItemType,
      faac_kfc_spec.use_value_type  as PlannedValueIsInclusive,

      _AssetKeyFigure,
      _AssetAcctAnlytlTransClassfctn,
      _SubLedgerAccLineItemType
}

Learn More