P_FixedAssetDepreciationList2

P_FixedAssetDepreciationList2 | view: PFASTDEPRCLIST2 | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, ACDOCP, FAAT_PLAN_VALUES, T093, FAAC_KFCSET_SPEC, FAAT_MD_VAL_TDD, FAAT_MD_VAL, T001, TKA02, FINSC_LEDGER, T093B, FINS_TECH_LEDGER, FAAT_CMP, T093C, FAAT_CMP_DA, FAAT_MD_VAL_TDD, FAAT_MD_VAL_YDDA, T093C, TACC_PRINCIPLE, FAAC_CMP_DA0, T093, T093C, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, ANLZ, FAAT_MD_TDD, TKA02, ANLA, GLOFAAASSETDATA, GLO_FAAT_MD, T001, ANLB, ANLBZA, ANLA, FAAT_MD_LD, FINSC_LEDGER, GLOFAATMDPNDNT, GLO_FAAT_MD_TDD, T001, 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
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetAcctTransClassfctn FK Transaction Type Category
AssetAccountingKeyFigure FK Key Figure for Asset Accounting
AssetAccountingKeyFigureSet FK Key Figure Group
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
TransactionSubitem Partial Document to be balanced to zero
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
AssetCapitalizationDate Asset Capitalization Date
DepreciationStartDate Depreciation Calculation Start Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
AssetAuthorizationContext Asset Authorization Context Show values
PlannedUsefulLifeInPeriods Planned Useful Life in Periods Show values
OriglAstUsefulLifeInPerds Original Useful Life in Periods Show values
DeprKeyChangeoverPeriod Changeover Period of Depreciation Key Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FunctionalCurrencyRole Functional Currency Role (Currency Type) FINS_CURTYPE
FixedAssetExternalID Asset Number CHAR17
AssetCostCenter Asset Cost Center KOSTL
AssetFund Fund of Fixed Asset Master BP_GEBER
AssetProfitCenter Asset Profit Center PRCTR
AssetBudgetPeriod Budget Period of a Fixed Asset FM_BUDGET_PERIOD
AssetGrantID Grant of Fixed Asset Master GM_GRANT_NBR
AssetFunctionalArea Functional Area of Fixed Asset Master FKBER
PlannedUsefulLifeInYears Planned Useful Life in Years JARAF
OriglAstUsefulLifeInYears Original useful life in years JARAF
DeprKeyChangeoverYear Changeover Year of Depreciation Key GJAHR
VintageYear Acquisition Year GJAHR
VintageMonth Acquisition Month POPER
NationalClassification National Classification Code GLO_NATL_CLFN_CODE
TaxDepreciationGroup Tax Depreciation Group GLO_TAX_DEPR_GRP
RU_AssetOKOF OKOF Code
RU_AssetDepreciationGroup Depreciation Group J_3RFAMORTGR
Master Data Relations Join Conditions
Key Figure for Asset Accounting
  • Key Figure for Asset Accounting
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FAAC_KFC.MANDT
Key Figure Group
  • Key Figure Group
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.ASSETACCOUNTINGKEYFIGURESET == FAAC_KFCSET.KEY_FIGURE_SET
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FAAC_KFCSET.MANDT
Transaction Type Category P_FIXEDASSETDEPRECIATIONLIST2.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Business Area
  • Asset Business Area
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.ASSETBUSINESSAREA == TGSB.GSBER
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TGSB.MANDT
Asset Plant
  • Client
  • Asset Plant
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T001W.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.ASSETPLANT == T001W.WERKS
Segment
  • Client
  • Segment for Segmental Reporting
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FAGL_SEGM.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.ASSETSEGMENT == FAGL_SEGM.SEGMENT
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T096.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.CHARTOFDEPRECIATION == T096.AFAPL
Company Code
  • Client
  • Company Code
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T001.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.COMPANYCODECURRENCY == TCURC.WAERS
Company Code Currency Role
  • Client
  • Company Code Currency Role
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.COMPANYCODECURRENCYROLE == FINSC_CURTYPE.CURTYPE
Controlling Area
  • Client
  • Controlling Area
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TKA01.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Country/Region Key
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.COUNTRY == T005.LAND1
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T005.MANDT
Help for depreciation keys
  • Depreciation key
  • Client
  • Chart of Depreciaton for Asset Valuation
  • P_FIXEDASSETDEPRECIATIONLIST2.DEPRECIATIONKEY == T090NA.AFASL
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T090NA.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.CHARTOFDEPRECIATION == T090NA.AFAPL
Financial Management Area
  • Financial Management Area
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FM01.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T009.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • P_FIXEDASSETDEPRECIATIONLIST2.FIXEDASSET == ANLA.ANLN2
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == ANLA.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.MASTERFIXEDASSET == ANLA.ANLN1
  • P_FIXEDASSETDEPRECIATIONLIST2.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Client
  • Freely Defined Currency 1 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY1ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 2 Role (Currency Type)
  • Client
  • Freely Defined Currency 2 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY2ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 3 Role (Currency Type)
  • Client
  • Freely Defined Currency 3 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY3ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 4 Role (Currency Type)
  • Client
  • Freely Defined Currency 4 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY4ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 5 Role (Currency Type)
  • Client
  • Freely Defined Currency 5 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY5ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 6 Role (Currency Type)
  • Client
  • Freely Defined Currency 6 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY6ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 7 Role (Currency Type)
  • Client
  • Freely Defined Currency 7 Role (Currency Type)
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY7ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Freely Defined Currency 8 Role (Currency Type)
  • Freely Defined Currency 8 Role (Currency Type)
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.FREEDEFINEDCURRENCY8ROLE == FINSC_CURTYPE.CURTYPE
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
Functional Currency
  • Client
  • Functional Currency
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.FUNCTIONALCURRENCY == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == TCURC.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.GLOBALCURRENCY == TCURC.WAERS
Global Currency Role
  • Global Currency Role
  • Client
  • P_FIXEDASSETDEPRECIATIONLIST2.GLOBALCURRENCYROLE == FINSC_CURTYPE.CURTYPE
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == FINSC_CURTYPE.MANDT
Guideline group
  • Client
  • Japan: City Code of Property Tax Report
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T087G.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.JP_PRPTYTXRPTCITY == T087G.GDLGRP
Property classification
  • Client
  • Japan: Classification Key of Property Tax Report
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T092.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.JP_PRPTYTXRPTCLASSFCTNKEY == T092.VMGLI
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Year-dependent index series
  • Client
  • Index series for replacement values
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T094A.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.REPLACEMENTVALUEINDEXSERS == T094A.WBIND
Age-dependent index series
  • Client
  • Age-Dependent Index Series
  • P_FIXEDASSETDEPRECIATIONLIST2.MANDT == T094A.MANDT
  • P_FIXEDASSETDEPRECIATIONLIST2.RPLCMTVALUEAGINGINDEXSERS == T094A.WBIND
Subledger-Specific Line Item Type P_FIXEDASSETDEPRECIATIONLIST2.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE