I_ASSETKEYFIGURESETSPEC

CDS View
6 Fields 25 CDS Views

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

CDS Views using this table (25)

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 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 15
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 14
_AssetKeyFigure _AssetKeyFigure 3
_AssetKeyFigureSet _AssetKeyFigureSet 3
AssetAccountingSortedKeyFigure AssetAccountingSortedKeyFigure 7
AssetAcctgKeyFigureSortSqnc AssetAcctgKeyFigureSortSqnc 1

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.

-- Fixed Asset Key Figure Set Specification
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ASSETKEYFIGURESETSPEC (
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    _ASSETKEYFIGURE,
    _ASSETKEYFIGURESET,
    ASSETACCOUNTINGSORTEDKEYFIGURE,
    ASSETACCTGKEYFIGURESORTSQNC,
    PRIMARY KEY (ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET)
);

Learn More