I_ActiveGLAcctInCoCodeListItem

company code list item data | view: IFIACOCDLI | 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, 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
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
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
DraftIsProcessedByMe Draft In Process By Me Show values
HasDraftEntity Draft - Indicator - Has draft document 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
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
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
GLAcctInChartOfAcctsDraftUUID Draft UUID for G/L Account in Chart of Accounts SYSUUID
InProcessByUser Draft In Process By UNAME
InProcessByUserDescription Draft In Process By (Description) SDRAFT_USER_DESCRIPTION
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CompanyCodeName Name of Company Code or Company TEXT25
GLAccountName G/L Account Short Text TEXT20
GLAccountLongName G/L Account Long Text TEXT50
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
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Accounting Clerk Abbreviation
  • Client
  • Company Code
  • I_ACTIVEGLACCTINCOCODELISTITEM.ACCOUNTINGCLERK == T001S.BUSAB
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T001S.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.COMPANYCODE == T001S.BUKRS
Key for sorting according to assignment numbers I_ACTIVEGLACCTINCOCODELISTITEM.ACCTGDOCITMDISPLAYSEQUENCERULE == TZUN.ZUAWA
Tolerance Group for G/L Accounts
  • Client
  • Tolerance Group for G/L Accounts
  • Company Code
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T043S.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.APARTOLERANCEGROUP == T043S.TOGRU
  • I_ACTIVEGLACCTINCOCODELISTITEM.COMPANYCODE == T043S.BUKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T004.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T001.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == TKA01.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.COUNTRY == T005.LAND1
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T005.MANDT
Alternative Chart of Accounts
  • Alternative Chart of Accounts
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T004.MANDT
Field status group
  • Field Status Variant
  • Client
  • Field status group
  • I_ACTIVEGLACCTINCOCODELISTITEM.FIELDSTATUSVARIANT == T004F.BUKRS
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T004F.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.FIELDSTATUSGROUP == T004F.FSTAG
Field Status Variant
  • Field Status Variant
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.FIELDSTATUSVARIANT == T004V.FSTVA
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T004V.MANDT
G/L Account Number
  • G/L Account Number
  • Client
  • Chart of Accounts
  • I_ACTIVEGLACCTINCOCODELISTITEM.GLACCOUNT == SKA1.SAKNR
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == SKA1.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
Account Currency
  • Account Currency
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.GLACCOUNTCURRENCY == TCURC.WAERS
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == TCURC.MANDT
Inflation Key
  • Country/Region Key
  • Client
  • Inflation Key
  • I_ACTIVEGLACCTINCOCODELISTITEM.COUNTRY == J_1AINFSKS.LAND1
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == J_1AINFSKS.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.GLACCTINFLATIONKEY == J_1AINFSKS.J_1AIFSKS
Short Key for a House Bank
  • Client
  • Company Code
  • Short Key for a House Bank
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T012.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.COMPANYCODE == T012.BUKRS
  • I_ACTIVEGLACCTINCOCODELISTITEM.HOUSEBANK == T012.HBKID
ID for Account Details
  • Client
  • Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T012K.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.COMPANYCODE == T012K.BUKRS
  • I_ACTIVEGLACCTINCOCODELISTITEM.HOUSEBANK == T012K.HBKID
  • I_ACTIVEGLACCTINCOCODELISTITEM.HOUSEBANKACCOUNT == T012K.HKTID
Interest Indicator
  • Interest Indicator
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.INTERESTCALCULATIONCODE == T056.VZSKZ
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T056.MANDT
Recovery Indicator
  • Client
  • Recovery Indicator
  • Company Code
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T8JJ.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.JOINTVENTURERECOVERYCODE == T8JJ.RECID
  • I_ACTIVEGLACCTINCOCODELISTITEM.COMPANYCODE == T8JJ.BUKRS
MCA Key I_ACTIVEGLACCTINCOCODELISTITEM.MULTICURRENCYACCOUNTINGCODE == GLE_MCA_TMCAKEY.MANDT
Planning Level
  • Planning Level
  • Client
  • I_ACTIVEGLACCTINCOCODELISTITEM.PLANNINGLEVEL == T036.EBENE
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T036.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • Client
  • ?
  • Chart of Accounts
  • I_ACTIVEGLACCTINCOCODELISTITEM.EXCHRATEDIFFERENCESACCOUNTDETN == T030S.KDFSL
  • I_ACTIVEGLACCTINCOCODELISTITEM.MANDT == T030S.MANDT
  • I_ACTIVEGLACCTINCOCODELISTITEM.[column in domain "BWBER"] == T030S.CURTP
  • I_ACTIVEGLACCTINCOCODELISTITEM.CHARTOFACCOUNTS == T030S.KTOPL