C_FixedAssetHistorySheet

Asset History Sheet | view: CFASSETHISTSHEET | Extraction: Not supported | Component: Information System
Tables used: FAAT_PLAN_VALUES, FAAT_DOC_IT, PRTE, ACDOCA, ACDOCP, FAAT_PLAN_VALUES, ANLH, TACC_PRINCIPLE, TACC_PRINCIPLET, T093, FAAC_KFCSET_SPEC, FAAT_MD_VAL_TDD, TABW, TABWT, FAAT_MD_VAL, FMBUDGETPD, FMBUDGETPDT, TGSB, TGSBT, T004, T004T, T001, TKA02, TKA01, CSKS, CSKS, CSKT, T005, T005T, T090NA, T090NAT, FM01, FM01T, T011, T011T, GLOFAANCLCODE, GLOFAANCLCODET, TFKB, TFKBT, FMFINCODE, FMFINT, SKA1, T085, T085S, T002, FINSC_LEDGER, FAGL_TLDGRP, FAGL_TLDGRPT, FINSC_LEDGER_T, FAAI_MOVCAT, FAAI_MOVCATT, T001W, CEPC, CEPC, CEPCT, T093B, T000, FAGL_SEGM, FAGL_SEGMT, FINSTS_SLALITTY, FINSTS_SLALITTYT, GLOFAATAXDEPGRP, GLOFAATAXDEPGRPT, FINS_TECH_LEDGER, PRPS, FAAC_ACCTDET0, T095A, FAAC_ACCTDET0_T, T095T, T001, T095, ANKA, FAAC_ACLS0, ANKT, FAAC_ACLS0_T, FAAT_CMP, T093C, FAAT_CMP_DA, FAAT_MD_VAL_TDD, FAAT_MD_VAL_YDDA, T093C, TACC_PRINCIPLE, FAAC_CMP_DA0_T, T093, T093C, T093T, FAAC_CMP_DA0, T093, T093C, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, ANLZ, FAAT_MD_TDD, TKA02, ANLA, GLOFAAASSETDATA, GLO_FAAT_MD, T001, ANLB, ANLBZA, ANLA, FAAT_MD_LD, FINSC_LEDGER, SKAT, T004, FAAT_MD, FAAT_MD_ROOT, TACC_TRGT_LDGR, FAAC_KFC_SPEC, FAAC_KFC_AMC_DET, FINSC_LD_CMP, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP, FAGL_TLDGRP_MAP, FAGL_TLDGRP_MAP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Display Currency (DisplayCurrency):
AmountInDisplayCurrency Balance Amount
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
FinancialAccountType Financial Account Type Show values
InventoryIsCounted Inventory Indicator Show values
PlannedUsefulLifeInPeriods Planned Useful Life in Periods Show values
Column Name Description Domain name
AssetAccountDeterminationDesc Name of Account Determination TEXT50
AssetClassName Short Text for Asset Class Name TEXT20
ChartOfAccountsName Chart of Accounts Description TEXT50
AcqnProdnCostGLAccountName G/L Account Short Text TEXT20
AssetAccountingKeyFigure Key Figure Box Number for Asset Accounting
CompanyCode Company Code BUKRS
CompanyCodeName Name of Company Code or Company TEXT25
LedgerGroup Target Ledger Group FAGL_LDGRP
LedgerGroupName Text Field TEXT50
Ledger Ledger in General Ledger Accounting FINS_LEDGER
LedgerName Ledger Name TEXT30
AssetDepreciationArea Asset Depreciation Area (Real or Derived) AFABE
AssetDepreciationAreaName Name of Depreciation Area TEXT50
ChartOfDepreciation Chart of Depreciaton for Asset Valuation AFAPL
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
FinancialStatementVariantName Financial Statement Version Name TEXT50
ControllingAreaName Controlling Area Name TEXT25
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
Segment Segment for Segmental Reporting FB_SEGMENT
SegmentName Segment Name TEXT50
FundsCenter Funds Management Center FISTL
BusinessArea Business Area GSBER
BusinessAreaName Business Area Description TEXT30
MasterFixedAsset Fixed Asset ANLN1
MasterFixedAssetDescription Asset Main Number Text TEXT50
FixedAsset Asset Subnumber ANLN2
FixedAssetDescription Asset Description TEXT50
GroupMasterFixedAsset Group Asset ANLN1
GroupFixedAsset Group Asset Subnumber ANLN2
PersonnelNumber Personnel Number PERNR
FinancialManagementArea Financial Management Area FIKRS
FinancialManagementAreaName Name of FM Area TEXT25
Fund Fund BP_GEBER
FundName Fund Name TEXT20
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
FunctionalAreaName Name of the Functional Area TEXT25
BudgetPeriod Budget Period FM_BUDGET_PERIOD
BudgetPeriodName Budget Period Name NAME
SubLedgerAcctLineItemType Subledger-Specific Line Item Type SLALITTYPE
SubLedgerAcctLineItemTypeName Subledger-Specific Line Item Type Text TEXT70
AssetTransactionType Asset Transaction Type BWASL
AssetTransactionTypeName Asset Transaction Type Name TEXT50
AssetAcctTransClassfctn Transaction Type Category FAA_MOVCAT
AssetAcctTransClassfctnName Transaction Type Category Text TEXT50
FinancialAccountTypeName Financial Account Type Name DDTEXT
JointVentureCostRecoveryCode Joint Venture Cost Recovery Code JV_RECIND
AccountingPrincipleName Name of Accounting Principle TEXT70
CountryChartOfAccounts Alternative Chart of Accounts for Country/Region KTOPL
CountryChartOfAccountsName Chart of Accounts Description TEXT50
GLAccount General Ledger Account SAKNR
GLAccountName G/L Account Short Text TEXT20
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
AlternativeGLAccountName G/L Account Short Text TEXT20
AssetBusinessAreaName Business Area Description TEXT30
AssetPlantName Plant Name TEXT30
AssetCostCenter Asset Cost Center KOSTL
AssetCostCenterName Cost Center Name TEXT20
AssetProfitCenter Asset Profit Center PRCTR
AssetProfitCenterName Description of Profit Center TEXT20
AssetSegmentName Segment Name TEXT50
AssetBudgetPeriod Budget Period of a Fixed Asset FM_BUDGET_PERIOD
AssetGrant Grant of a Fixed Asset GM_GRANT_NBR
AssetFund Fund of Fixed Asset Master BP_GEBER
RealEstateObject Internal Key for Real Estate Object IMKEY
AssetFundsCenter Asset Funds Center FISTL
AssetCostCtrActivityType Asset Activity Type LSTAR
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
InvestmentSupportMeasureName Investment Support Measure TEXT50
DepreciationKeyName Depreciation Key Name TEXT50
PlannedUsefulLifeInYears Planned Useful Life in Years JARAF
CountryName Country/Region Name TEXT50
NationalClassification National Classification Code GLO_NATL_CLFN_CODE
NationalClassificationDesc National Classification Code Description TEXT50
TaxDepreciationGroup Tax Depreciation Group GLO_TAX_DEPR_GRP
TaxDepreciationGroupDesc Tax Depreciation Group Description TEXT30
AccountingDocument Journal Entry BELNR
Room Room CHAR8
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Master Data Relations Join Conditions
Accounting Principle
  • Accounting Principle
  • Client
Bal. Sheet Account: Acquisition and Production Costs
  • Bal. Sheet Account: Acquisition and Production Costs
  • Client
  • Chart of Accounts
  • C_FIXEDASSETHISTORYSHEET.ACQNPRODNCOSTGLACCOUNT == SKA1.SAKNR
  • C_FIXEDASSETHISTORYSHEET.MANDT == SKA1.MANDT
  • C_FIXEDASSETHISTORYSHEET.CHARTOFACCOUNTS == SKA1.KTOPL
Asset Business Area
  • Asset Business Area
  • Client
  • C_FIXEDASSETHISTORYSHEET.ASSETBUSINESSAREA == TGSB.GSBER
  • C_FIXEDASSETHISTORYSHEET.MANDT == TGSB.MANDT
Asset location
  • Client
  • Asset Plant
  • Asset location
  • C_FIXEDASSETHISTORYSHEET.MANDT == T499S.MANDT
  • C_FIXEDASSETHISTORYSHEET.ASSETPLANT == T499S.WERKS
  • C_FIXEDASSETHISTORYSHEET.ASSETLOCATION == T499S.STAND
Asset Plant
  • Client
  • Asset Plant
  • C_FIXEDASSETHISTORYSHEET.MANDT == T001W.MANDT
  • C_FIXEDASSETHISTORYSHEET.ASSETPLANT == T001W.WERKS
Segment
  • Segment for Segmental Reporting
  • Client
  • C_FIXEDASSETHISTORYSHEET.ASSETSEGMENT == FAGL_SEGM.SEGMENT
  • C_FIXEDASSETHISTORYSHEET.MANDT == FAGL_SEGM.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_FIXEDASSETHISTORYSHEET.MANDT == T004.MANDT
  • C_FIXEDASSETHISTORYSHEET.CHARTOFACCOUNTS == T004.KTOPL
Controlling Area
  • Client
  • Controlling Area
  • C_FIXEDASSETHISTORYSHEET.MANDT == TKA01.MANDT
  • C_FIXEDASSETHISTORYSHEET.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_FIXEDASSETHISTORYSHEET.COUNTRY == T005.LAND1
  • C_FIXEDASSETHISTORYSHEET.MANDT == T005.MANDT
Help for depreciation keys
  • Client
  • ?
  • Depreciation key
  • C_FIXEDASSETHISTORYSHEET.MANDT == T090NA.MANDT
  • C_FIXEDASSETHISTORYSHEET.[column in domain "AFAPL"] == T090NA.AFAPL
  • C_FIXEDASSETHISTORYSHEET.DEPRECIATIONKEY == T090NA.AFASL
Financial Statement Version
  • Financial Statement Version
  • Client
  • C_FIXEDASSETHISTORYSHEET.FINANCIALSTATEMENTVARIANT == T011.VERSN
  • C_FIXEDASSETHISTORYSHEET.MANDT == T011.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_FIXEDASSETHISTORYSHEET.MANDT == T009.MANDT
  • C_FIXEDASSETHISTORYSHEET.FISCALYEARVARIANT == T009.PERIV
Asset Super Number
  • Client
  • Asset Super Number
  • C_FIXEDASSETHISTORYSHEET.MANDT == T087U.MANDT
  • C_FIXEDASSETHISTORYSHEET.FIXEDASSETGROUP == T087U.ANLUE
Evaluation Group 1
  • ?
  • Client
  • Evaluation group 1
  • C_FIXEDASSETHISTORYSHEET.[column in domain "ORDNR"] == T087.ORDNR
  • C_FIXEDASSETHISTORYSHEET.MANDT == T087.MANDT
  • C_FIXEDASSETHISTORYSHEET.GROUP1ASSETEVALUATIONKEY == T087.ORD4X
Evaluation Group 2
  • ?
  • Client
  • Evaluation Group 2
  • C_FIXEDASSETHISTORYSHEET.[column in domain "ORDNR"] == T087.ORDNR
  • C_FIXEDASSETHISTORYSHEET.MANDT == T087.MANDT
  • C_FIXEDASSETHISTORYSHEET.GROUP2ASSETEVALUATIONKEY == T087.ORD4X
Evaluation Group 3
  • ?
  • Client
  • Evaluation Group 3
  • C_FIXEDASSETHISTORYSHEET.[column in domain "ORDNR"] == T087.ORDNR
  • C_FIXEDASSETHISTORYSHEET.MANDT == T087.MANDT
  • C_FIXEDASSETHISTORYSHEET.GROUP3ASSETEVALUATIONKEY == T087.ORD4X
Evaluation group 4
  • ?
  • Evaluation group 4
  • Client
  • C_FIXEDASSETHISTORYSHEET.[column in domain "ORDNR"] == T087.ORDNR
  • C_FIXEDASSETHISTORYSHEET.GROUP4ASSETEVALUATIONKEY == T087.ORD4X
  • C_FIXEDASSETHISTORYSHEET.MANDT == T087.MANDT
Guideline group
  • Evaluation Group 5
  • Client
  • C_FIXEDASSETHISTORYSHEET.GROUP5ASSETEVALUATIONKEY == T087G.GDLGRP
  • C_FIXEDASSETHISTORYSHEET.MANDT == T087G.MANDT
Investment Support Key
  • Investment Support Key
  • Client
  • ?
  • C_FIXEDASSETHISTORYSHEET.INVESTMENTSUPPORTMEASURE == T085.INVSL
  • C_FIXEDASSETHISTORYSHEET.MANDT == T085.MANDT
  • C_FIXEDASSETHISTORYSHEET.[column in domain "AFAPL"] == T085.AFAPL