C_GLAcctInCoCdListItem

company code list item | view: CGLACOCDLI | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SDRAFT_ADMIN, TZUN, TZUNT, T004, T001, TKA02, T005, T005T, TCURC, TCURX, TCURT, USR21, T004F, T004G, SKA1, SKB1, T043S, T043ST, SKA1_DRAFT_20, SKAD, J_1AINFSKS, J_1AINFSKT, T056, T056X, T8JJ, T8JJT, GLE_MCA_TMCAKEY, GLE_MCA_TMCAKEYT, T036, T036T, USR21, SKAT, T004, SKAT, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, T012K, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, FCLM_BAM_AMD_T, T001, T005, T007S, T001, T005, T007A, T050T, T050T
Column Name Description
ChartOfAccounts FK Chart of Accounts
GLAccount FK G/L Account Number
CompanyCode FK Company Code
GLAcctOriginalRecordIsUsed Is Show Old Value Show values
Column Name Description
Column Name Description
Column Name Description
LastInterestCalcRunDate Date of Last Interest Calculation Run
CreationDate Date on which the Record Was Created
InterestCalculationDate Key Date of Last Interest Calculation
Column Name Description
GLAcctOriginalRecordIsUsed Is Show Old Value Show values
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
AccountIsBlockedForPosting Indicator: Is Account Blocked for Posting? Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
GLAccountIsNotProdnRelevant G/L Account not used in production system Show values
ClearingIsLedgerGroupSpecific Open Item Management by Ledger Group Show values
IsExtendedOpenItemManaged Extended Open Item Management Show values
IsCashFlowAccount Cash Receipt Account / Cash Disbursement Account Show values
ReconciliationAcctIsChangeable Indicator: Reconcil.Acct Ready for Input at Time of Posting? Show values
GLAccountType Type of a General Ledger Account Show values
DraftIsProcessedByMe Draft In Process By Me Show values
HasDraftEntity Draft - Indicator - Has draft document Show values
Column Name Description Domain name
GLAccountExternal G/L Account Number CHAR10
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
TaxCategory Tax Category in Account Master Record SMWSK
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AlternativeGLAccountExternal G/L Account Number CHAR10
CommitmentItem Commitment Item FIPOS
ValuationGroup Valuation Group CHAR10
CompanyCodeName Name of Company Code or Company TEXT25
CountryName Country/Region Name TEXT50
GLAcctInflationKeyName Inflation Key - G/L Account (Description) TEXT30
PlanningLevelName Planning Level Short Text TEXT10
HouseBankAccountDescription Account Description TEXT60
ReconciliationAccountTypeName Short Text for Fixed Values DDTEXT
InterestCalculationCodeName Interest calculation indicator name TXT20
AcctgDocItmDspSequenceRuleName Description of the Sort Key TEXT20
APARToleranceGroupName Name of Tolerance Group TEXT30
JointVentureRecoveryCodeName Recovery Indicator Description TEXT35
FieldStatusGroupName Name of the Field Status Definition Group TEXT40
MultiCurrencyAcctgCodeName MCA Key Description TEXT70
CurrencyShortName Short text TEXT15
TaxCodeName Tax Category Name TEXT70
GLAccountName null
GLAccountLongName null
GLAccountTypeName Short Text for Fixed Values DDTEXT
Language null
ActiveDocumentETag Character field, length 32 CHAR32
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InProcessByUser Draft In Process By UNAME
InProcessByUserDescription Draft In Process By (Description) SDRAFT_USER_DESCRIPTION
GLAcctInChartOfAcctsDraftUUID Draft UUID for G/L Account in Chart of Accounts SYSUUID
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • C_GLACCTINCOCDLISTITEM.MANDT == T001S.MANDT
  • C_GLACCTINCOCDLISTITEM.COMPANYCODE == T001S.BUKRS
  • C_GLACCTINCOCDLISTITEM.ACCOUNTINGCLERK == T001S.BUSAB
Key for sorting according to assignment numbers C_GLACCTINCOCDLISTITEM.ACCTGDOCITMDISPLAYSEQUENCERULE == TZUN.ZUAWA
Tolerance Group for G/L Accounts
  • Client
  • Tolerance Group for G/L Accounts
  • Company Code
  • C_GLACCTINCOCDLISTITEM.MANDT == T043S.MANDT
  • C_GLACCTINCOCDLISTITEM.APARTOLERANCEGROUP == T043S.TOGRU
  • C_GLACCTINCOCDLISTITEM.COMPANYCODE == T043S.BUKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_GLACCTINCOCDLISTITEM.MANDT == T004.MANDT
  • C_GLACCTINCOCDLISTITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_GLACCTINCOCDLISTITEM.MANDT == T001.MANDT
  • C_GLACCTINCOCDLISTITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_GLACCTINCOCDLISTITEM.MANDT == TKA01.MANDT
  • C_GLACCTINCOCDLISTITEM.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_GLACCTINCOCDLISTITEM.COUNTRY == T005.LAND1
  • C_GLACCTINCOCDLISTITEM.MANDT == T005.MANDT
Alternative Chart of Accounts
  • Client
  • Alternative Chart of Accounts
  • C_GLACCTINCOCDLISTITEM.MANDT == T004.MANDT
  • C_GLACCTINCOCDLISTITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Field status group
  • Field Status Variant
  • Client
  • Field status group
  • C_GLACCTINCOCDLISTITEM.FIELDSTATUSVARIANT == T004F.BUKRS
  • C_GLACCTINCOCDLISTITEM.MANDT == T004F.MANDT
  • C_GLACCTINCOCDLISTITEM.FIELDSTATUSGROUP == T004F.FSTAG
Field Status Variant
  • Field Status Variant
  • Client
  • C_GLACCTINCOCDLISTITEM.FIELDSTATUSVARIANT == T004V.FSTVA
  • C_GLACCTINCOCDLISTITEM.MANDT == T004V.MANDT
G/L Account Number
  • Client
  • Chart of Accounts
  • G/L Account Number
  • C_GLACCTINCOCDLISTITEM.MANDT == SKA1.MANDT
  • C_GLACCTINCOCDLISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • C_GLACCTINCOCDLISTITEM.GLACCOUNT == SKA1.SAKNR
Account Currency
  • Client
  • Account Currency
  • C_GLACCTINCOCDLISTITEM.MANDT == TCURC.MANDT
  • C_GLACCTINCOCDLISTITEM.GLACCOUNTCURRENCY == TCURC.WAERS
Inflation Key
  • Inflation Key
  • Country/Region Key
  • Client
  • C_GLACCTINCOCDLISTITEM.GLACCTINFLATIONKEY == J_1AINFSKS.J_1AIFSKS
  • C_GLACCTINCOCDLISTITEM.COUNTRY == J_1AINFSKS.LAND1
  • C_GLACCTINCOCDLISTITEM.MANDT == J_1AINFSKS.MANDT
Short Key for a House Bank
  • Client
  • Company Code
  • Short Key for a House Bank
  • C_GLACCTINCOCDLISTITEM.MANDT == T012.MANDT
  • C_GLACCTINCOCDLISTITEM.COMPANYCODE == T012.BUKRS
  • C_GLACCTINCOCDLISTITEM.HOUSEBANK == T012.HBKID
ID for Account Details
  • Client
  • Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • C_GLACCTINCOCDLISTITEM.MANDT == T012K.MANDT
  • C_GLACCTINCOCDLISTITEM.COMPANYCODE == T012K.BUKRS
  • C_GLACCTINCOCDLISTITEM.HOUSEBANK == T012K.HBKID
  • C_GLACCTINCOCDLISTITEM.HOUSEBANKACCOUNT == T012K.HKTID
Interest Indicator
  • Client
  • Interest Indicator
  • C_GLACCTINCOCDLISTITEM.MANDT == T056.MANDT
  • C_GLACCTINCOCDLISTITEM.INTERESTCALCULATIONCODE == T056.VZSKZ
Recovery Indicator
  • Client
  • Company Code
  • Recovery Indicator
  • C_GLACCTINCOCDLISTITEM.MANDT == T8JJ.MANDT
  • C_GLACCTINCOCDLISTITEM.COMPANYCODE == T8JJ.BUKRS
  • C_GLACCTINCOCDLISTITEM.JOINTVENTURERECOVERYCODE == T8JJ.RECID
MCA Key C_GLACCTINCOCDLISTITEM.MULTICURRENCYACCOUNTINGCODE == GLE_MCA_TMCAKEY.MANDT
Planning Level
  • Client
  • Planning Level
  • C_GLACCTINCOCDLISTITEM.MANDT == T036.MANDT
  • C_GLACCTINCOCDLISTITEM.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_GLACCTINCOCDLISTITEM.[column in domain "BWBER"] == T030S.CURTP
  • C_GLACCTINCOCDLISTITEM.MANDT == T030S.MANDT
  • C_GLACCTINCOCDLISTITEM.EXCHRATEDIFFERENCESACCOUNTDETN == T030S.KDFSL
  • C_GLACCTINCOCDLISTITEM.CHARTOFACCOUNTS == T030S.KTOPL