FAC_DART_Z3_LINEITEM_FIXEDAST

Fixed Assets - Line Item | view: FAC_DZLIMFAST | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, BKPF, BSEG, ANLH, T093, T001, TKA02, FINSC_LEDGER, FINS_TECH_LEDGER, FAAT_CMP, T093C, T001, T014, T093C, TACC_PRINCIPLE, FAAC_CMP_DA0_T, T093, T093C, T093T, FAAC_CMP_DA0, T093, T093C, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, FAAT_MD, FAAT_MD_ROOT, TACC_TRGT_LDGR, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP, FAGL_TLDGRP_MAP, FAGL_TLDGRP_MAP
Column Name Description
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
Totalquantity Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry 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
Column Name Description Domain name
system_client Client
FixedAssetDescription Asset Description TEXT50
MasterFixedAssetDescription Asset Main Number Text TEXT50
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item BUZEI
DebitCreditCodeName Debit/Credit Code Name DDTEXT
AssetDepreciationAreaName Name of Depreciation Area TEXT50
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
TransactionSubitem Partial Document to be balanced to zero NUMC6
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 Reverse Document BELNR
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
DocumentItemText Item Text TEXT50
GLBusinessTransactionType Transaction Type for General Ledger VORGN
AssignmentReference Assignment Reference ZUONR
ReversalTransactionSubitem Reversal Transaction Sub Item NUMC6
PersonnelNumber Personnel Number PERNR
OriginalReferenceDocument Original Reference Document AWKEY
TaxCountry Tax Reporting Country/Region LAND1
IntercompanyTransaction Intercompany Transaction Number BVORG
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T003.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • FAC_DART_Z3_LINEITEM_FIXEDAST.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == SKA1.MANDT
Transaction Type Category FAC_DART_Z3_LINEITEM_FIXEDAST.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.ASSETTRANSACTIONTYPE == TABW.BWASL
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TABW.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T006.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.BASEUNIT == T006.MSEHI
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.BASEUNITOFMEASURE == T006.MSEHI
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.BUSINESSAREA == TGSB.GSBER
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.CHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T004.MANDT
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.CHARTOFDEPRECIATION == T096.AFAPL
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T096.MANDT
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T001.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TKA01.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Cost Center
  • Controlling Area
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == CSKS.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "DATBI"] == CSKS.DATBI
  • FAC_DART_Z3_LINEITEM_FIXEDAST.COSTCENTER == CSKS.KOSTL
  • FAC_DART_Z3_LINEITEM_FIXEDAST.CONTROLLINGAREA == CSKS.KOKRS
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T004.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T009.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • Asset Subnumber
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "BUKRS"] == ANLA.BUKRS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == ANLA.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MASTERFIXEDASSET == ANLA.ANLN1
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TFKB.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • ?
  • Fund
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == FMFINCODE.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FUND == FMFINCODE.FINCODE
Funds Management Center
  • Client
  • ?
  • Funds Management Center
  • ?
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == FMFCTR.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.FUNDSCENTER == FMFCTR.FICTR
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "FIKRS"] == FMFCTR.FIKRS
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • FAC_DART_Z3_LINEITEM_FIXEDAST.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == SKB1.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TCURC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • ?
  • Client
  • Group Asset
  • Group Asset Subnumber
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "BUKRS"] == ANLA.BUKRS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == ANLA.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • FAC_DART_Z3_LINEITEM_FIXEDAST.GROUPFIXEDASSET == ANLA.ANLN2
Joint Venture Cost Recovery Code
  • ?
  • Joint Venture Cost Recovery Code
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "BUKRS"] == T8JJ.BUKRS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T8JJ.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Target Ledger Group
  • Target Ledger Group
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == FAGL_TLDGRP.MANDT
Logical System FAC_DART_Z3_LINEITEM_FIXEDAST.LOGICALSYSTEM == TBDLS.LOGSYS
Material Number
  • Client
  • Product Number
  • Material Number
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == MARA.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.PRODUCT == MARA.MATNR
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MATERIALNUMBER == MARA.MATNR
Partner Business Area
  • Client
  • Partner Business Area
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == TGSB.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.PARTNERCOMPANY == T880.RCOMP
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T880.MANDT
Plant
  • Client
  • Plant
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T001W.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • Material Number
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == MARA.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.PRODUCT == MARA.MATNR
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MATERIALNUMBER == MARA.MATNR
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == CEPC.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "DATBI"] == CEPC.DATBI
  • FAC_DART_Z3_LINEITEM_FIXEDAST.CONTROLLINGAREA == CEPC.KOKRS
  • FAC_DART_Z3_LINEITEM_FIXEDAST.PROFITCENTER == CEPC.PRCTR
Reference Document Type FAC_DART_Z3_LINEITEM_FIXEDAST.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == FAGL_SEGM.MANDT
  • FAC_DART_Z3_LINEITEM_FIXEDAST.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type FAC_DART_Z3_LINEITEM_FIXEDAST.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • FAC_DART_Z3_LINEITEM_FIXEDAST.TAXCODE == T007A.MWSKZ
  • FAC_DART_Z3_LINEITEM_FIXEDAST.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_LINEITEM_FIXEDAST.MANDT == T007A.MANDT