I_ASSETKEYFIGURESPECIFICATION
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA