I_GLAccountInChartOfAccounts

G/L Account In Chart Of Accounts | view: IFIGLACCINCOA | ATTR | Extraction: Full or Incremental | Component: Information System
Tables used: T004, SKA1
Column Name Description
ChartOfAccounts FK Chart of Accounts
GLAccount G/L Account Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
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
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
ProfitLossAccountType P&L statement account type CHAR2
CreatedByUser Name of Person who Created the Object USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GLAccountExternal G/L Account Number CHAR10
IsProfitLossAccount Indicator: Account is a balance sheet account?
Master Data Relations Join Conditions
Bank Reconciliation Account
  • Bank Reconciliation Account
  • Client
  • Chart of Accounts
  • I_GLACCOUNTINCHARTOFACCOUNTS.BANKRECONCILIATIONACCOUNT == SKA1.SAKNR
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == SKA1.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == SKA1.KTOPL
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T004.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == T004.KTOPL
Group Account Number
  • Client
  • Group Account Number
  • Group Chart of Accts
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == SKA1.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • I_GLACCOUNTINCHARTOFACCOUNTS.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
Group Chart of Accts
  • Client
  • Group Chart of Accts
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T004.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
Functional Area
  • Client
  • Functional Area
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == TFKB.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.FUNCTIONALAREA == TFKB.FKBER
G/L Account Group
  • Client
  • Chart of Accounts
  • G/L Account Group
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T077S.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == T077S.KTOPL
  • I_GLACCOUNTINCHARTOFACCOUNTS.GLACCOUNTGROUP == T077S.KTOKS
Subtype of a GL Account
  • Subtype of a GL Account
  • Type of a General Ledger Account
  • I_GLACCOUNTINCHARTOFACCOUNTS.GLACCOUNTSUBTYPE == FINS_GLACC_SUBTY.GLACCOUNT_SUBTYPE
  • I_GLACCOUNTINCHARTOFACCOUNTS.GLACCOUNTTYPE == FINS_GLACC_SUBTY.GLACCOUNT_TYPE
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T880.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.PARTNERCOMPANY == T880.RCOMP
Number of the Sample Account
  • Client
  • Chart of Accounts
  • Number of the Sample Account
  • I_GLACCOUNTINCHARTOFACCOUNTS.MANDT == SKM1.MANDT
  • I_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == SKM1.KTOPL
  • I_GLACCOUNTINCHARTOFACCOUNTS.SAMPLEGLACCOUNT == SKM1.MUSTR