C_FxdAstLineItmValueByCrcyRole

Cons. View Line Items of a Fixed Asset | view: CFALITVALCRCYRL | Extraction: Not supported | Component: Fiori UI for Asset Accounting
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, T093, TABW, TABWT, T001, TKA02, FINSC_LEDGER, FAAI_MOVCAT, FAAI_MOVCATT, FINSTS_SLALITTY, FINSTS_SLALITTYT, FINS_TECH_LEDGER, FAAT_CMP, T093C, 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
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
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
Column Name Description
💲 Display Currency (DisplayCurrency):
AmountInDisplayCurrency Amount in Display Currency
FxdAstStatisticalAmtInDspCrcy Statistical Amount in Asset Accounting
Column Name Description
Column Name Description
AssetValueDate Asset Value Date
DocumentDate Journal Entry Date
PostingDate Posting Date
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
Column Name Description
DebitCreditCode Debit/Credit Code Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
FinancialAccountType Financial Account Type Show values
Column Name Description Domain name
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReversalReferenceDocument Reverse Document BELNR
ReversalTransactionSubitem Reversal Transaction Sub Item NUMC6
SubLedgerAcctLineItemTypeName Subledger-Specific Line Item Type Text TEXT70
AssetTransactionTypeName Asset Transaction Type Name TEXT50
AssetAcctTransClassfctnName Transaction Type Category Text TEXT50
Master Data Relations Join Conditions
Transaction Type Category C_FXDASTLINEITMVALUEBYCRCYROLE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == TABW.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.ASSETTRANSACTIONTYPE == TABW.BWASL
Business Area
  • Client
  • Business Area
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == TGSB.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.BUSINESSAREA == TGSB.GSBER
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == T096.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.CHARTOFDEPRECIATION == T096.AFAPL
Company Code
  • Company Code
  • Client
  • C_FXDASTLINEITMVALUEBYCRCYROLE.COMPANYCODE == T001.BUKRS
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == T001.MANDT
Asset Subnumber
  • Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • C_FXDASTLINEITMVALUEBYCRCYROLE.FIXEDASSET == ANLA.ANLN2
  • C_FXDASTLINEITMVALUEBYCRCYROLE.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == ANLA.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MASTERFIXEDASSET == ANLA.ANLN1
Group Asset Subnumber
  • ?
  • Group Asset Subnumber
  • Client
  • Group Asset
  • C_FXDASTLINEITMVALUEBYCRCYROLE.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_FXDASTLINEITMVALUEBYCRCYROLE.GROUPFIXEDASSET == ANLA.ANLN2
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == ANLA.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.GROUPMASTERFIXEDASSET == ANLA.ANLN1
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == FINSC_LEDGER.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.LEDGER == FINSC_LEDGER.RLDNR
  • C_FXDASTLINEITMVALUEBYCRCYROLE.REPRESENTATIVELEDGER == FINSC_LEDGER.RLDNR
Target Ledger Group
  • Target Ledger Group
  • Client
  • C_FXDASTLINEITMVALUEBYCRCYROLE.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == FAGL_TLDGRP.MANDT
Logical System C_FXDASTLINEITMVALUEBYCRCYROLE.LOGICALSYSTEM == TBDLS.LOGSYS
Reference Document Type C_FXDASTLINEITMVALUEBYCRCYROLE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == FINSC_LEDGER.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.LEDGER == FINSC_LEDGER.RLDNR
  • C_FXDASTLINEITMVALUEBYCRCYROLE.REPRESENTATIVELEDGER == FINSC_LEDGER.RLDNR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_FXDASTLINEITMVALUEBYCRCYROLE.MANDT == FAGL_SEGM.MANDT
  • C_FXDASTLINEITMVALUEBYCRCYROLE.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type C_FXDASTLINEITMVALUEBYCRCYROLE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE