I_FinancialStatementBalCube

Financial Statement Balance | view: IFISTMNTBALCUBE | TRAN | Extraction: Not supported | Component: Localization Financials Statements
Tables used: SCAL_TT_DATE, ACDOCA, T004, SKA1, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Currency Key (Currency):
PeriodBalanceAmount Balance Amount
PeriodBalAmtInDspCrcy Period Balance Amount
DebitAmtInDisplayCrcy Period Debit Balance
CreditAmtInDisplayCrcy Period Credit Balance
YearlyBalAmtInDspCrcy Year Opening Balance Amount
StartingBalAmtInDspCrcy Period Opening Balance
EndingBalAmtInDspCrcy Period Ending Balance
Column Name Description
Column Name Description
Column Name Description
NodeCategory Parent Category of Hierarchy Node Show values
SignIsInverted Change of Sign (+/-) Show values
AlternativeGLAccountIsUsed Display Alternative Accounts Show values
ZeroBalanceAccountIsDisplayed Accounts with Zero Balance are Displayed Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FinancialStatementLeafItem Financial Statement Leaf
FiscalPeriod Fiscal Period POPER
WBSElement WBS Element FIS_WBS_NO_CONV
ReportingPeriod Reporting period description FINSTMNT_REPORT_PERIOD
ExtensibilityScenarioID Scenario Id Type VCH_SCENARIO_ID
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
  • I_FINANCIALSTATEMENTBALCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_FINANCIALSTATEMENTBALCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == SKA1.MANDT
Business Area
  • Client
  • Business Area
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == TGSB.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == T004.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == T001.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == TKA01.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.CONTROLLINGAREA == TKA01.KOKRS
Group Account Number
  • Group Account Number
  • Group Chart of Accts
  • Client
  • I_FINANCIALSTATEMENTBALCUBE.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • I_FINANCIALSTATEMENTBALCUBE.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == SKA1.MANDT
Group Chart of Accts
  • Group Chart of Accts
  • Client
  • I_FINANCIALSTATEMENTBALCUBE.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == T004.MANDT
Cost Center
  • Cost Center
  • Client
  • ?
  • Controlling Area
  • I_FINANCIALSTATEMENTBALCUBE.COSTCENTER == CSKS.KOSTL
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == CSKS.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_FINANCIALSTATEMENTBALCUBE.CONTROLLINGAREA == CSKS.KOKRS
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_FINANCIALSTATEMENTBALCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == T004.MANDT
Currency Key
  • Client
  • Currency Key
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == TCURC.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.CURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == T009.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.FISCALYEARVARIANT == T009.PERIV
Functional Area
  • Client
  • Functional Area
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == TFKB.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == SKB1.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.GLACCOUNT == SKB1.SAKNR
  • I_FINANCIALSTATEMENTBALCUBE.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == CEPC.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINANCIALSTATEMENTBALCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINANCIALSTATEMENTBALCUBE.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_FINANCIALSTATEMENTBALCUBE.MANDT == FAGL_SEGM.MANDT
  • I_FINANCIALSTATEMENTBALCUBE.SEGMENT == FAGL_SEGM.SEGMENT