C_FinancialStatementBalQuery

Financial Statement | view: CFINSTMNTQUERY | Extraction: Not supported | Component: Localization Financials Statements
Column Name Description
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
AlternativeGLAccountIsUsed Display Alternative Accounts Show values
ZeroBalanceAccountIsDisplayed Accounts with Zero Balance are Displayed Show values
NodeCategory Parent Category of Hierarchy Node Show values
Column Name Description Domain name
FinancialStatementLeafItem Financial Statement Leaf FINS_FSLEAF
ExtensibilityScenarioID Scenario Id Type VCH_SCENARIO_ID
ReportingPeriod Reporting period description FINSTMNT_REPORT_PERIOD
WBSElement WBS Element FIS_WBS_NO_CONV
Master Data Relations Join Conditions
Alternative G/L Account Number In Company Code
  • Client
  • Alternative G/L Account Number In Company Code
  • ?
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == SKA1.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_FINANCIALSTATEMENTBALQUERY.[column in domain "KTOPL"] == SKA1.KTOPL
Business Area
  • Client
  • Business Area
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == TGSB.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == T004.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == T001.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == TKA01.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • Controlling Area
  • ?
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == CSKS.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.COSTCENTER == CSKS.KOSTL
  • C_FINANCIALSTATEMENTBALQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_FINANCIALSTATEMENTBALQUERY.[column in domain "DATBI"] == CSKS.DATBI
Currency Key
  • Client
  • Currency Key
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == TCURC.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.CURRENCY == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == TFKB.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_FINANCIALSTATEMENTBALQUERY.GLACCOUNT == SKB1.SAKNR
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == SKB1.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.COMPANYCODE == SKB1.BUKRS
Profit Center
  • Client
  • Controlling Area
  • ?
  • Profit Center
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == CEPC.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_FINANCIALSTATEMENTBALQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_FINANCIALSTATEMENTBALQUERY.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_FINANCIALSTATEMENTBALQUERY.MANDT == FAGL_SEGM.MANDT
  • C_FINANCIALSTATEMENTBALQUERY.SEGMENT == FAGL_SEGM.SEGMENT