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. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Asset Key Figure Specification
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSETKEYFIGURESPECIFICATION (
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCTANLYTLTRANSCLASSFCTN,
    SUBLEDGERACCTLINEITEMTYPE,
    _ASSETACCTANLYTLTRANSCLASSFCTN,
    _ASSETKEYFIGURE,
    _SUBLEDGERACCLINEITEMTYPE,
    PLANNEDVALUEISINCLUSIVE,
    PRIMARY KEY (ASSETACCOUNTINGKEYFIGURE, ASSETACCTANLYTLTRANSCLASSFCTN, SUBLEDGERACCTLINEITEMTYPE)
);