A_GLAccountInChartOfAccounts

API G/L Account In Chart Of Accounts | view: AFIGLACCINCOA | Extraction: Not supported | Component: Information System
Tables used: T004SKA1
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
IsProfitLossAccount Indicator: Account is a balance sheet 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
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • A_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == T004.KTOPL
  • A_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T004.MANDT
Group Account Number
  • Group Account Number
  • ?
  • Client
  • A_GLACCOUNTINCHARTOFACCOUNTS.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • A_GLACCOUNTINCHARTOFACCOUNTS.[column in domain "KTOPL"] == SKA1.KTOPL
  • A_GLACCOUNTINCHARTOFACCOUNTS.MANDT == SKA1.MANDT
Functional Area
  • Functional Area
  • Client
  • A_GLACCOUNTINCHARTOFACCOUNTS.FUNCTIONALAREA == TFKB.FKBER
  • A_GLACCOUNTINCHARTOFACCOUNTS.MANDT == TFKB.MANDT
G/L Account Group
  • Chart of Accounts
  • G/L Account Group
  • Client
  • A_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == T077S.KTOPL
  • A_GLACCOUNTINCHARTOFACCOUNTS.GLACCOUNTGROUP == T077S.KTOKS
  • A_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T077S.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • A_GLACCOUNTINCHARTOFACCOUNTS.MANDT == T880.MANDT
  • A_GLACCOUNTINCHARTOFACCOUNTS.PARTNERCOMPANY == T880.RCOMP
Number of the Sample Account
  • Number of the Sample Account
  • Chart of Accounts
  • Client
  • A_GLACCOUNTINCHARTOFACCOUNTS.SAMPLEGLACCOUNT == SKM1.MUSTR
  • A_GLACCOUNTINCHARTOFACCOUNTS.CHARTOFACCOUNTS == SKM1.KTOPL
  • A_GLACCOUNTINCHARTOFACCOUNTS.MANDT == SKM1.MANDT