I_FxdAstLineItemWithCrcyRole

Fixed Asset Line Items with currency role | view: IFASSETLITCRCYRL | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, T093, T001, TKA02, FINSC_LEDGER, FINS_TECH_LEDGER, FAAT_CMP, T093C, TACC_PRINCIPLE, TACC_TRGT_LDGR, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode FK Company Code
MasterFixedAsset FK Fixed Asset
FixedAsset FK Asset Subnumber
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetDepreciationArea FK Asset Depreciation Area (Real or Derived)
LedgerGroup FK Target Ledger Group
Ledger FK Ledger in General Ledger Accounting
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 Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global 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
AssetValueDate Asset Value Date
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Financial Account Type Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
IsStatisticalDocument Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
AssignmentReference Assignment Reference ZUONR
GLBusinessTransactionType Transaction Type for General Ledger VORGN
DocumentItemText Item Text TEXT50
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reverse Document BELNR
ReversalTransactionSubitem Reversal Transaction Sub Item NUMC6
GrantID Grant GM_GRANT_NBR
Master Data Relations Join Conditions
Transaction Type Category I_FXDASTLINEITEMWITHCRCYROLE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TABW.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.ASSETTRANSACTIONTYPE == TABW.BWASL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == T006.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.BASEUNIT == T006.MSEHI
Budget Period
  • Financial Management Area
  • Client
  • Budget Period
  • Fund
  • I_FXDASTLINEITEMWITHCRCYROLE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FMFUNDBPD.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_FXDASTLINEITEMWITHCRCYROLE.FUND == FMFUNDBPD.FINCODE
Business Area
  • Client
  • Business Area
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TGSB.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == T004.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.CHARTOFACCOUNTS == T004.KTOPL
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == T096.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.CHARTOFDEPRECIATION == T096.AFAPL
Company Code
  • Client
  • Company Code
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == T001.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.COMPANYCODECURRENCY == TCURC.WAERS
Company Code Currency Role
  • Client
  • Company Code Currency Role
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.COMPANYCODECURRENCYROLE == FINSC_CURTYPE.CURTYPE
Controlling Area
  • Client
  • Controlling Area
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TKA01.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.CONTROLLINGAREA == TKA01.KOKRS
Financial Management Area
  • Financial Management Area
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FM01.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FISCALYEARVARIANT == T009.PERIV
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == T009.MANDT
Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • Asset Subnumber
  • I_FXDASTLINEITEMWITHCRCYROLE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == ANLA.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_FXDASTLINEITEMWITHCRCYROLE.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
Freely Defined Currency 1 Role (Currency Type)
  • Client
  • Freely Defined Currency 1 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY1ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
Freely Defined Currency 2 Role (Currency Type)
  • Client
  • Freely Defined Currency 2 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY2ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
Freely Defined Currency 3 Role (Currency Type)
  • Client
  • Freely Defined Currency 3 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY3ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
Freely Defined Currency 4 Role (Currency Type)
  • Client
  • Freely Defined Currency 4 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY4ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 5 Role (Currency Type)
  • Client
  • Freely Defined Currency 5 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY5ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
Freely Defined Currency 6 Role (Currency Type)
  • Client
  • Freely Defined Currency 6 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY6ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 7 Role (Currency Type)
  • Client
  • Freely Defined Currency 7 Role (Currency Type)
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY7ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Freely Defined Currency 8 Role (Currency Type)
  • Freely Defined Currency 8 Role (Currency Type)
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.FREEDEFINEDCURRENCY8ROLE == FINSC_CURTYPE.CURTYPE
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
Functional Area
  • Client
  • Functional Area
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TFKB.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_FXDASTLINEITEMWITHCRCYROLE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FMFINCODE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.FUND == FMFINCODE.FINCODE
Global Currency
  • Client
  • Global Currency
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == TCURC.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.GLOBALCURRENCY == TCURC.WAERS
Global Currency Role
  • Client
  • Global Currency Role
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_CURTYPE.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.GLOBALCURRENCYROLE == FINSC_CURTYPE.CURTYPE
Group Asset Subnumber
  • ?
  • Client
  • Group Asset
  • Group Asset Subnumber
  • I_FXDASTLINEITEMWITHCRCYROLE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == ANLA.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • I_FXDASTLINEITEMWITHCRCYROLE.GROUPFIXEDASSET == ANLA.ANLN2
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_LEDGER.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.LEDGER == FINSC_LEDGER.RLDNR
  • I_FXDASTLINEITEMWITHCRCYROLE.REPRESENTATIVELEDGER == FINSC_LEDGER.RLDNR
Target Ledger Group
  • Target Ledger Group
  • Client
  • I_FXDASTLINEITEMWITHCRCYROLE.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FAGL_TLDGRP.MANDT
Logical System I_FXDASTLINEITEMWITHCRCYROLE.LOGICALSYSTEM == TBDLS.LOGSYS
Reference Document Type I_FXDASTLINEITEMWITHCRCYROLE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FINSC_LEDGER.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.LEDGER == FINSC_LEDGER.RLDNR
  • I_FXDASTLINEITEMWITHCRCYROLE.REPRESENTATIVELEDGER == FINSC_LEDGER.RLDNR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_FXDASTLINEITEMWITHCRCYROLE.MANDT == FAGL_SEGM.MANDT
  • I_FXDASTLINEITEMWITHCRCYROLE.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type I_FXDASTLINEITEMWITHCRCYROLE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE