C_CN_GLAcctBalances

G/L Account Balances | view: CVCNGLABAL | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Ledger Fiscal Year
Ledger FK Ledger in General Ledger Accounting
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAcctLineDescription Line Description
FiscalPeriod Fiscal Period
GLAccount FK G/L Account
PostingDate Posting Date
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy null
💲 Company Code Currency (DisplayCurrency):
DebitAmountInDisplayCrcy Debit Amount in Company Code Currency
CreditAmountInDisplayCrcy null
AmountInDisplayCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ValueDate Accounting Document Entry Date
Column Name Description
AccountingDocumentCategory Document Status Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
Column Name Description Domain name
GLAccountInfo G/L Account Information: Identification and Name FIGLCN_GLACCOUNTINFO
AssignmentReference Assignment Reference ZUONR
ExchangeRate Character Field of Length 12 CHAR12
ReferenceDocument Reference document number AWREF
GLAcctBalDateSortSqnc Sequence Number by Day FIGLCN_DAYSEQNO
GLAcctBalPerdSortSqnc Sequence Number by Period FIGLCN_PERSEQNO
DocumentHeaderText Document Header Text TEXT25
GLAccountPeriod null
AuthorizationGroup Authorization Group BRGRU
DocumentItemText Item Text TEXT50
AlternativeReferenceDocument null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_CN_GLACCTBALANCES.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_CN_GLACCTBALANCES.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • C_CN_GLACCTBALANCES.BUSINESSAREA == TGSB.GSBER
  • C_CN_GLACCTBALANCES.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_CN_GLACCTBALANCES.MANDT == T004.MANDT
  • C_CN_GLACCTBALANCES.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_CN_GLACCTBALANCES.MANDT == T001.MANDT
  • C_CN_GLACCTBALANCES.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_CN_GLACCTBALANCES.MANDT == TKA01.MANDT
  • C_CN_GLACCTBALANCES.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Controlling Area
  • Cost Center
  • ?
  • C_CN_GLACCTBALANCES.MANDT == CSKS.MANDT
  • C_CN_GLACCTBALANCES.CONTROLLINGAREA == CSKS.KOKRS
  • C_CN_GLACCTBALANCES.COSTCENTER == CSKS.KOSTL
  • C_CN_GLACCTBALANCES.[column in domain "DATBI"] == CSKS.DATBI
Functional Area
  • Client
  • Functional Area
  • C_CN_GLACCTBALANCES.MANDT == TFKB.MANDT
  • C_CN_GLACCTBALANCES.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_CN_GLACCTBALANCES.MANDT == SKB1.MANDT
  • C_CN_GLACCTBALANCES.GLACCOUNT == SKB1.SAKNR
  • C_CN_GLACCTBALANCES.COMPANYCODE == SKB1.BUKRS
G/L Account Group
  • Chart of Accounts
  • Client
  • G/L Account Group
  • C_CN_GLACCTBALANCES.CHARTOFACCOUNTS == T077S.KTOPL
  • C_CN_GLACCTBALANCES.MANDT == T077S.MANDT
  • C_CN_GLACCTBALANCES.GLACCOUNTGROUP == T077S.KTOKS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • Client
  • Controlling Area
  • Profit Center
  • ?
  • C_CN_GLACCTBALANCES.MANDT == CEPC.MANDT
  • C_CN_GLACCTBALANCES.CONTROLLINGAREA == CEPC.KOKRS
  • C_CN_GLACCTBALANCES.PROFITCENTER == CEPC.PRCTR
  • C_CN_GLACCTBALANCES.[column in domain "DATBI"] == CEPC.DATBI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_CN_GLACCTBALANCES.MANDT == FAGL_SEGM.MANDT
  • C_CN_GLACCTBALANCES.SEGMENT == FAGL_SEGM.SEGMENT
Transaction Currency
  • Client
  • Transaction Currency
  • C_CN_GLACCTBALANCES.MANDT == TCURC.MANDT
  • C_CN_GLACCTBALANCES.TRANSACTIONCURRENCY == TCURC.WAERS