C_CN_GLAcctBalanceSumQuery

G/L Account Balances | view: CVCNGLABALSUM | Extraction: Not supported | Component: Financials China
Column Name Description
Column Name Description
💲 Company Code Currency (DisplayCurrency):
StartingBalAmtInDspCrcy Starting Balance Amount In Company Code Currency
DebitAmountInDisplayCrcy Debit Balance in Company Code Currency
CreditAmountInDisplayCrcy Credit Balance in Company Code Currency
PeriodBalAmtInDspCrcy Balance Amount in Company Code Currency
AmountInDisplayCurrency Balance Amount in Company Code Currency
EndingBalAmtInDspCrcy Ending Balance in Company Code Currency
IntmdEndingBalAmtInDisplayCrcy null
GLAcctDebitAmountInDisplayCrcy Debit Amount in Company Code Currency
GLAcctCreditAmtInDisplayCrcy Credit Amount in Company Code Currency
Column Name Description
Column Name Description
Column Name Description
GLAccountTransactionType G/L Account Transaction Type Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
Column Name Description Domain name
Ledger null
CompanyCode null
FiscalPeriod Fiscal Period POPER
FiscalYear null
GLAcctLineDescription Line Description CHAR20
GLAccountInfo G/L Account Information: Identification and Name FIGLCN_GLACCOUNTINFO
ProfitCenterGroup Set Name SETNAME
CreditDebitDirection Direction of Debit/Credit
AlternativeGLAccount Alternative G/L Account Number In Company Code
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.BUSINESSAREA == TGSB.GSBER
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == T004.MANDT
Functional Area
  • Functional Area
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.FUNCTIONALAREA == TFKB.FKBER
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == TFKB.MANDT
G/L Account
  • ?
  • G/L Account
  • Hierarchy ID
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_CN_GLACCTBALANCESUMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_CN_GLACCTBALANCESUMQUERY.GLACCOUNTHIERARCHY == SKB1.SAKNR
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == SKB1.MANDT
G/L Account Group
  • Chart of Accounts
  • G/L Account Group
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.CHARTOFACCOUNTS == T077S.KTOPL
  • C_CN_GLACCTBALANCESUMQUERY.GLACCOUNTGROUP == T077S.KTOKS
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == T077S.MANDT
Hierarchy ID
  • ?
  • G/L Account
  • Hierarchy ID
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_CN_GLACCTBALANCESUMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_CN_GLACCTBALANCESUMQUERY.GLACCOUNTHIERARCHY == SKB1.SAKNR
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == SKB1.MANDT
Profit Center
  • ?
  • Profit Center
  • ?
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_CN_GLACCTBALANCESUMQUERY.PROFITCENTER == CEPC.PRCTR
  • C_CN_GLACCTBALANCESUMQUERY.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_CN_GLACCTBALANCESUMQUERY.SEGMENT == FAGL_SEGM.SEGMENT
  • C_CN_GLACCTBALANCESUMQUERY.MANDT == FAGL_SEGM.MANDT