C_ChartOfAccountsListItem

chart of accounts list item | view: CGLCOALIST | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Column Name Description
ChartOfAccounts FK Chart of Accounts
GLAccount G/L Account Number
GLAcctOriginalRecordIsUsed Is Show Old Value Show values
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
GLAcctOriginalRecordIsUsed Is Show Old Value Show values
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
GLAccountIsNotProdnRelevant G/L Account not used in production system Show values
GLAccountType Type of a General Ledger Account Show values
IsProfitLossAccount Indicator: Account is a balance sheet account? Show values
DraftIsProcessedByMe Draft In Process By Me Show values
HasDraftEntity Draft - Indicator - Has draft document Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBdgtAcctIsPostgAllowed Posting to Budget Account Allowed Show values
PubSecBdgtAcctIsBdgtAllowed Budgeting Allowed for Budget Account Show values
PubSecBdgtAcctIsCarryFwd Use Budget Account as Carryforward Account Show values
Column Name Description Domain name
GLAccountName null
GLAccountLongName null
GLAccountExternal G/L Account Number CHAR10
CorporateGroupAccountExternal G/L Account Number CHAR10
ProfitLossAccountType P&L statement account type CHAR2
RetainedEarningsGLAccountName G/L Account Short Text TEXT20
FunctionalAreaName Name of the Functional Area TEXT25
CreatedByUser Name of Person who Created the Object USNAM
GLAccountTypeName Short Text for Fixed Values DDTEXT
GLAccountSubtypeName Long Text TEXT40
BankReconciliationAccountName null
AccountGroupName Account Group Name TEXT30
CreatedByUserName User Description SUIDTECHDESC
InProcessByUser Draft In Process By UNAME
InProcessByUserDescription Draft In Process By (Description) SDRAFT_USER_DESCRIPTION
Language null
ActiveDocumentETag Character field, length 32 CHAR32
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Bank Reconciliation Account
  • Bank Reconciliation Account
  • Chart of Accounts
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.BANKRECONCILIATIONACCOUNT == SKA1.SAKNR
  • C_CHARTOFACCOUNTSLISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == SKA1.MANDT
Cash Origin Account
  • ?
  • Client
  • Cash Origin Account
  • C_CHARTOFACCOUNTSLISTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == SKA1.MANDT
  • C_CHARTOFACCOUNTSLISTITEM.CASHLEDGERACCOUNT == SKA1.SAKNR
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.CHARTOFACCOUNTS == T004.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == T004.MANDT
Group Account Number
  • Group Chart of Accts
  • Group Account Number
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == SKA1.MANDT
Group Chart of Accts
  • Group Chart of Accts
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == T004.MANDT
Functional Area
  • Functional Area
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.FUNCTIONALAREA == TFKB.FKBER
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == TFKB.MANDT
G/L Account Group
  • G/L Account Group
  • Chart of Accounts
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.GLACCOUNTGROUP == T077S.KTOKS
  • C_CHARTOFACCOUNTSLISTITEM.CHARTOFACCOUNTS == T077S.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == T077S.MANDT
Subtype of a GL Account
  • Subtype of a GL Account
  • Type of a General Ledger Account
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.PARTNERCOMPANY == T880.RCOMP
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == T880.MANDT
Carry Forward Budget Account To Account
  • ?
  • Client
  • Carry Forward Budget Account To Account
  • C_CHARTOFACCOUNTSLISTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == SKA1.MANDT
  • C_CHARTOFACCOUNTSLISTITEM.PUBSECBDGTACCTCARRYFWDTO == SKA1.SAKNR
Budget Consumption Type
  • Client
  • Budget Consumption Type
Number of the Sample Account
  • Number of the Sample Account
  • Chart of Accounts
  • Client
  • C_CHARTOFACCOUNTSLISTITEM.SAMPLEGLACCOUNT == SKM1.MUSTR
  • C_CHARTOFACCOUNTSLISTITEM.CHARTOFACCOUNTS == SKM1.KTOPL
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == SKM1.MANDT
Sponsored Class
  • Client
  • Sponsored Class
  • C_CHARTOFACCOUNTSLISTITEM.MANDT == GMSPCLASS.CLIENT
  • C_CHARTOFACCOUNTSLISTITEM.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS