I_FixedAssetAHSValueCube

Asset History Sheet - Cube | view: IASTAHSVALUECUBE | TRAN | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, PRTE, ACDOCA, ACDOCP, T093, FAAC_KFCSET_SPEC, FAAT_MD_VAL_TDD, FAAT_MD_VAL, T001, TKA02, FINSC_LEDGER, T093B, FINS_TECH_LEDGER, PRPS, T095, 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, TACC_TRGT_LDGR, FAAC_KFC_SPEC, FAAC_KFC_AMC_DET, FINSC_LD_CMP, FINSC_ACTVE_APPL, FAGL_TLDGRP_MAP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
CompanyCode Company Code
AssetDepreciationArea Asset Depreciation Area (Real or Derived)
MasterFixedAsset Fixed Asset
FixedAsset Asset Subnumber
Ledger Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType Subledger-Specific Line Item Type
AssetAcctTransClassfctn Transaction Type Category
AssetAccountingKeyFigure FK Key Figure for Asset Accounting
AssetAccountingKeyFigureSet null
AccountingDocument Journal Entry
TransactionSubitem Partial Document to be balanced to zero
DebitCreditCode Debit/Credit Code Show values
KeyFigureIsZeroBalance Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description
💲 Display Currency (DisplayCurrency):
AmountInDisplayCurrency Amount in Display Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
AssetCapitalizationDate Asset Capitalization Date
AssetDeactivationDate Deactivation Date
LastInventoryDate Last Inventory Date
DepreciationStartDate Depreciation Calculation Start Date
SpecialDeprStartDate Start date for special depreciation
Column Name Description
DebitCreditCode Debit/Credit Code Show values
KeyFigureIsZeroBalance Boolean Variable (X = True, - = False, Space = Unknown) Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
FinancialAccountType Financial Account Type Show values
InventoryIsCounted Inventory Indicator 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
AssetAccountingSortedKeyFigure Key Figure Box Number for Asset Accounting
GLAccount General Ledger Account SAKNR
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
GroupMasterFixedAsset Group Asset ANLN1
GroupFixedAsset Group Asset Subnumber ANLN2
JointVentureCostRecoveryCode Joint Venture Cost Recovery Code JV_RECIND
ChartOfDepreciation Chart of Depreciaton for Asset Valuation AFAPL
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
CountryChartOfAccounts Alternative Chart of Accounts for Country/Region KTOPL
CurrencyRole null
FirstAcquisitionFiscalYear Fiscal Year in Which First Acquisition Was Posted GJAHR
FirstAcquisitionFiscalPeriod Period in Which First Acquisition Was Posted POPER
AssetSupplierName Name of asset supplier TEXT30
InvestmentOrder Investment Order AUFNR
Inventory Inventory Number INVNR_ANLA
AssetSerialNumber Serial number GERNR
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
AssetGrant Grant of a Fixed Asset GM_GRANT_NBR
AssetCostCtrActivityType Asset Activity Type LSTAR
RealEstateObject Internal Key for Real Estate Object IMKEY
AssetFundsCenter Asset Funds Center FISTL
Room Room CHAR8
VehicleLicensePlateNumber License Plate No. of Vehicle AM_KFZKZ
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
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Master Data Relations Join Conditions
Accounting Principle
  • Client
  • Accounting Principle
Bal. Sheet Account: Acquisition and Production Costs
  • Client
  • Bal. Sheet Account: Acquisition and Production Costs
  • Chart of Accounts
  • I_FIXEDASSETAHSVALUECUBE.MANDT == SKA1.MANDT
  • I_FIXEDASSETAHSVALUECUBE.ACQNPRODNCOSTGLACCOUNT == SKA1.SAKNR
  • I_FIXEDASSETAHSVALUECUBE.CHARTOFACCOUNTS == SKA1.KTOPL
Foreign Key: Key Figure Code
  • Key Figure for Asset Accounting
  • Client
  • I_FIXEDASSETAHSVALUECUBE.ASSETACCOUNTINGKEYFIGURE == FAAC_KFC.KEY_FIGURE_CODE
  • I_FIXEDASSETAHSVALUECUBE.MANDT == FAAC_KFC.MANDT
Asset Business Area
  • Asset Business Area
  • Client
  • I_FIXEDASSETAHSVALUECUBE.ASSETBUSINESSAREA == TGSB.GSBER
  • I_FIXEDASSETAHSVALUECUBE.MANDT == TGSB.MANDT
Asset location
  • Client
  • Asset Plant
  • Asset location
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T499S.MANDT
  • I_FIXEDASSETAHSVALUECUBE.ASSETPLANT == T499S.WERKS
  • I_FIXEDASSETAHSVALUECUBE.ASSETLOCATION == T499S.STAND
Asset Plant
  • Client
  • Asset Plant
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T001W.MANDT
  • I_FIXEDASSETAHSVALUECUBE.ASSETPLANT == T001W.WERKS
Segment
  • Client
  • Segment for Segmental Reporting
  • I_FIXEDASSETAHSVALUECUBE.MANDT == FAGL_SEGM.MANDT
  • I_FIXEDASSETAHSVALUECUBE.ASSETSEGMENT == FAGL_SEGM.SEGMENT
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T004.MANDT
  • I_FIXEDASSETAHSVALUECUBE.CHARTOFACCOUNTS == T004.KTOPL
Controlling Area
  • Client
  • Controlling Area
  • I_FIXEDASSETAHSVALUECUBE.MANDT == TKA01.MANDT
  • I_FIXEDASSETAHSVALUECUBE.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T005.MANDT
  • I_FIXEDASSETAHSVALUECUBE.COUNTRY == T005.LAND1
Help for depreciation keys
  • Client
  • ?
  • Depreciation key
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T090NA.MANDT
  • I_FIXEDASSETAHSVALUECUBE.[column in domain "AFAPL"] == T090NA.AFAPL
  • I_FIXEDASSETAHSVALUECUBE.DEPRECIATIONKEY == T090NA.AFASL
Financial Statement Version
  • Client
  • Financial Statement Version
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T011.MANDT
  • I_FIXEDASSETAHSVALUECUBE.FINANCIALSTATEMENTVARIANT == T011.VERSN
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T009.MANDT
  • I_FIXEDASSETAHSVALUECUBE.FISCALYEARVARIANT == T009.PERIV
Asset Super Number
  • Asset Super Number
  • Client
  • I_FIXEDASSETAHSVALUECUBE.FIXEDASSETGROUP == T087U.ANLUE
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T087U.MANDT
Evaluation Group 1
  • Client
  • ?
  • Evaluation group 1
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T087.MANDT
  • I_FIXEDASSETAHSVALUECUBE.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSETAHSVALUECUBE.GROUP1ASSETEVALUATIONKEY == T087.ORD4X
Evaluation Group 2
  • Client
  • Evaluation Group 2
  • ?
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T087.MANDT
  • I_FIXEDASSETAHSVALUECUBE.GROUP2ASSETEVALUATIONKEY == T087.ORD4X
  • I_FIXEDASSETAHSVALUECUBE.[column in domain "ORDNR"] == T087.ORDNR
Evaluation Group 3
  • Client
  • ?
  • Evaluation Group 3
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T087.MANDT
  • I_FIXEDASSETAHSVALUECUBE.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSETAHSVALUECUBE.GROUP3ASSETEVALUATIONKEY == T087.ORD4X
Evaluation group 4
  • Client
  • ?
  • Evaluation group 4
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T087.MANDT
  • I_FIXEDASSETAHSVALUECUBE.[column in domain "ORDNR"] == T087.ORDNR
  • I_FIXEDASSETAHSVALUECUBE.GROUP4ASSETEVALUATIONKEY == T087.ORD4X
Guideline group
  • Client
  • Evaluation Group 5
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T087G.MANDT
  • I_FIXEDASSETAHSVALUECUBE.GROUP5ASSETEVALUATIONKEY == T087G.GDLGRP
Investment Support Key
  • Investment Support Key
  • Client
  • ?
  • I_FIXEDASSETAHSVALUECUBE.INVESTMENTSUPPORTMEASURE == T085.INVSL
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T085.MANDT
  • I_FIXEDASSETAHSVALUECUBE.[column in domain "AFAPL"] == T085.AFAPL
Target Ledger Group
  • Client
  • Target Ledger Group
  • I_FIXEDASSETAHSVALUECUBE.MANDT == FAGL_TLDGRP.MANDT
  • I_FIXEDASSETAHSVALUECUBE.LEDGERGROUP == FAGL_TLDGRP.LDGRP
Year-dependent index series
  • Client
  • Index series for replacement values
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T094A.MANDT
  • I_FIXEDASSETAHSVALUECUBE.REPLACEMENTVALUEINDEXSERS == T094A.WBIND
Age-dependent index series
  • Client
  • Age-Dependent Index Series
  • I_FIXEDASSETAHSVALUECUBE.MANDT == T094A.MANDT
  • I_FIXEDASSETAHSVALUECUBE.RPLCMTVALUEAGINGINDEXSERS == T094A.WBIND