I_ActualAssetBalWithTmpPlanVal

Actual asset balance with temp. plan values | view: IACTASTBALTMPPV | Extraction: Not supported | Component: Master Data
Tables used: FAAT_DOC_IT, ACDOCA, T093, FAAC_KFCSET_SPEC, T001, TKA02, FINSC_LEDGER, FINS_TECH_LEDGER, FAAT_CMP, T093C, T093C, TACC_PRINCIPLE, FAAC_CMP_DA0, T093, T093C, FAAT_D_PV_HDR, FAAT_D_PV_VALUES, TACC_TRGT_LDGR, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode FK Company Code
AssetDepreciationArea FK Asset Depreciation Area (Real or Derived)
MasterFixedAsset FK Fixed Asset
FixedAsset FK Asset Subnumber
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
AssetAccountingKeyFigure FK Key Figure for Asset Accounting
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetAcctTransClassfctn FK Transaction Type Category
AccountingDocument Journal Entry
TransactionSubitem Partial Document to be balanced to zero
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency null
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 null
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 null
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 null
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 null
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 null
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 null
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 null
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
PlannedValueIsInclusive Value Type for Asset Reporting & Aging Report Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Key Figure for Asset Accounting
  • Key Figure for Asset Accounting
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FAAC_KFC.MANDT
Transaction Type Category I_ACTUALASSETBALWITHTMPPLANVAL.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.CHARTOFDEPRECIATION == T096.AFAPL
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == T096.MANDT
Company Code
  • Company Code
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.COMPANYCODE == T001.BUKRS
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.COMPANYCODECURRENCY == TCURC.WAERS
Company Code Currency Role
  • Company Code Currency Role
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.COMPANYCODECURRENCYROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • Asset Subnumber
  • I_ACTUALASSETBALWITHTMPPLANVAL.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == ANLA.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.MASTERFIXEDASSET == ANLA.ANLN1
  • I_ACTUALASSETBALWITHTMPPLANVAL.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Freely Defined Currency 1 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY1ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 2 Role (Currency Type)
  • Freely Defined Currency 2 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY2ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
Freely Defined Currency 3 Role (Currency Type)
  • Freely Defined Currency 3 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY3ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 4 Role (Currency Type)
  • Freely Defined Currency 4 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY4ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 5 Role (Currency Type)
  • Freely Defined Currency 5 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY5ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
Freely Defined Currency 6 Role (Currency Type)
  • Freely Defined Currency 6 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY6ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
Freely Defined Currency 7 Role (Currency Type)
  • Freely Defined Currency 7 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY7ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Freely Defined Currency 8 Role (Currency Type)
  • Freely Defined Currency 8 Role (Currency Type)
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.FREEDEFINEDCURRENCY8ROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Global Currency
  • Global Currency
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.GLOBALCURRENCY == TCURC.WAERS
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == TCURC.MANDT
Global Currency Role
  • Global Currency Role
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.GLOBALCURRENCYROLE == FINSC_CURTYPE.CURTYPE
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FINSC_CURTYPE.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Target Ledger Group
  • Target Ledger Group
  • Client
  • I_ACTUALASSETBALWITHTMPPLANVAL.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • I_ACTUALASSETBALWITHTMPPLANVAL.MANDT == FAGL_TLDGRP.MANDT
Subledger-Specific Line Item Type I_ACTUALASSETBALWITHTMPPLANVAL.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE