I_FinancialStatementCube

Virtual Financial Statement Cube | view: IFIFINSTMTCUBE | TRAN | Extraction: Full only | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, T004, SKA1, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Currency Key (Currency):
PeriodBalanceAmount Period Balance
ComparisonPeriodBalanceAmount Comparison Period Balance
Column Name Description
Column Name Description
GLAccountHierarchyKeyDate Key Date of the GLAccount Hierarchy
Column Name Description
AlternativeGLAccountIsUsed Display Alternative Accounts Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FinancialStatementLeafItem Financial Statement Leaf
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_FINANCIALSTATEMENTCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_FINANCIALSTATEMENTCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_FINANCIALSTATEMENTCUBE.MANDT == SKA1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_FINANCIALSTATEMENTCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_FINANCIALSTATEMENTCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_FINANCIALSTATEMENTCUBE.COMPANYCODE == T001.BUKRS
  • I_FINANCIALSTATEMENTCUBE.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_FINANCIALSTATEMENTCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_FINANCIALSTATEMENTCUBE.MANDT == TKA01.MANDT
Group Account Number
  • Group Account Number
  • Client
  • Group Chart of Accts
  • I_FINANCIALSTATEMENTCUBE.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • I_FINANCIALSTATEMENTCUBE.MANDT == SKA1.MANDT
  • I_FINANCIALSTATEMENTCUBE.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
Group Chart of Accts
  • Client
  • Group Chart of Accts
  • I_FINANCIALSTATEMENTCUBE.MANDT == T004.MANDT
  • I_FINANCIALSTATEMENTCUBE.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_FINANCIALSTATEMENTCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_FINANCIALSTATEMENTCUBE.MANDT == T004.MANDT
Currency Key
  • Currency Key
  • Client
  • I_FINANCIALSTATEMENTCUBE.CURRENCY == TCURC.WAERS
  • I_FINANCIALSTATEMENTCUBE.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_FINANCIALSTATEMENTCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_FINANCIALSTATEMENTCUBE.MANDT == T009.MANDT
Functional Area
  • Functional Area
  • Client
  • I_FINANCIALSTATEMENTCUBE.FUNCTIONALAREA == TFKB.FKBER
  • I_FINANCIALSTATEMENTCUBE.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_FINANCIALSTATEMENTCUBE.GLACCOUNT == SKB1.SAKNR
  • I_FINANCIALSTATEMENTCUBE.COMPANYCODE == SKB1.BUKRS
  • I_FINANCIALSTATEMENTCUBE.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • I_FINANCIALSTATEMENTCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINANCIALSTATEMENTCUBE.PROFITCENTER == CEPC.PRCTR
  • I_FINANCIALSTATEMENTCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINANCIALSTATEMENTCUBE.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_FINANCIALSTATEMENTCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_FINANCIALSTATEMENTCUBE.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger