I_FixedAssetValueForToFsclPerd

Fixed Asset Values | view: IFASSETVALUEFP | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, ACDOCA, ACDOCP, T093, FAAC_KFCSET_SPEC, T001, TKA02, FINSC_LEDGER, T093B, FINS_TECH_LEDGER, FAAT_CMP, T093C, TACC_PRINCIPLE, ANLA, FAAT_MD, FAAT_MD_ROOT, GLOFAAASSETDATA, GLO_FAAT_MD, FAAT_MD_LD, TACC_TRGT_LDGR, FAAC_KFC_SPEC, FAAC_KFC_AMC_DET, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode Company Code
AssetDepreciationArea Asset Depreciation Area (Real or Derived)
MasterFixedAsset Fixed Asset
FixedAsset Asset Subnumber
AccountingDocument Journal Entry
TransactionSubitem Partial Document to be balanced to zero
Ledger Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType Subledger-Specific Line Item Type
AssetAcctTransClassfctn Transaction Type Category
AssetAccountingKeyFigureSet null
AssetAccountingKeyFigure FK Key Figure for Asset Accounting
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency null
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 null
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 null
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 null
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 null
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 null
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 null
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 null
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 null
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
DocumentDate Journal Entry Date
PostingDate Posting Date
AssetValueDate Asset Value Date
LastInventoryDate Last Inventory Date
AssetCapitalizationDate Asset Capitalization Date
AssetDeactivationDate Deactivation Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
PlannedValueIsInclusive Value Type for Asset Reporting & Aging Report 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
InventoryIsCounted Inventory Indicator Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AssetAccountingSortedKeyFigure Key Figure Box Number for Asset Accounting
CountryChartOfAccounts Alternative Chart of Accounts for Country/Region KTOPL
GLAccount General Ledger Account SAKNR
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
GroupMasterFixedAsset Group Asset ANLN1
GroupFixedAsset Group Asset Subnumber ANLN2
AccountingDocCreatedByUser User that created the journal entry
JointVentureCostRecoveryCode Joint Venture Cost Recovery Code JV_RECIND
CostCenter Cost Center KOSTL
Plant Plant WERKS
BusinessArea Business Area GSBER
PersonnelNumber Personnel Number PERNR
FinancialManagementArea Financial Management Area FIKRS
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
BudgetPeriod Budget Period FM_BUDGET_PERIOD
ProfitCenter Profit Center PRCTR
Segment Segment for Segmental Reporting FB_SEGMENT
FundsCenter Funds Management Center FISTL
AssetTransactionType Asset Transaction Type BWASL
AccountingDocumentType Journal Entry Type BLART
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentType Reference Document Type AWTYP
LogicalSystem Logical System LOGSYS
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
AssetSupplierName Name of asset supplier TEXT30
InvestmentOrder Investment Order AUFNR
Inventory Inventory Number INVNR_ANLA
AssetSerialNumber Serial number GERNR
FirstAcquisitionFiscalYear Fiscal Year in Which First Acquisition Was Posted GJAHR
FirstAcquisitionFiscalPeriod Period in Which First Acquisition Was Posted POPER
NationalClassification National Classification Code GLO_NATL_CLFN_CODE
TaxDepreciationGroup Tax Depreciation Group GLO_TAX_DEPR_GRP
PartnerMasterFixedAsset Partner Master Fixed Asset ANLN1
PartnerFixedAsset Partner Fixed Asset ANLN2
Master Data Relations Join Conditions
Accounting Principle
  • Accounting Principle
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.ACCOUNTINGPRINCIPLE == TACC_PRINCIPLE.ACC_PRINCIPLE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == TACC_PRINCIPLE.MANDT
Foreign Key: Key Figure Code
  • Key Figure for Asset Accounting
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FAAC_KFC.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.CHARTOFACCOUNTS == T004.KTOPL
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T004.MANDT
Chart of Depreciaton for Asset Valuation
  • Client
  • Chart of Depreciaton for Asset Valuation
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T096.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.CHARTOFDEPRECIATION == T096.AFAPL
Company Code Currency Role
  • Company Code Currency Role
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.COMPANYCODECURRENCYROLE == FINSC_CURTYPE.CURTYPE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.CONTROLLINGAREA == TKA01.KOKRS
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == TKA01.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.COUNTRY == T005.LAND1
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T005.MANDT
Financial Statement Version
  • Financial Statement Version
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FINANCIALSTATEMENTVARIANT == T011.VERSN
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T011.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FISCALYEARVARIANT == T009.PERIV
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T009.MANDT
Asset Super Number
  • Client
  • Asset Super Number
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T087U.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FIXEDASSETGROUP == T087U.ANLUE
Freely Defined Currency 1 Role (Currency Type)
  • Freely Defined Currency 1 Role (Currency Type)
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY1ROLE == FINSC_CURTYPE.CURTYPE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 2 Role (Currency Type)
  • Client
  • Freely Defined Currency 2 Role (Currency Type)
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY2ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 3 Role (Currency Type)
  • Freely Defined Currency 3 Role (Currency Type)
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY3ROLE == FINSC_CURTYPE.CURTYPE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 4 Role (Currency Type)
  • Freely Defined Currency 4 Role (Currency Type)
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY4ROLE == FINSC_CURTYPE.CURTYPE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 5 Role (Currency Type)
  • Client
  • Freely Defined Currency 5 Role (Currency Type)
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY5ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 6 Role (Currency Type)
  • Freely Defined Currency 6 Role (Currency Type)
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY6ROLE == FINSC_CURTYPE.CURTYPE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
Freely Defined Currency 7 Role (Currency Type)
  • Client
  • Freely Defined Currency 7 Role (Currency Type)
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY7ROLE == FINSC_CURTYPE.CURTYPE
Freely Defined Currency 8 Role (Currency Type)
  • Freely Defined Currency 8 Role (Currency Type)
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.FREEDEFINEDCURRENCY8ROLE == FINSC_CURTYPE.CURTYPE
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
Global Currency Role
  • Client
  • Global Currency Role
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FINSC_CURTYPE.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.GLOBALCURRENCYROLE == FINSC_CURTYPE.CURTYPE
Evaluation Group 1
  • Client
  • Evaluation group 1
  • ?
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T087.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.GROUP1ASSETEVALUATIONKEY == T087.ORD4X
  • I_FIXEDASSETVALUEFORTOFSCLPERD.[column in domain "ORDNR"] == T087.ORDNR
Evaluation Group 2
  • Client
  • ?
  • Evaluation Group 2
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T087.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSETVALUEFORTOFSCLPERD.GROUP2ASSETEVALUATIONKEY == T087.ORD4X
Evaluation Group 3
  • Client
  • ?
  • Evaluation Group 3
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T087.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSETVALUEFORTOFSCLPERD.GROUP3ASSETEVALUATIONKEY == T087.ORD4X
Evaluation group 4
  • Client
  • ?
  • Evaluation group 4
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T087.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSETVALUEFORTOFSCLPERD.GROUP4ASSETEVALUATIONKEY == T087.ORD4X
Guideline group
  • Client
  • Evaluation Group 5
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == T087G.MANDT
  • I_FIXEDASSETVALUEFORTOFSCLPERD.GROUP5ASSETEVALUATIONKEY == T087G.GDLGRP
Target Ledger Group
  • Target Ledger Group
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == FAGL_TLDGRP.MANDT
Account number of vendor (other key word)
  • Account number of vendor (other key word)
  • Client
  • I_FIXEDASSETVALUEFORTOFSCLPERD.SUPPLIER == LFA1.LIFNR
  • I_FIXEDASSETVALUEFORTOFSCLPERD.MANDT == LFA1.MANDT