C_GLAccountInCompanyCode

Gl accounts in company code | view: CGLACCTINCOCD | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: T004T001TKA02SKA1SKB1SKADUSR21SKATT004T001T005T007ST001T005T007AT050TT050T
Column Name Description
ChartOfAccounts FK Chart of Accounts
CompanyCode FK Company Code
GLAccount G/L Account Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ReconciliationAccountType Account is Reconciliation Account Show values
IsManagedExternally Indicator: account managed in external system Show values
IsAutomaticallyPosted Indicator: Is Account only Posted to Automatically? Show values
LineItemDisplayIsEnabled Indicator: Can Line Items Be Displayed by Account? Show values
SupplementIsAllowed Indicator: Supplement for Automatic Postings ? Show values
IsOpenItemManaged Indicator: Open Item Management? Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
TaxCodeIsRequired Indicator: Tax code is not a required field Show values
BalanceHasLocalCurrency Manage Balances in Local Currency Only (Indicator) Show values
IsCashFlowAccount Cash Receipt Account / Cash Disbursement Account Show values
AccountIsBlockedForPosting Indicator: Is Account Blocked for Posting? Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
Column Name Description Domain name
GLAccountLongName G/L Account Long Name CHAR50
GLAccountExternal G/L Account Number CHAR10
AuthorizationGroup Authorization Group BRGRU
LastInterestCalcRunDate null
CreationDate null
CreatedByUser Name of Person who Created the Object USNAM
PersonFullName User Description SUIDTECHDESC
ReconciliationAccountTypeName Short Text for Fixed Values DDTEXT
TaxCategory Tax Category in Account Master Record SMWSK
TaxCategoryName Tax Category Name TEXT70
InterestCalculationDate null
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AlternativeGLAccountExternal G/L Account Number CHAR10
CommitmentItem Commitment Item FIPOS
ValuationGroup Valuation Group CHAR10
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Accounting Clerk Abbreviation
  • Company Code
  • Client
  • C_GLACCOUNTINCOMPANYCODE.ACCOUNTINGCLERK == T001S.BUSAB
  • C_GLACCOUNTINCOMPANYCODE.COMPANYCODE == T001S.BUKRS
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T001S.MANDT
Key for sorting according to assignment numbers C_GLACCOUNTINCOMPANYCODE.ACCTGDOCITMDISPLAYSEQUENCERULE == TZUN.ZUAWA
Tolerance Group for G/L Accounts
  • Tolerance Group for G/L Accounts
  • Company Code
  • Client
  • C_GLACCOUNTINCOMPANYCODE.APARTOLERANCEGROUP == T043S.TOGRU
  • C_GLACCOUNTINCOMPANYCODE.COMPANYCODE == T043S.BUKRS
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T043S.MANDT
Planning Group
  • Client
  • Planning Group
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T035.MANDT
  • C_GLACCOUNTINCOMPANYCODE.CASHPLANNINGGROUP == T035.GRUPP
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T004.MANDT
  • C_GLACCOUNTINCOMPANYCODE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_GLACCOUNTINCOMPANYCODE.COMPANYCODE == T001.BUKRS
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T001.MANDT
Alternative Chart of Accounts
  • Client
  • Alternative Chart of Accounts
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T004.MANDT
  • C_GLACCOUNTINCOMPANYCODE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Account Currency
  • Client
  • Account Currency
  • C_GLACCOUNTINCOMPANYCODE.MANDT == TCURC.MANDT
  • C_GLACCOUNTINCOMPANYCODE.GLACCOUNTCURRENCY == TCURC.WAERS
Short Key for a House Bank
  • Company Code
  • Short Key for a House Bank
  • Client
  • C_GLACCOUNTINCOMPANYCODE.COMPANYCODE == T012.BUKRS
  • C_GLACCOUNTINCOMPANYCODE.HOUSEBANK == T012.HBKID
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T012.MANDT
ID for Account Details
  • Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • Client
  • C_GLACCOUNTINCOMPANYCODE.COMPANYCODE == T012K.BUKRS
  • C_GLACCOUNTINCOMPANYCODE.HOUSEBANK == T012K.HBKID
  • C_GLACCOUNTINCOMPANYCODE.HOUSEBANKACCOUNT == T012K.HKTID
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T012K.MANDT
Interest Indicator
  • Client
  • Interest Indicator
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T056.MANDT
  • C_GLACCOUNTINCOMPANYCODE.INTERESTCALCULATIONCODE == T056.VZSKZ
Recovery Indicator
  • Recovery Indicator
  • Company Code
  • Client
  • C_GLACCOUNTINCOMPANYCODE.JOINTVENTURERECOVERYCODE == T8JJ.RECID
  • C_GLACCOUNTINCOMPANYCODE.COMPANYCODE == T8JJ.BUKRS
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T8JJ.MANDT
Planning Level
  • Client
  • Planning Level
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T036.MANDT
  • C_GLACCOUNTINCOMPANYCODE.PLANNINGLEVEL == T036.EBENE
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • Client
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • Chart of Accounts
  • ?
  • C_GLACCOUNTINCOMPANYCODE.MANDT == T030S.MANDT
  • C_GLACCOUNTINCOMPANYCODE.EXCHRATEDIFFERENCESACCOUNTDETN == T030S.KDFSL
  • C_GLACCOUNTINCOMPANYCODE.CHARTOFACCOUNTS == T030S.KTOPL
  • C_GLACCOUNTINCOMPANYCODE.[column in domain "BWBER"] == T030S.CURTP