I_FxdAstActualLineItem

Actual Line Items of Fixed Asset | view: IFASSETACTUALLIT | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, T093, T001, TKA02, FINSC_LEDGER, FINS_TECH_LEDGER, FAAT_CMP, T093C, TACC_PRINCIPLE, FINSC_ACTVE_APPL
Column Name Description
CompanyCode FK Company Code
MasterFixedAsset FK Fixed Asset
FixedAsset FK Asset Subnumber
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
TransactionSubitem Partial Document to be balanced to zero
AssetDepreciationArea FK Asset Depreciation Area (Real or Derived)
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
FiscalPeriod Fiscal Period
Ledger FK Ledger in General Ledger Accounting
DebitCreditCode Debit/Credit Code Show values
FinancialTransactionType FK Financial Transaction Type
ReferenceDocumentType FK Reference Document Type
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
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
AssetValueDate Asset Value Date
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
Column Name Description
DebitCreditCode Debit/Credit Code Show values
IsStatisticalDocument Boolean Variable (X = True, - = False, Space = Unknown) Show values
FinancialAccountType Financial Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
JrnlEntryItemMigrationSource Journal Entry Item Migration Source Show values
Column Name Description Domain name
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
DocumentItemText Item Text TEXT50
GLBusinessTransactionType Transaction Type for General Ledger VORGN
AssignmentReference Assignment Reference ZUONR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ReversalTransactionSubitem Reversal Transaction Sub Item NUMC6
PersonnelNumber Personnel Number PERNR
GrantID Grant GM_GRANT_NBR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_FXDASTACTUALLINEITEM.MANDT == T003.MANDT
  • I_FXDASTACTUALLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • I_FXDASTACTUALLINEITEM.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_FXDASTACTUALLINEITEM.MANDT == SKA1.MANDT
  • I_FXDASTACTUALLINEITEM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Transaction Type Category I_FXDASTACTUALLINEITEM.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • I_FXDASTACTUALLINEITEM.ASSETTRANSACTIONTYPE == TABW.BWASL
  • I_FXDASTACTUALLINEITEM.MANDT == TABW.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_FXDASTACTUALLINEITEM.BASEUNIT == T006.MSEHI
  • I_FXDASTACTUALLINEITEM.MANDT == T006.MANDT
Budget Period
  • Budget Period
  • Financial Management Area
  • Fund
  • Client
  • I_FXDASTACTUALLINEITEM.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_FXDASTACTUALLINEITEM.FUND == FMFUNDBPD.FINCODE
  • I_FXDASTACTUALLINEITEM.MANDT == FMFUNDBPD.MANDT
Business Area
  • Client
  • Business Area
  • I_FXDASTACTUALLINEITEM.MANDT == TGSB.MANDT
  • I_FXDASTACTUALLINEITEM.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_FXDASTACTUALLINEITEM.MANDT == T004.MANDT
  • I_FXDASTACTUALLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • I_FXDASTACTUALLINEITEM.CHARTOFDEPRECIATION == T096.AFAPL
  • I_FXDASTACTUALLINEITEM.MANDT == T096.MANDT
Company Code
  • Company Code
  • Client
  • I_FXDASTACTUALLINEITEM.COMPANYCODE == T001.BUKRS
  • I_FXDASTACTUALLINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_FXDASTACTUALLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_FXDASTACTUALLINEITEM.MANDT == TKA01.MANDT
  • I_FXDASTACTUALLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • I_FXDASTACTUALLINEITEM.COSTCENTER == CSKS.KOSTL
  • I_FXDASTACTUALLINEITEM.MANDT == CSKS.MANDT
  • I_FXDASTACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • I_FXDASTACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_FXDASTACTUALLINEITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_FXDASTACTUALLINEITEM.MANDT == T004.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_FXDASTACTUALLINEITEM.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_FXDASTACTUALLINEITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_FXDASTACTUALLINEITEM.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FXDASTACTUALLINEITEM.FISCALYEARVARIANT == T009.PERIV
  • I_FXDASTACTUALLINEITEM.MANDT == T009.MANDT
Asset Subnumber
  • ?
  • Asset Subnumber
  • Fixed Asset
  • Client
  • I_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_FXDASTACTUALLINEITEM.FIXEDASSET == ANLA.ANLN2
  • I_FXDASTACTUALLINEITEM.MASTERFIXEDASSET == ANLA.ANLN1
  • I_FXDASTACTUALLINEITEM.MANDT == ANLA.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • I_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • I_FXDASTACTUALLINEITEM.FUNCTIONALAREA == TFKB.FKBER
  • I_FXDASTACTUALLINEITEM.MANDT == TFKB.MANDT
Functional Currency
  • Functional Currency
  • Client
  • I_FXDASTACTUALLINEITEM.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_FXDASTACTUALLINEITEM.FUND == FMFINCODE.FINCODE
  • I_FXDASTACTUALLINEITEM.MANDT == FMFINCODE.MANDT
Funds Management Center
  • Financial Management Area
  • Funds Management Center
  • Client
  • ?
  • I_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_FXDASTACTUALLINEITEM.FUNDSCENTER == FMFCTR.FICTR
  • I_FXDASTACTUALLINEITEM.MANDT == FMFCTR.MANDT
  • I_FXDASTACTUALLINEITEM.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
General Ledger Account
  • General Ledger Account
  • Company Code
  • Client
  • I_FXDASTACTUALLINEITEM.GLACCOUNT == SKB1.SAKNR
  • I_FXDASTACTUALLINEITEM.COMPANYCODE == SKB1.BUKRS
  • I_FXDASTACTUALLINEITEM.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • I_FXDASTACTUALLINEITEM.GLOBALCURRENCY == TCURC.WAERS
  • I_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
Group Asset Subnumber
  • ?
  • Group Asset Subnumber
  • Client
  • Group Asset
  • I_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_FXDASTACTUALLINEITEM.GROUPFIXEDASSET == ANLA.ANLN2
  • I_FXDASTACTUALLINEITEM.MANDT == ANLA.MANDT
  • I_FXDASTACTUALLINEITEM.GROUPMASTERFIXEDASSET == ANLA.ANLN1
Joint Venture Cost Recovery Code
  • ?
  • Client
  • Joint Venture Cost Recovery Code
  • I_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_FXDASTACTUALLINEITEM.MANDT == T8JJ.MANDT
  • I_FXDASTACTUALLINEITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Logical System I_FXDASTACTUALLINEITEM.LOGICALSYSTEM == TBDLS.LOGSYS
Partner Fixed Asset
  • ?
  • Partner Fixed Asset
  • Client
  • Partner Master Fixed Asset
  • I_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_FXDASTACTUALLINEITEM.PARTNERFIXEDASSET == ANLA.ANLN2
  • I_FXDASTACTUALLINEITEM.MANDT == ANLA.MANDT
  • I_FXDASTACTUALLINEITEM.PARTNERMASTERFIXEDASSET == ANLA.ANLN1
Plant
  • Plant
  • Client
  • I_FXDASTACTUALLINEITEM.PLANT == T001W.WERKS
  • I_FXDASTACTUALLINEITEM.MANDT == T001W.MANDT
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • I_FXDASTACTUALLINEITEM.PROFITCENTER == CEPC.PRCTR
  • I_FXDASTACTUALLINEITEM.MANDT == CEPC.MANDT
  • I_FXDASTACTUALLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • I_FXDASTACTUALLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
Reference Document Type I_FXDASTACTUALLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_FXDASTACTUALLINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • I_FXDASTACTUALLINEITEM.MANDT == FAGL_SEGM.MANDT
Subledger-Specific Line Item Type I_FXDASTACTUALLINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE