I_FixedAssetTransaction

Asset Transactions | view: IFASSETTRAN | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, 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 Company Code
AssetDepreciationArea Asset Depreciation Area (Real or Derived)
MasterFixedAsset Fixed Asset
FixedAsset Asset Subnumber
Ledger Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType Subledger-Specific Line Item Type
AssetAcctTransClassfctn 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
CurrencyRole FK Currency Type
Column Name Description
💲 Display Currency (DisplayCurrency):
AmountInDisplayCurrency Amount in Company Code Currency
AcqnProdnAmtInDspCrcy Acquisition and Production Costs Amount in Display Currency
ValueAdjustmentAmtInDspCrcy Value Adjustment Amount in Display Currency
RetirementRevenueAmtInDspCrcy Retirement Revenue Amount in Display Currency
RetirementCostsAmtInDspCrcy Retirement Costs in Display Currency
RetirementLossAmtInDspCrcy Retirement Loss Amount in Display Currency
RetirementGainAmtInDspCrcy Retirement Gain Amount in Display Currency
RetirementDeprAmtInDspCrcy Retirement Depreciation Amount in Display Currency
RetirementAmountInDspCrcy Retirement Amount in Display Currency
RtrmtNetBookValueAmtInDspCrcy Retirement Net Book Value in Display Currency
OrdinaryDeprAmtInDspCrcy Ordinary Depreciation Amount in Display Currency
SpecialDeprAmtInDspCrcy Special Depreciation Amount in Display Currency
UnplannedDeprAmtInDspCrcy Unplanned Depreciation Amount in Display Currency
TransferredReserveAmtInDspCrcy Transferred Reserve Amount in Display Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
PostingDate Posting Date
DocumentDate Journal Entry Date
AssetValueDate Asset Value 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
AssetTransactionVariant Transaction Variant of Asset Transactions Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Financial Account Type Show values
SelectedCurrencyBranch Selected Currency Branch Show values
IsStatisticalDocument Boolean Variable (X = True, - = False, Space = Unknown) 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
FiscalYearVariant Fiscal Year Variant PERIV
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FixedAssetExternalID Asset Number CHAR17
CompanyCodeName Name of Company Code or Company TEXT25
GroupMasterFixedAsset Group Asset ANLN1
GroupFixedAsset Group Asset Subnumber ANLN2
AccountingDocCreatedByUser User that created the journal entry
AssetTransactionType Asset Transaction Type BWASL
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocument Reference document number AWREF
LogicalSystem Logical System LOGSYS
ReferenceDocumentContext Reference Document Context AWORG
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reverse Document BELNR
ReversalTransactionSubitem Reversal Transaction Sub Item NUMC6
BusinessArea Business Area GSBER
Segment Segment for Segmental Reporting FB_SEGMENT
ControllingArea Controlling Area CACCD
FinancialManagementArea Financial Management Area FIKRS
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
BudgetPeriod Budget Period FM_BUDGET_PERIOD
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
FixedAssetDescription Asset Description TEXT50
Inventory Inventory Number INVNR_ANLA
AssetCostCenter Asset Cost Center KOSTL
AssetProfitCenter Asset Profit Center PRCTR
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
Master Data Relations Join Conditions
Key Figure for Asset Accounting
  • Key Figure for Asset Accounting
  • Client
  • I_FIXEDASSETTRANSACTION.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
  • I_FIXEDASSETTRANSACTION.MANDT == FAAC_KFC.MANDT
Key Figure Group
  • Key Figure Group
  • Client
  • I_FIXEDASSETTRANSACTION.ASSETACCOUNTINGKEYFIGURESET == FAAC_KFCSET.KEY_FIGURE_SET
  • I_FIXEDASSETTRANSACTION.MANDT == FAAC_KFCSET.MANDT
Asset Business Area
  • Asset Business Area
  • Client
  • I_FIXEDASSETTRANSACTION.ASSETBUSINESSAREA == TGSB.GSBER
  • I_FIXEDASSETTRANSACTION.MANDT == TGSB.MANDT
Asset location
  • Asset location
  • Client
  • Asset Plant
  • I_FIXEDASSETTRANSACTION.ASSETLOCATION == T499S.STAND
  • I_FIXEDASSETTRANSACTION.MANDT == T499S.MANDT
  • I_FIXEDASSETTRANSACTION.ASSETPLANT == T499S.WERKS
Asset Plant
  • Client
  • Asset Plant
  • I_FIXEDASSETTRANSACTION.MANDT == T001W.MANDT
  • I_FIXEDASSETTRANSACTION.ASSETPLANT == T001W.WERKS
Segment
  • Segment for Segmental Reporting
  • Client
  • I_FIXEDASSETTRANSACTION.ASSETSEGMENT == FAGL_SEGM.SEGMENT
  • I_FIXEDASSETTRANSACTION.MANDT == FAGL_SEGM.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_FIXEDASSETTRANSACTION.MANDT == T006.MANDT
  • I_FIXEDASSETTRANSACTION.BASEUNIT == T006.MSEHI
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • I_FIXEDASSETTRANSACTION.CHARTOFDEPRECIATION == T096.AFAPL
  • I_FIXEDASSETTRANSACTION.MANDT == T096.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_FIXEDASSETTRANSACTION.COUNTRY == T005.LAND1
  • I_FIXEDASSETTRANSACTION.MANDT == T005.MANDT
Currency Type
  • Client
  • Currency Type
Help for depreciation keys
  • Chart of Depreciaton for Asset Valuation
  • Depreciation key
  • Client
  • I_FIXEDASSETTRANSACTION.CHARTOFDEPRECIATION == T090NA.AFAPL
  • I_FIXEDASSETTRANSACTION.DEPRECIATIONKEY == T090NA.AFASL
  • I_FIXEDASSETTRANSACTION.MANDT == T090NA.MANDT
Guideline group
  • Japan: City Code of Property Tax Report
  • Client
  • I_FIXEDASSETTRANSACTION.JP_PRPTYTXRPTCITY == T087G.GDLGRP
  • I_FIXEDASSETTRANSACTION.MANDT == T087G.MANDT
Property classification
  • Japan: Classification Key of Property Tax Report
  • Client
  • I_FIXEDASSETTRANSACTION.JP_PRPTYTXRPTCLASSFCTNKEY == T092.VMGLI
  • I_FIXEDASSETTRANSACTION.MANDT == T092.MANDT
Target Ledger Group
  • Target Ledger Group
  • Client
Year-dependent index series
  • Index series for replacement values
  • Client
  • I_FIXEDASSETTRANSACTION.REPLACEMENTVALUEINDEXSERS == T094A.WBIND
  • I_FIXEDASSETTRANSACTION.MANDT == T094A.MANDT
Age-dependent index series
  • Age-Dependent Index Series
  • Client
  • I_FIXEDASSETTRANSACTION.RPLCMTVALUEAGINGINDEXSERS == T094A.WBIND
  • I_FIXEDASSETTRANSACTION.MANDT == T094A.MANDT