C_GLAccountInchartOfAccount

GL Accounts in Chart of Account | view: CGLACCINCOA | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: T004TFKBTFKBTT077ST077ZSKA1SKADSKA1T004T880T030USR21SKATT004
Column Name Description
ChartOfAccounts FK Chart of Accounts
GLAccount G/L Account Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
AccountIsBlockedForCreation Indicator: Account Is Blocked for Creation ? Show values
AccountIsBlockedForPosting Indicator: Is Account Blocked for Posting? Show values
AccountIsBlockedForPlanning Indicator: Account Blocked for Planning ? Show values
GLAccountType Type of a General Ledger Account Show values
GLAccountIsNotProdnRelevant G/L Account not used in production system Show values
Column Name Description Domain name
GLAccountName G/L Account Short Text TEXT20
GLAccountLongName G/L Account Long Text TEXT50
GLAccountExternal G/L Account Number, Significant Length CHAR10
CorporateGroupAccountExternal G/L Account Number CHAR10
CorporateGroupAccountLongName G/L Account Long Text TEXT50
ProfitLossAccountType P&L statement account type CHAR2
CompanyName Company name TEXT30
FunctionalAreaName Name of the Functional Area TEXT25
CreationDate null
CreatedByUser Name of Person who Created the Object USNAM
GLAccountTypeName Short Text for Fixed Values DDTEXT
AccountGroupName Account Group Name TEXT30
IsProfitLossAccount null
GLAccountDetermination null
CreatedByUserName User Description SUIDTECHDESC
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == T004.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.CHARTOFACCOUNTS == T004.KTOPL
Group Account Number
  • Group Account Number
  • Client
  • Group Chart of Accts
  • C_GLACCOUNTINCHARTOFACCOUNT.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == SKA1.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
Group Chart of Accts
  • Client
  • Group Chart of Accts
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == T004.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
Functional Area
  • Functional Area
  • Client
  • C_GLACCOUNTINCHARTOFACCOUNT.FUNCTIONALAREA == TFKB.FKBER
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == TFKB.MANDT
G/L Account Group
  • G/L Account Group
  • Client
  • Chart of Accounts
  • C_GLACCOUNTINCHARTOFACCOUNT.GLACCOUNTGROUP == T077S.KTOKS
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == T077S.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.CHARTOFACCOUNTS == T077S.KTOPL
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == T880.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.PARTNERCOMPANY == T880.RCOMP
G/L Account Number
  • G/L Account Number
  • Client
  • Chart of Accounts
  • C_GLACCOUNTINCHARTOFACCOUNT.RETAINEDEARNINGSGLACCOUNT == SKA1.SAKNR
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == SKA1.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.CHARTOFACCOUNTS == SKA1.KTOPL
Number of the Sample Account
  • Client
  • Chart of Accounts
  • Number of the Sample Account
  • C_GLACCOUNTINCHARTOFACCOUNT.MANDT == SKM1.MANDT
  • C_GLACCOUNTINCHARTOFACCOUNT.CHARTOFACCOUNTS == SKM1.KTOPL
  • C_GLACCOUNTINCHARTOFACCOUNT.SAMPLEGLACCOUNT == SKM1.MUSTR