C_GLAcctInCoCodeTP

Consumption View: G/L Acct in CoCode | view: CGLACOCDTD | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: TZUN, TZUNT, T004, T001, TKA02, T005, T005T, TCURC, TCURX, TCURT, T004F, T004G, SKA1, SKB1, T043S, T043ST, SKA1, J_1AINFSKS, J_1AINFSKT, T056, T056X, T8JJ, T8JJT, GLE_MCA_TMCAKEY, GLE_MCA_TMCAKEYT, T036, T036T, USR21, SKAT, T004, 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
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
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
ClearingIsLedgerGroupSpecific Open Item Management by Ledger Group Show values
IsCashFlowAccount Cash Receipt Account / Cash Disbursement Account Show values
ReconciliationAcctIsChangeable Indicator: Reconcil.Acct Ready for Input at Time of Posting? Show values
IsExtendedOpenItemManaged Extended Open Item Management Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
PlanningLevelName Planning Level Short Text TEXT10
HouseBankAccountDescription Account Description TEXT60
ReconciliationAccountTypeName Short Text for Fixed Values DDTEXT
TaxCategory Tax Category in Account Master Record SMWSK
TaxCodeName Tax Category Name TEXT70
InterestCalculationCodeName Interest calculation indicator name TXT20
CurrencyShortName Short text TEXT15
AcctgDocItmDspSequenceRuleName Description of the Sort Key TEXT20
AlternativeGLAccountExternal G/L Account Number, Significant Length CHAR10
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AlternativeGLAccountName G/L Account Short Text TEXT20
JointVentureRecoveryCodeName Recovery Indicator Description TEXT35
CommitmentItem Commitment Item FIPOS
ValuationGroup Valuation Group CHAR10
APARToleranceGroupName Name of Tolerance Group TEXT30
GLAcctInflationKeyName Inflation Key - G/L Account (Description) TEXT30
FieldStatusGroupName Name of the Field Status Definition Group TEXT40
MultiCurrencyAcctgCodeName MCA Key Description TEXT70
GLAccountName G/L Account Short Text TEXT20
GLAccountLongName G/L Account Long Text TEXT50
CountryName Country/Region Name TEXT50
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Company Code
  • Accounting Clerk Abbreviation
  • Client
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T001S.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T001S.BUKRS
  • C_GLACCTINCOCODETP.ACCOUNTINGCLERK == T001S.BUSAB
  • C_GLACCTINCOCODETP.MANDT == T001S.MANDT
Key for sorting according to assignment numbers C_GLACCTINCOCODETP.ACCTGDOCITMDISPLAYSEQUENCERULE == TZUN.ZUAWA
Tolerance Group for G/L Accounts
  • Company Code
  • Company Code
  • Client
  • Tolerance Group for G/L Accounts
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T043S.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T043S.BUKRS
  • C_GLACCTINCOCODETP.MANDT == T043S.MANDT
  • C_GLACCTINCOCODETP.APARTOLERANCEGROUP == T043S.TOGRU
Chart of Accounts
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • C_GLACCTINCOCODETP.MANDT == T004.MANDT
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTS == T004.KTOPL
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTSFOREDIT == T004.KTOPL
Chart of Accounts
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • C_GLACCTINCOCODETP.MANDT == T004.MANDT
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTS == T004.KTOPL
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTSFOREDIT == T004.KTOPL
Company Code
  • Company Code
  • Company Code
  • Client
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T001.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T001.BUKRS
  • C_GLACCTINCOCODETP.MANDT == T001.MANDT
Company Code
  • Company Code
  • Company Code
  • Client
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T001.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T001.BUKRS
  • C_GLACCTINCOCODETP.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_GLACCTINCOCODETP.MANDT == TKA01.MANDT
  • C_GLACCTINCOCODETP.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_GLACCTINCOCODETP.COUNTRY == T005.LAND1
  • C_GLACCTINCOCODETP.MANDT == T005.MANDT
Alternative Chart of Accounts
  • Client
  • Alternative Chart of Accounts
  • C_GLACCTINCOCODETP.MANDT == T004.MANDT
  • C_GLACCTINCOCODETP.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Field status group
  • Field Status Variant
  • Client
  • Field status group
  • C_GLACCTINCOCODETP.FIELDSTATUSVARIANT == T004F.BUKRS
  • C_GLACCTINCOCODETP.MANDT == T004F.MANDT
  • C_GLACCTINCOCODETP.FIELDSTATUSGROUP == T004F.FSTAG
Field Status Variant
  • Field Status Variant
  • Client
  • C_GLACCTINCOCODETP.FIELDSTATUSVARIANT == T004V.FSTVA
  • C_GLACCTINCOCODETP.MANDT == T004V.MANDT
G/L Account Number
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • G/L Account Number
  • G/L Account Number
  • C_GLACCTINCOCODETP.MANDT == SKA1.MANDT
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTS == SKA1.KTOPL
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTSFOREDIT == SKA1.KTOPL
  • C_GLACCTINCOCODETP.GLACCOUNT == SKA1.SAKNR
  • C_GLACCTINCOCODETP.GLACCOUNTFOREDIT == SKA1.SAKNR
Account Currency
  • Account Currency
  • Client
  • C_GLACCTINCOCODETP.GLACCOUNTCURRENCY == TCURC.WAERS
  • C_GLACCTINCOCODETP.MANDT == TCURC.MANDT
G/L Account Number
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • G/L Account Number
  • G/L Account Number
  • C_GLACCTINCOCODETP.MANDT == SKA1.MANDT
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTS == SKA1.KTOPL
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTSFOREDIT == SKA1.KTOPL
  • C_GLACCTINCOCODETP.GLACCOUNT == SKA1.SAKNR
  • C_GLACCTINCOCODETP.GLACCOUNTFOREDIT == SKA1.SAKNR
Inflation Key
  • Country/Region Key
  • Client
  • Inflation Key
  • C_GLACCTINCOCODETP.COUNTRY == J_1AINFSKS.LAND1
  • C_GLACCTINCOCODETP.MANDT == J_1AINFSKS.MANDT
  • C_GLACCTINCOCODETP.GLACCTINFLATIONKEY == J_1AINFSKS.J_1AIFSKS
Short Key for a House Bank
  • Company Code
  • Company Code
  • Client
  • Short Key for a House Bank
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T012.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T012.BUKRS
  • C_GLACCTINCOCODETP.MANDT == T012.MANDT
  • C_GLACCTINCOCODETP.HOUSEBANK == T012.HBKID
ID for Account Details
  • Company Code
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T012K.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T012K.BUKRS
  • C_GLACCTINCOCODETP.HOUSEBANKACCOUNT == T012K.HKTID
  • C_GLACCTINCOCODETP.MANDT == T012K.MANDT
  • C_GLACCTINCOCODETP.HOUSEBANK == T012K.HBKID
Interest Indicator
  • Client
  • Interest Indicator
  • C_GLACCTINCOCODETP.MANDT == T056.MANDT
  • C_GLACCTINCOCODETP.INTERESTCALCULATIONCODE == T056.VZSKZ
Recovery Indicator
  • Company Code
  • Company Code
  • Client
  • Recovery Indicator
  • C_GLACCTINCOCODETP.COMPANYCODEFOREDIT == T8JJ.BUKRS
  • C_GLACCTINCOCODETP.COMPANYCODE == T8JJ.BUKRS
  • C_GLACCTINCOCODETP.MANDT == T8JJ.MANDT
  • C_GLACCTINCOCODETP.JOINTVENTURERECOVERYCODE == T8JJ.RECID
Maintenance Language for the Chart of Accounts C_GLACCTINCOCODETP.MAINTENANCELANGUAGE == T002.SPRAS
MCA Key C_GLACCTINCOCODETP.MULTICURRENCYACCOUNTINGCODE == GLE_MCA_TMCAKEY.MANDT
Planning Level
  • Planning Level
  • Client
  • C_GLACCTINCOCODETP.PLANNINGLEVEL == T036.EBENE
  • C_GLACCTINCOCODETP.MANDT == T036.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • Client
  • ?
  • Chart of Accounts
  • Chart of Accounts
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • C_GLACCTINCOCODETP.MANDT == T030S.MANDT
  • C_GLACCTINCOCODETP.[column in domain "BWBER"] == T030S.CURTP
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTS == T030S.KTOPL
  • C_GLACCTINCOCODETP.CHARTOFACCOUNTSFOREDIT == T030S.KTOPL
  • C_GLACCTINCOCODETP.EXCHRATEDIFFERENCESACCOUNTDETN == T030S.KDFSL