P_AssetHistorySheetCube4

P_AssetHistorySheetCube4 | view: PFASTAHSCUBE4 | 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, T093C, TACC_PRINCIPLE, TACC_TRGT_LDGR, FAAC_KFC_AMC_DET, FINSC_ACTVE_APPL, FINSC_LD_CMP, FAGL_TLDGRP_MAP
Column Name Description
CompanyCode FK Company Code
AssetDepreciationArea FK Asset Depreciation Area (Real or Derived)
MasterFixedAsset FK Fixed Asset
FixedAsset FK Asset Subnumber
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
SubLedgerAcctLineItemType FK Subledger-Specific Line Item Type
AssetAcctTransClassfctn FK Transaction Type Category
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
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
PostingDate Posting Date
AccountingDocumentCreationDate Journal Entry Creation Date
CreationTime Journal Entry Creation Time
Column Name Description
DebitCreditCode Debit/Credit Code Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
FinancialAccountType Financial Account Type Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingPrinciple Accounting Principle ACCOUNTING_PRINCIPLE
PersonnelNumber Personnel Number PERNR
GrantID Grant GM_GRANT_NBR
FunctionalCurrencyRole Functional Currency Role (Currency Type) FINS_CURTYPE
Master Data Relations Join Conditions
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • Client
  • P_ASSETHISTORYSHEETCUBE4.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_ASSETHISTORYSHEETCUBE4.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • P_ASSETHISTORYSHEETCUBE4.MANDT == SKA1.MANDT
Analytical Transaction Type Category
  • Analytical Transaction Type Category
  • Client
  • P_ASSETHISTORYSHEETCUBE4.ASSETACCTANLYTLTRANSCLASSFCTN == FAAC_KFC_AMC.ANLYTL_MOVCAT
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FAAC_KFC_AMC.MANDT
Transaction Type Category P_ASSETHISTORYSHEETCUBE4.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TABW.MANDT
  • P_ASSETHISTORYSHEETCUBE4.ASSETTRANSACTIONTYPE == TABW.BWASL
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T006.MANDT
  • P_ASSETHISTORYSHEETCUBE4.BASEUNIT == T006.MSEHI
Budget Period
  • Financial Management Area
  • Fund
  • Budget Period
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • P_ASSETHISTORYSHEETCUBE4.FUND == FMFUNDBPD.FINCODE
  • P_ASSETHISTORYSHEETCUBE4.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FMFUNDBPD.MANDT
Business Area
  • Business Area
  • Client
  • P_ASSETHISTORYSHEETCUBE4.BUSINESSAREA == TGSB.GSBER
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T004.MANDT
  • P_ASSETHISTORYSHEETCUBE4.CHARTOFACCOUNTS == T004.KTOPL
Chart of Depreciaton for Asset Valuation
  • Chart of Depreciaton for Asset Valuation
  • Client
  • P_ASSETHISTORYSHEETCUBE4.CHARTOFDEPRECIATION == T096.AFAPL
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T096.MANDT
Company Code
  • Company Code
  • Client
  • P_ASSETHISTORYSHEETCUBE4.COMPANYCODE == T001.BUKRS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_ASSETHISTORYSHEETCUBE4.COMPANYCODECURRENCY == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Company Code Currency Role
  • Company Code Currency Role
  • Client
Controlling Area
  • Client
  • Controlling Area
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TKA01.MANDT
  • P_ASSETHISTORYSHEETCUBE4.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • P_ASSETHISTORYSHEETCUBE4.[column in domain "DATBI"] == CSKS.DATBI
  • P_ASSETHISTORYSHEETCUBE4.MANDT == CSKS.MANDT
  • P_ASSETHISTORYSHEETCUBE4.CONTROLLINGAREA == CSKS.KOKRS
  • P_ASSETHISTORYSHEETCUBE4.COSTCENTER == CSKS.KOSTL
Country/Region Key
  • Client
  • Country/Region Key
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T005.MANDT
  • P_ASSETHISTORYSHEETCUBE4.COUNTRY == T005.LAND1
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_ASSETHISTORYSHEETCUBE4.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T004.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FM01.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FISCALYEARVARIANT == T009.PERIV
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • ?
  • Client
  • P_ASSETHISTORYSHEETCUBE4.MASTERFIXEDASSET == ANLA.ANLN1
  • P_ASSETHISTORYSHEETCUBE4.FIXEDASSET == ANLA.ANLN2
  • P_ASSETHISTORYSHEETCUBE4.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == ANLA.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Client
  • Freely Defined Currency 1 Role (Currency Type)
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 2 Role (Currency Type)
  • Freely Defined Currency 2 Role (Currency Type)
  • Client
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Freely Defined Currency 3 Role (Currency Type)
  • Freely Defined Currency 3 Role (Currency Type)
  • Client
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Freely Defined Currency 4 Role (Currency Type)
  • Freely Defined Currency 4 Role (Currency Type)
  • Client
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Freely Defined Currency 5 Role (Currency Type)
  • Freely Defined Currency 5 Role (Currency Type)
  • Client
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Freely Defined Currency 6 Role (Currency Type)
  • Freely Defined Currency 6 Role (Currency Type)
  • Client
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 7 Role (Currency Type)
  • Freely Defined Currency 7 Role (Currency Type)
  • Client
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Freely Defined Currency 8 Role (Currency Type)
  • Client
  • Freely Defined Currency 8 Role (Currency Type)
Functional Area
  • Client
  • Functional Area
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TFKB.MANDT
  • P_ASSETHISTORYSHEETCUBE4.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
  • P_ASSETHISTORYSHEETCUBE4.FUNCTIONALCURRENCY == TCURC.WAERS
Fund
  • Financial Management Area
  • Fund
  • Client
  • P_ASSETHISTORYSHEETCUBE4.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • P_ASSETHISTORYSHEETCUBE4.FUND == FMFINCODE.FINCODE
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FMFINCODE.MANDT
Funds Management Center
  • Financial Management Area
  • ?
  • Client
  • Funds Management Center
  • P_ASSETHISTORYSHEETCUBE4.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • P_ASSETHISTORYSHEETCUBE4.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FMFCTR.MANDT
  • P_ASSETHISTORYSHEETCUBE4.FUNDSCENTER == FMFCTR.FICTR
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • P_ASSETHISTORYSHEETCUBE4.COMPANYCODE == SKB1.BUKRS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == SKB1.MANDT
  • P_ASSETHISTORYSHEETCUBE4.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Global Currency
  • Client
  • P_ASSETHISTORYSHEETCUBE4.GLOBALCURRENCY == TCURC.WAERS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == TCURC.MANDT
Global Currency Role
  • Client
  • Global Currency Role
Group Asset Subnumber
  • Group Asset Subnumber
  • Group Asset
  • ?
  • Client
  • P_ASSETHISTORYSHEETCUBE4.GROUPFIXEDASSET == ANLA.ANLN2
  • P_ASSETHISTORYSHEETCUBE4.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • P_ASSETHISTORYSHEETCUBE4.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == ANLA.MANDT
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • P_ASSETHISTORYSHEETCUBE4.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_ASSETHISTORYSHEETCUBE4.[column in domain "BUKRS"] == T8JJ.BUKRS
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T8JJ.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Target Ledger Group
  • Client
  • Target Ledger Group
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FAGL_TLDGRP.MANDT
  • P_ASSETHISTORYSHEETCUBE4.LEDGERGROUP == FAGL_TLDGRP.LDGRP
Plant
  • Client
  • Plant
  • P_ASSETHISTORYSHEETCUBE4.MANDT == T001W.MANDT
  • P_ASSETHISTORYSHEETCUBE4.PLANT == T001W.WERKS
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • P_ASSETHISTORYSHEETCUBE4.[column in domain "DATBI"] == CEPC.DATBI
  • P_ASSETHISTORYSHEETCUBE4.PROFITCENTER == CEPC.PRCTR
  • P_ASSETHISTORYSHEETCUBE4.MANDT == CEPC.MANDT
  • P_ASSETHISTORYSHEETCUBE4.CONTROLLINGAREA == CEPC.KOKRS
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_ASSETHISTORYSHEETCUBE4.SEGMENT == FAGL_SEGM.SEGMENT
  • P_ASSETHISTORYSHEETCUBE4.MANDT == FAGL_SEGM.MANDT
Subledger-Specific Line Item Type P_ASSETHISTORYSHEETCUBE4.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE