P_FixedAssetTransaction1

P_FixedAssetTransaction1 | view: PFASTTRANSACT1 | 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_YDDA, TACC_PRINCIPLE, FAAC_CMP_DA0, ANLA, FAAT_MD, FAAT_MD_ROOT, ANLZ, FAAT_MD_TDD, GLOFAAASSETDATA, GLO_FAAT_MD, ANLB, ANLBZA, FAAT_MD_LD, GLOFAATMDPNDNT, GLO_FAAT_MD_TDD, TACC_TRGT_LDGR, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode FK Company Code
AssetDepreciationArea FK Asset Depreciation Area (Real or Derived)
MasterFixedAsset FK Fixed Asset
FixedAsset FK Asset Subnumber
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetAcctTransClassfctn FK 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
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
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
IsStatisticalDocument Boolean Variable (X = True, - = False, Space = Unknown) Show values
SelectedCurrencyBranch Selected Currency Branch Show values
AssetAuthorizationContext Asset Authorization Context 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
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
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
FixedAssetExternalID Asset Number CHAR17
FixedAssetDescription Asset Description TEXT50
Inventory Inventory Number INVNR_ANLA
AssetCostCenter Asset Cost Center KOSTL
AssetFund Fund of Fixed Asset Master BP_GEBER
AssetProfitCenter Asset Profit Center PRCTR
AssetBudgetPeriod Budget Period of a Fixed Asset FM_BUDGET_PERIOD
AssetGrantID Grant of Fixed Asset Master GM_GRANT_NBR
AssetFunctionalArea Functional Area of Fixed Asset Master FKBER
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
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
Master Data Relations Join Conditions
Key Figure for Asset Accounting
  • Client
  • Key Figure for Asset Accounting
  • P_FIXEDASSETTRANSACTION1.MANDT == FAAC_KFC.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
Key Figure Group
  • Client
  • Key Figure Group
  • P_FIXEDASSETTRANSACTION1.MANDT == FAAC_KFCSET.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETACCOUNTINGKEYFIGURESET == FAAC_KFCSET.KEY_FIGURE_SET
Transaction Type Category P_FIXEDASSETTRANSACTION1.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Business Area
  • Client
  • Asset Business Area
  • P_FIXEDASSETTRANSACTION1.MANDT == TGSB.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETBUSINESSAREA == TGSB.GSBER
Asset location
  • Asset Plant
  • Client
  • Asset location
  • P_FIXEDASSETTRANSACTION1.ASSETPLANT == T499S.WERKS
  • P_FIXEDASSETTRANSACTION1.MANDT == T499S.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETLOCATION == T499S.STAND
Asset Plant
  • Asset Plant
  • Client
  • P_FIXEDASSETTRANSACTION1.ASSETPLANT == T001W.WERKS
  • P_FIXEDASSETTRANSACTION1.MANDT == T001W.MANDT
Segment
  • Client
  • Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • P_FIXEDASSETTRANSACTION1.MANDT == FAGL_SEGM.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETSEGMENT == FAGL_SEGM.SEGMENT
  • P_FIXEDASSETTRANSACTION1.SEGMENT == FAGL_SEGM.SEGMENT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • P_FIXEDASSETTRANSACTION1.MANDT == TABW.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETTRANSACTIONTYPE == TABW.BWASL
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_FIXEDASSETTRANSACTION1.BASEUNIT == T006.MSEHI
  • P_FIXEDASSETTRANSACTION1.MANDT == T006.MANDT
Budget Period
  • Client
  • Financial Management Area
  • Budget Period
  • Fund
  • P_FIXEDASSETTRANSACTION1.MANDT == FMFUNDBPD.MANDT
  • P_FIXEDASSETTRANSACTION1.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • P_FIXEDASSETTRANSACTION1.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_FIXEDASSETTRANSACTION1.FUND == FMFUNDBPD.FINCODE
Business Area
  • Business Area
  • Client
  • P_FIXEDASSETTRANSACTION1.BUSINESSAREA == TGSB.GSBER
  • P_FIXEDASSETTRANSACTION1.MANDT == TGSB.MANDT
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • P_FIXEDASSETTRANSACTION1.MANDT == T096.MANDT
  • P_FIXEDASSETTRANSACTION1.CHARTOFDEPRECIATION == T096.AFAPL
Company Code
  • Company Code
  • Client
  • P_FIXEDASSETTRANSACTION1.COMPANYCODE == T001.BUKRS
  • P_FIXEDASSETTRANSACTION1.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_FIXEDASSETTRANSACTION1.CONTROLLINGAREA == TKA01.KOKRS
  • P_FIXEDASSETTRANSACTION1.MANDT == TKA01.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_FIXEDASSETTRANSACTION1.MANDT == T005.MANDT
  • P_FIXEDASSETTRANSACTION1.COUNTRY == T005.LAND1
Currency Type
  • Client
  • Currency Type
Help for depreciation keys
  • Client
  • Chart of Depreciaton for Asset Valuation
  • Depreciation key
  • P_FIXEDASSETTRANSACTION1.MANDT == T090NA.MANDT
  • P_FIXEDASSETTRANSACTION1.CHARTOFDEPRECIATION == T090NA.AFAPL
  • P_FIXEDASSETTRANSACTION1.DEPRECIATIONKEY == T090NA.AFASL
Display Currency
  • Display Currency
  • Client
  • P_FIXEDASSETTRANSACTION1.DISPLAYCURRENCY == TCURC.WAERS
  • P_FIXEDASSETTRANSACTION1.MANDT == TCURC.MANDT
Financial Management Area
  • Client
  • Financial Management Area
  • P_FIXEDASSETTRANSACTION1.MANDT == FM01.MANDT
  • P_FIXEDASSETTRANSACTION1.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_FIXEDASSETTRANSACTION1.FISCALYEARVARIANT == T009.PERIV
  • P_FIXEDASSETTRANSACTION1.MANDT == T009.MANDT
Asset Subnumber
  • Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • P_FIXEDASSETTRANSACTION1.FIXEDASSET == ANLA.ANLN2
  • P_FIXEDASSETTRANSACTION1.MANDT == ANLA.MANDT
  • P_FIXEDASSETTRANSACTION1.MASTERFIXEDASSET == ANLA.ANLN1
  • P_FIXEDASSETTRANSACTION1.[column in domain "BUKRS"] == ANLA.BUKRS
Functional Area
  • Client
  • Functional Area
  • P_FIXEDASSETTRANSACTION1.MANDT == TFKB.MANDT
  • P_FIXEDASSETTRANSACTION1.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Financial Management Area
  • Fund
  • P_FIXEDASSETTRANSACTION1.MANDT == FMFINCODE.MANDT
  • P_FIXEDASSETTRANSACTION1.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • P_FIXEDASSETTRANSACTION1.FUND == FMFINCODE.FINCODE
Group Asset Subnumber
  • Group Asset Subnumber
  • Client
  • Group Asset
  • ?
  • P_FIXEDASSETTRANSACTION1.GROUPFIXEDASSET == ANLA.ANLN2
  • P_FIXEDASSETTRANSACTION1.MANDT == ANLA.MANDT
  • P_FIXEDASSETTRANSACTION1.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • P_FIXEDASSETTRANSACTION1.[column in domain "BUKRS"] == ANLA.BUKRS
Guideline group
  • Japan: City Code of Property Tax Report
  • Client
  • P_FIXEDASSETTRANSACTION1.JP_PRPTYTXRPTCITY == T087G.GDLGRP
  • P_FIXEDASSETTRANSACTION1.MANDT == T087G.MANDT
Property classification
  • Client
  • Japan: Classification Key of Property Tax Report
  • P_FIXEDASSETTRANSACTION1.MANDT == T092.MANDT
  • P_FIXEDASSETTRANSACTION1.JP_PRPTYTXRPTCLASSFCTNKEY == T092.VMGLI
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Target Ledger Group
  • Client
  • Target Ledger Group
  • P_FIXEDASSETTRANSACTION1.MANDT == FAGL_TLDGRP.MANDT
  • P_FIXEDASSETTRANSACTION1.LEDGERGROUP == FAGL_TLDGRP.LDGRP
Logical System P_FIXEDASSETTRANSACTION1.LOGICALSYSTEM == TBDLS.LOGSYS
Reference Document Type P_FIXEDASSETTRANSACTION1.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Year-dependent index series
  • Client
  • Index series for replacement values
  • P_FIXEDASSETTRANSACTION1.MANDT == T094A.MANDT
  • P_FIXEDASSETTRANSACTION1.REPLACEMENTVALUEINDEXSERS == T094A.WBIND
Age-dependent index series
  • Client
  • Age-Dependent Index Series
  • P_FIXEDASSETTRANSACTION1.MANDT == T094A.MANDT
  • P_FIXEDASSETTRANSACTION1.RPLCMTVALUEAGINGINDEXSERS == T094A.WBIND
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • P_FIXEDASSETTRANSACTION1.MANDT == FAGL_SEGM.MANDT
  • P_FIXEDASSETTRANSACTION1.ASSETSEGMENT == FAGL_SEGM.SEGMENT
  • P_FIXEDASSETTRANSACTION1.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type P_FIXEDASSETTRANSACTION1.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE