P_FixedAssetLineItem1

P_FixedAssetLineItem1 | view: PFASSETLINEITEM | 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

🔑 Keys (13)
💰 Amounts (11)
∑ Quantities (1)
📅 Dates (5)
☰ Categorical (7)
Other (15)
🔗 Relations (48)

Column Name	Description
AssetDepreciationArea FK	Asset Depreciation Area (Real or Derived)
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
MasterFixedAsset FK	Fixed Asset
FixedAsset FK	Asset Subnumber
SubLedgerAcctLineItemType FK	Subledger-Specific Line Item Type
FiscalPeriod	Fiscal Period
LedgerGroup FK	Target Ledger Group
AccountingDocument	Journal Entry
LedgerGLLineItem	Ledger Journal Entry Item
Ledger FK	Ledger in General Ledger Accounting
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
💲 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
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
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 Client Journal Entry Type	`P_FIXEDASSETLINEITEM1.MANDT == T003.MANDT` `P_FIXEDASSETLINEITEM1.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Alternative G/L Account Number In Company Code Client Alternative Chart of Accounts for Country/Region Alternative G/L Account Number In Company Code	`P_FIXEDASSETLINEITEM1.MANDT == SKA1.MANDT` `P_FIXEDASSETLINEITEM1.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL` `P_FIXEDASSETLINEITEM1.ALTERNATIVEGLACCOUNT == SKA1.SAKNR`
Transaction Type Category	`P_FIXEDASSETLINEITEM1.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT`
Asset Transaction Type Client Asset Transaction Type	`P_FIXEDASSETLINEITEM1.MANDT == TABW.MANDT` `P_FIXEDASSETLINEITEM1.ASSETTRANSACTIONTYPE == TABW.BWASL`
Base Unit of Measure Client Base Unit of Measure	`P_FIXEDASSETLINEITEM1.MANDT == T006.MANDT` `P_FIXEDASSETLINEITEM1.BASEUNIT == T006.MSEHI`
Budget Period Financial Management Area Client Budget Period Fund	`P_FIXEDASSETLINEITEM1.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS` `P_FIXEDASSETLINEITEM1.MANDT == FMFUNDBPD.MANDT` `P_FIXEDASSETLINEITEM1.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD` `P_FIXEDASSETLINEITEM1.FUND == FMFUNDBPD.FINCODE`
Business Area Client Business Area	`P_FIXEDASSETLINEITEM1.MANDT == TGSB.MANDT` `P_FIXEDASSETLINEITEM1.BUSINESSAREA == TGSB.GSBER`
Chart of Accounts Client Chart of Accounts	`P_FIXEDASSETLINEITEM1.MANDT == T004.MANDT` `P_FIXEDASSETLINEITEM1.CHARTOFACCOUNTS == T004.KTOPL`
Chart of Depreciaton for Asset Valuation Chart of Depreciaton for Asset Valuation Client	`P_FIXEDASSETLINEITEM1.CHARTOFDEPRECIATION == T096.AFAPL` `P_FIXEDASSETLINEITEM1.MANDT == T096.MANDT`
Company Code Client Company Code	`P_FIXEDASSETLINEITEM1.MANDT == T001.MANDT` `P_FIXEDASSETLINEITEM1.COMPANYCODE == T001.BUKRS`
Company Code Currency Client Company Code Currency	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.COMPANYCODECURRENCY == TCURC.WAERS`
Controlling Area Client Controlling Area	`P_FIXEDASSETLINEITEM1.MANDT == TKA01.MANDT` `P_FIXEDASSETLINEITEM1.CONTROLLINGAREA == TKA01.KOKRS`
Cost Center Client ? Controlling Area Cost Center	`P_FIXEDASSETLINEITEM1.MANDT == CSKS.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "DATBI"] == CSKS.DATBI` `P_FIXEDASSETLINEITEM1.CONTROLLINGAREA == CSKS.KOKRS` `P_FIXEDASSETLINEITEM1.COSTCENTER == CSKS.KOSTL`
Country/Region Key Country/Region Key Client	`P_FIXEDASSETLINEITEM1.COUNTRY == T005.LAND1` `P_FIXEDASSETLINEITEM1.MANDT == T005.MANDT`
Alternative Chart of Accounts for Country/Region Client Alternative Chart of Accounts for Country/Region	`P_FIXEDASSETLINEITEM1.MANDT == T004.MANDT` `P_FIXEDASSETLINEITEM1.COUNTRYCHARTOFACCOUNTS == T004.KTOPL`
Financial Management Area Financial Management Area Client	`P_FIXEDASSETLINEITEM1.FINANCIALMANAGEMENTAREA == FM01.FIKRS` `P_FIXEDASSETLINEITEM1.MANDT == FM01.MANDT`
Fiscal Year Variant Client Fiscal Year Variant	`P_FIXEDASSETLINEITEM1.MANDT == T009.MANDT` `P_FIXEDASSETLINEITEM1.FISCALYEARVARIANT == T009.PERIV`
Asset Subnumber Client ? Fixed Asset Asset Subnumber	`P_FIXEDASSETLINEITEM1.MANDT == ANLA.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "BUKRS"] == ANLA.BUKRS` `P_FIXEDASSETLINEITEM1.MASTERFIXEDASSET == ANLA.ANLN1` `P_FIXEDASSETLINEITEM1.FIXEDASSET == ANLA.ANLN2`
Freely Defined Currency 1 Client Freely Defined Currency 1	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY1 == TCURC.WAERS`
Freely Defined Currency 2 Client Freely Defined Currency 2	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY2 == TCURC.WAERS`
Freely Defined Currency 3 Client Freely Defined Currency 3	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY3 == TCURC.WAERS`
Freely Defined Currency 4 Client Freely Defined Currency 4	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY4 == TCURC.WAERS`
Freely Defined Currency 5 Client Freely Defined Currency 5	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY5 == TCURC.WAERS`
Freely Defined Currency 6 Client Freely Defined Currency 6	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY6 == TCURC.WAERS`
Freely Defined Currency 7 Client Freely Defined Currency 7	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Client Freely Defined Currency 8	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FREEDEFINEDCURRENCY8 == TCURC.WAERS`
Functional Area Client Functional Area	`P_FIXEDASSETLINEITEM1.MANDT == TFKB.MANDT` `P_FIXEDASSETLINEITEM1.FUNCTIONALAREA == TFKB.FKBER`
Functional Currency Client Functional Currency	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.FUNCTIONALCURRENCY == TCURC.WAERS`
Fund Financial Management Area Client Fund	`P_FIXEDASSETLINEITEM1.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS` `P_FIXEDASSETLINEITEM1.MANDT == FMFINCODE.MANDT` `P_FIXEDASSETLINEITEM1.FUND == FMFINCODE.FINCODE`
Funds Management Center Financial Management Area Funds Management Center Client ?	`P_FIXEDASSETLINEITEM1.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS` `P_FIXEDASSETLINEITEM1.FUNDSCENTER == FMFCTR.FICTR` `P_FIXEDASSETLINEITEM1.MANDT == FMFCTR.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS`
General Ledger Account General Ledger Account Client Company Code	`P_FIXEDASSETLINEITEM1.GLACCOUNT == SKB1.SAKNR` `P_FIXEDASSETLINEITEM1.MANDT == SKB1.MANDT` `P_FIXEDASSETLINEITEM1.COMPANYCODE == SKB1.BUKRS`
Global Currency Client Global Currency	`P_FIXEDASSETLINEITEM1.MANDT == TCURC.MANDT` `P_FIXEDASSETLINEITEM1.GLOBALCURRENCY == TCURC.WAERS`
Group Asset Subnumber Group Asset Subnumber Client ? Group Asset	`P_FIXEDASSETLINEITEM1.GROUPFIXEDASSET == ANLA.ANLN2` `P_FIXEDASSETLINEITEM1.MANDT == ANLA.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "BUKRS"] == ANLA.BUKRS` `P_FIXEDASSETLINEITEM1.GROUPMASTERFIXEDASSET == ANLA.ANLN1`
Joint Venture Cost Recovery Code Client ? Joint Venture Cost Recovery Code	`P_FIXEDASSETLINEITEM1.MANDT == T8JJ.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "BUKRS"] == T8JJ.BUKRS` `P_FIXEDASSETLINEITEM1.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`P_FIXEDASSETLINEITEM1.MANDT == FINSC_LEDGER.MANDT` `P_FIXEDASSETLINEITEM1.LEDGER == FINSC_LEDGER.RLDNR`
Target Ledger Group Target Ledger Group Client	`P_FIXEDASSETLINEITEM1.LEDGERGROUP == FAGL_TLDGRP.LDGRP` `P_FIXEDASSETLINEITEM1.MANDT == FAGL_TLDGRP.MANDT`
Logical System	`P_FIXEDASSETLINEITEM1.LOGICALSYSTEM == TBDLS.LOGSYS`
Partner Fixed Asset Client ? Partner Master Fixed Asset Partner Fixed Asset	`P_FIXEDASSETLINEITEM1.MANDT == ANLA.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "BUKRS"] == ANLA.BUKRS` `P_FIXEDASSETLINEITEM1.PARTNERMASTERFIXEDASSET == ANLA.ANLN1` `P_FIXEDASSETLINEITEM1.PARTNERFIXEDASSET == ANLA.ANLN2`
Plant Client Plant	`P_FIXEDASSETLINEITEM1.MANDT == T001W.MANDT` `P_FIXEDASSETLINEITEM1.PLANT == T001W.WERKS`
Profit Center Client ? Controlling Area Profit Center	`P_FIXEDASSETLINEITEM1.MANDT == CEPC.MANDT` `P_FIXEDASSETLINEITEM1.[column in domain "DATBI"] == CEPC.DATBI` `P_FIXEDASSETLINEITEM1.CONTROLLINGAREA == CEPC.KOKRS` `P_FIXEDASSETLINEITEM1.PROFITCENTER == CEPC.PRCTR`
Reference Document Type	`P_FIXEDASSETLINEITEM1.REFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_FIXEDASSETLINEITEM1.MANDT == FAGL_SEGM.MANDT` `P_FIXEDASSETLINEITEM1.SEGMENT == FAGL_SEGM.SEGMENT`
Subledger-Specific Line Item Type	`P_FIXEDASSETLINEITEM1.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE`