P_ActualAstBalWithTmpPlanVal1

Time Restriction | view: PACTASTBALTMPPV1 | 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
  • P_ACTUALASTBALWITHTMPPLANVAL1.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FAAC_KFC.MANDT
Transaction Type Category P_ACTUALASTBALWITHTMPPLANVAL1.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == T096.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.CHARTOFDEPRECIATION == T096.AFAPL
Company Code
  • Client
  • Company Code
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == T001.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.COMPANYCODECURRENCY == TCURC.WAERS
Company Code Currency Role
  • Client
  • Company Code Currency Role
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.COMPANYCODECURRENCYROLE == FINSC_CURTYPE.CURTYPE
Asset Subnumber
  • Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • P_ACTUALASTBALWITHTMPPLANVAL1.FIXEDASSET == ANLA.ANLN2
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == ANLA.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.MASTERFIXEDASSET == ANLA.ANLN1
  • P_ACTUALASTBALWITHTMPPLANVAL1.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Client
  • Freely Defined Currency 1 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY1ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 2 Role (Currency Type)
  • Client
  • Freely Defined Currency 2 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY2ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 3 Role (Currency Type)
  • Client
  • Freely Defined Currency 3 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY3ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
Freely Defined Currency 4 Role (Currency Type)
  • Client
  • Freely Defined Currency 4 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY4ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 5 Role (Currency Type)
  • Client
  • Freely Defined Currency 5 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY5ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 6 Role (Currency Type)
  • Client
  • Freely Defined Currency 6 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY6ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 7 Role (Currency Type)
  • Client
  • Freely Defined Currency 7 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY7ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Freely Defined Currency 8 Role (Currency Type)
  • Client
  • Freely Defined Currency 8 Role (Currency Type)
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.FREEDEFINEDCURRENCY8ROLE == FINSC_CURTYPE.CURTYPE
Global Currency
  • Client
  • Global Currency
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == TCURC.MANDT
  • P_ACTUALASTBALWITHTMPPLANVAL1.GLOBALCURRENCY == TCURC.WAERS
Global Currency Role
  • Global Currency Role
  • Client
  • P_ACTUALASTBALWITHTMPPLANVAL1.GLOBALCURRENCYROLE == FINSC_CURTYPE.CURTYPE
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FINSC_CURTYPE.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Target Ledger Group
  • Target Ledger Group
  • Client
  • P_ACTUALASTBALWITHTMPPLANVAL1.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • P_ACTUALASTBALWITHTMPPLANVAL1.MANDT == FAGL_TLDGRP.MANDT
Subledger-Specific Line Item Type P_ACTUALASTBALWITHTMPPLANVAL1.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE