P_FixedAssetValueWthDetn

P_FixedAssetValue | view: PFASSETVALDTN | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, ACDOCP, T093, T001, TKA02, FINSC_LEDGER, FINS_TECH_LEDGER, FAAT_CMP, T093C, TACC_PRINCIPLE, ANLA, FAAT_MD_LD, TACC_TRGT_LDGR, FAAC_KFC_AMC_DET, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP
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
AccountingDocument Journal Entry
TransactionSubitem Partial Document to be balanced to zero
Ledger FK Ledger in General Ledger Accounting
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetAcctTransClassfctn FK Transaction Type Category
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
ActualAmountInCompanyCodeCrcy Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency Amount in Company Code Currency
PlanAmountInGlobalCurrency Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
ActualAmountInFreeDfndCrcy1 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy1 Amount in Company Code Currency
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
ActualAmountInFreeDfndCrcy2 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy2 Amount in Company Code Currency
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
ActualAmountInFreeDfndCrcy3 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy3 Amount in Company Code Currency
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
ActualAmountInFreeDfndCrcy4 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy4 Amount in Company Code Currency
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
ActualAmountInFreeDfndCrcy5 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy5 Amount in Company Code Currency
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
ActualAmountInFreeDfndCrcy6 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy6 Amount in Company Code Currency
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
ActualAmountInFreeDfndCrcy7 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy7 Amount in Company Code Currency
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
ActualAmountInFreeDfndCrcy8 Amount in Company Code Currency
PlanAmountInFreeDefinedCrcy8 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
AssetDeactivationDate Deactivation Date
DocumentDate Journal Entry Date
PostingDate Posting Date
AssetValueDate Asset Value Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
FinancialAccountType Financial Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsStatisticalDocument Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsPlanningDocument Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AssetAcctAnlytlTransClassfctn Transaction Type Category FAA_MOVCAT
PersonnelNumber Personnel Number PERNR
GrantID Grant GM_GRANT_NBR
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
ReversalTransactionSubitem Reversal Transaction Sub Item NUMC6
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
GLBusinessTransactionType Transaction Type for General Ledger VORGN
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T003.MANDT
  • P_FIXEDASSETVALUEWTHDETN.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • P_FIXEDASSETVALUEWTHDETN.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_FIXEDASSETVALUEWTHDETN.MANDT == SKA1.MANDT
  • P_FIXEDASSETVALUEWTHDETN.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Transaction Type Category P_FIXEDASSETVALUEWTHDETN.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TABW.MANDT
  • P_FIXEDASSETVALUEWTHDETN.ASSETTRANSACTIONTYPE == TABW.BWASL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T006.MANDT
  • P_FIXEDASSETVALUEWTHDETN.BASEUNIT == T006.MSEHI
Budget Period
  • Budget Period
  • Client
  • Financial Management Area
  • Fund
  • P_FIXEDASSETVALUEWTHDETN.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_FIXEDASSETVALUEWTHDETN.MANDT == FMFUNDBPD.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • P_FIXEDASSETVALUEWTHDETN.FUND == FMFUNDBPD.FINCODE
Business Area
  • Client
  • Business Area
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TGSB.MANDT
  • P_FIXEDASSETVALUEWTHDETN.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T004.MANDT
  • P_FIXEDASSETVALUEWTHDETN.CHARTOFACCOUNTS == T004.KTOPL
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • P_FIXEDASSETVALUEWTHDETN.CHARTOFDEPRECIATION == T096.AFAPL
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T096.MANDT
Company Code
  • Company Code
  • Client
  • P_FIXEDASSETVALUEWTHDETN.COMPANYCODE == T001.BUKRS
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • P_FIXEDASSETVALUEWTHDETN.MANDT == CSKS.MANDT
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "DATBI"] == CSKS.DATBI
  • P_FIXEDASSETVALUEWTHDETN.COSTCENTER == CSKS.KOSTL
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_FIXEDASSETVALUEWTHDETN.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T004.MANDT
Financial Management Area
  • Client
  • Financial Management Area
  • P_FIXEDASSETVALUEWTHDETN.MANDT == FM01.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_FIXEDASSETVALUEWTHDETN.FISCALYEARVARIANT == T009.PERIV
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T009.MANDT
Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • Asset Subnumber
  • P_FIXEDASSETVALUEWTHDETN.MANDT == ANLA.MANDT
  • P_FIXEDASSETVALUEWTHDETN.MASTERFIXEDASSET == ANLA.ANLN1
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_FIXEDASSETVALUEWTHDETN.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TFKB.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Financial Management Area
  • Fund
  • P_FIXEDASSETVALUEWTHDETN.MANDT == FMFINCODE.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • P_FIXEDASSETVALUEWTHDETN.FUND == FMFINCODE.FINCODE
Funds Management Center
  • Client
  • Financial Management Area
  • ?
  • Funds Management Center
  • P_FIXEDASSETVALUEWTHDETN.MANDT == FMFCTR.MANDT
  • P_FIXEDASSETVALUEWTHDETN.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • P_FIXEDASSETVALUEWTHDETN.FUNDSCENTER == FMFCTR.FICTR
General Ledger Account
  • General Ledger Account
  • Company Code
  • Client
  • P_FIXEDASSETVALUEWTHDETN.GLACCOUNT == SKB1.SAKNR
  • P_FIXEDASSETVALUEWTHDETN.COMPANYCODE == SKB1.BUKRS
  • P_FIXEDASSETVALUEWTHDETN.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • P_FIXEDASSETVALUEWTHDETN.MANDT == TCURC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.GLOBALCURRENCY == TCURC.WAERS
Group Asset Subnumber
  • Group Asset Subnumber
  • Client
  • Group Asset
  • ?
  • P_FIXEDASSETVALUEWTHDETN.GROUPFIXEDASSET == ANLA.ANLN2
  • P_FIXEDASSETVALUEWTHDETN.MANDT == ANLA.MANDT
  • P_FIXEDASSETVALUEWTHDETN.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "BUKRS"] == ANLA.BUKRS
Joint Venture Cost Recovery Code
  • Client
  • ?
  • Joint Venture Cost Recovery Code
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T8JJ.MANDT
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "BUKRS"] == T8JJ.BUKRS
  • P_FIXEDASSETVALUEWTHDETN.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Target Ledger Group
  • Target Ledger Group
  • Client
  • P_FIXEDASSETVALUEWTHDETN.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • P_FIXEDASSETVALUEWTHDETN.MANDT == FAGL_TLDGRP.MANDT
Logical System P_FIXEDASSETVALUEWTHDETN.LOGICALSYSTEM == TBDLS.LOGSYS
Partner Fixed Asset
  • Client
  • ?
  • Partner Master Fixed Asset
  • Partner Fixed Asset
  • P_FIXEDASSETVALUEWTHDETN.MANDT == ANLA.MANDT
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_FIXEDASSETVALUEWTHDETN.PARTNERMASTERFIXEDASSET == ANLA.ANLN1
  • P_FIXEDASSETVALUEWTHDETN.PARTNERFIXEDASSET == ANLA.ANLN2
Plant
  • Client
  • Plant
  • P_FIXEDASSETVALUEWTHDETN.MANDT == T001W.MANDT
  • P_FIXEDASSETVALUEWTHDETN.PLANT == T001W.WERKS
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • P_FIXEDASSETVALUEWTHDETN.PROFITCENTER == CEPC.PRCTR
  • P_FIXEDASSETVALUEWTHDETN.MANDT == CEPC.MANDT
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_FIXEDASSETVALUEWTHDETN.[column in domain "DATBI"] == CEPC.DATBI
Reference Document Type P_FIXEDASSETVALUEWTHDETN.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_FIXEDASSETVALUEWTHDETN.MANDT == FAGL_SEGM.MANDT
  • P_FIXEDASSETVALUEWTHDETN.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type P_FIXEDASSETVALUEWTHDETN.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE