C_FinStmntWthPrftCtrHierQuery

FinStatement in Profit Center Hierarchy | view: CFINSTMNTPCHIER | Extraction: Not supported | Component: Localization Financials Statements
Tables used: SCAL_TT_DATE, ACDOCA, T004, SKA1, FINSC_LEDGER_REP
Column Name Description
ProfitCenter FK Profit Center
FinancialStatementLeafItem Financial Statement Leaf
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
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
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == SKA1.MANDT
Business Area
  • Business Area
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.BUSINESSAREA == TGSB.GSBER
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.COMPANYCODE == T001.BUKRS
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == CSKS.MANDT
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.COSTCENTER == CSKS.KOSTL
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == T004.MANDT
Currency Key
  • Currency Key
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.CURRENCY == TCURC.WAERS
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == TCURC.MANDT
Functional Area
  • Client
  • Functional Area
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == TFKB.MANDT
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.GLACCOUNT == SKB1.SAKNR
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.COMPANYCODE == SKB1.BUKRS
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == SKB1.MANDT
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.PROFITCENTER == CEPC.PRCTR
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.SEGMENT == FAGL_SEGM.SEGMENT
  • C_FINSTMNTWTHPRFTCTRHIERQUERY.MANDT == FAGL_SEGM.MANDT