P_FxdAstActualLineItem

P_FxdAstActualLineItem | view: PFASSETACTUALLIT | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, FINSC_LEDGER, FINS_TECH_LEDGER, 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 Source Ledger
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
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
  • Journal Entry Type
  • Client
  • P_FXDASTACTUALLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FXDASTACTUALLINEITEM.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Client
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • P_FXDASTACTUALLINEITEM.MANDT == SKA1.MANDT
  • P_FXDASTACTUALLINEITEM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • P_FXDASTACTUALLINEITEM.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
Transaction Type Category P_FXDASTACTUALLINEITEM.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • P_FXDASTACTUALLINEITEM.MANDT == TABW.MANDT
  • P_FXDASTACTUALLINEITEM.ASSETTRANSACTIONTYPE == TABW.BWASL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_FXDASTACTUALLINEITEM.MANDT == T006.MANDT
  • P_FXDASTACTUALLINEITEM.BASEUNIT == T006.MSEHI
Budget Period
  • Financial Management Area
  • Budget Period
  • Client
  • Fund
  • P_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • P_FXDASTACTUALLINEITEM.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_FXDASTACTUALLINEITEM.MANDT == FMFUNDBPD.MANDT
  • P_FXDASTACTUALLINEITEM.FUND == FMFUNDBPD.FINCODE
Business Area
  • Client
  • Business Area
  • P_FXDASTACTUALLINEITEM.MANDT == TGSB.MANDT
  • P_FXDASTACTUALLINEITEM.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_FXDASTACTUALLINEITEM.MANDT == T004.MANDT
  • P_FXDASTACTUALLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_FXDASTACTUALLINEITEM.MANDT == T001.MANDT
  • P_FXDASTACTUALLINEITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_FXDASTACTUALLINEITEM.MANDT == TKA01.MANDT
  • P_FXDASTACTUALLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • P_FXDASTACTUALLINEITEM.MANDT == CSKS.MANDT
  • P_FXDASTACTUALLINEITEM.COSTCENTER == CSKS.KOSTL
  • P_FXDASTACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_FXDASTACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_FXDASTACTUALLINEITEM.MANDT == T004.MANDT
  • P_FXDASTACTUALLINEITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Financial Management Area
  • Financial Management Area
  • Client
  • P_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • P_FXDASTACTUALLINEITEM.MANDT == FM01.MANDT
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_FXDASTACTUALLINEITEM.MANDT == T856.MANDT
  • P_FXDASTACTUALLINEITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_FXDASTACTUALLINEITEM.MANDT == T009.MANDT
  • P_FXDASTACTUALLINEITEM.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Client
  • Fixed Asset
  • Asset Subnumber
  • ?
  • P_FXDASTACTUALLINEITEM.MANDT == ANLA.MANDT
  • P_FXDASTACTUALLINEITEM.MASTERFIXEDASSET == ANLA.ANLN1
  • P_FXDASTACTUALLINEITEM.FIXEDASSET == ANLA.ANLN2
  • P_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • P_FXDASTACTUALLINEITEM.MANDT == TFKB.MANDT
  • P_FXDASTACTUALLINEITEM.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.FUNCTIONALCURRENCY == TCURC.WAERS
Fund
  • Financial Management Area
  • Client
  • Fund
  • P_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • P_FXDASTACTUALLINEITEM.MANDT == FMFINCODE.MANDT
  • P_FXDASTACTUALLINEITEM.FUND == FMFINCODE.FINCODE
Funds Management Center
  • Financial Management Area
  • Client
  • ?
  • Funds Management Center
  • P_FXDASTACTUALLINEITEM.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • P_FXDASTACTUALLINEITEM.MANDT == FMFCTR.MANDT
  • P_FXDASTACTUALLINEITEM.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • P_FXDASTACTUALLINEITEM.FUNDSCENTER == FMFCTR.FICTR
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_FXDASTACTUALLINEITEM.MANDT == SKB1.MANDT
  • P_FXDASTACTUALLINEITEM.COMPANYCODE == SKB1.BUKRS
  • P_FXDASTACTUALLINEITEM.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_FXDASTACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_FXDASTACTUALLINEITEM.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • Client
  • Group Asset
  • Group Asset Subnumber
  • ?
  • P_FXDASTACTUALLINEITEM.MANDT == ANLA.MANDT
  • P_FXDASTACTUALLINEITEM.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • P_FXDASTACTUALLINEITEM.GROUPFIXEDASSET == ANLA.ANLN2
  • P_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • P_FXDASTACTUALLINEITEM.MANDT == T8JJ.MANDT
  • P_FXDASTACTUALLINEITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == T8JJ.BUKRS
Source Ledger
  • Client
  • Source Ledger
Logical System P_FXDASTACTUALLINEITEM.LOGICALSYSTEM == TBDLS.LOGSYS
Partner Fixed Asset
  • Client
  • ?
  • Partner Master Fixed Asset
  • Partner Fixed Asset
  • P_FXDASTACTUALLINEITEM.MANDT == ANLA.MANDT
  • P_FXDASTACTUALLINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_FXDASTACTUALLINEITEM.PARTNERMASTERFIXEDASSET == ANLA.ANLN1
  • P_FXDASTACTUALLINEITEM.PARTNERFIXEDASSET == ANLA.ANLN2
Plant
  • Client
  • Plant
  • P_FXDASTACTUALLINEITEM.MANDT == T001W.MANDT
  • P_FXDASTACTUALLINEITEM.PLANT == T001W.WERKS
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • P_FXDASTACTUALLINEITEM.PROFITCENTER == CEPC.PRCTR
  • P_FXDASTACTUALLINEITEM.MANDT == CEPC.MANDT
  • P_FXDASTACTUALLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_FXDASTACTUALLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
Reference Document Type P_FXDASTACTUALLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_FXDASTACTUALLINEITEM.MANDT == FAGL_SEGM.MANDT
  • P_FXDASTACTUALLINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type P_FXDASTACTUALLINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE