I_ActiveGLAcctInCOAListItem

active GL in COA with draft information | view: IFIGLCOALIST | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SDRAFT_ADMIN, T004, USR21, SKA1, SKA1_DRAFT_20, SKAD, PSM_D_GLACCTX
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
GLAccountIsNotProdnRelevant G/L Account not used in production system Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBdgtAcctIsPostgAllowed Posting to Budget Account Allowed Show values
PubSecBdgtAcctIsBdgtAllowed Budgeting Allowed for Budget Account Show values
PubSecBdgtAcctIsCarryFwd Use Budget Account as Carryforward 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
ProfitLossAccountType P&L statement account type CHAR2
CreatedByUser Name of Person who Created the Object USNAM
InProcessByUser Draft In Process By UNAME
InProcessByUserDescription Draft In Process By (Description) SDRAFT_USER_DESCRIPTION
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Bank Reconciliation Account
  • Chart of Accounts
  • Bank Reconciliation Account
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_ACTIVEGLACCTINCOALISTITEM.BANKRECONCILIATIONACCOUNT == SKA1.SAKNR
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == SKA1.MANDT
Cash Origin Account
  • Client
  • Cash Origin Account
  • ?
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == SKA1.MANDT
  • I_ACTIVEGLACCTINCOALISTITEM.CASHLEDGERACCOUNT == SKA1.SAKNR
  • I_ACTIVEGLACCTINCOALISTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.CHARTOFACCOUNTS == T004.KTOPL
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == T004.MANDT
Group Account Number
  • Group Account Number
  • Group Chart of Accts
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.CORPORATEGROUPACCOUNT == SKA1.SAKNR
  • I_ACTIVEGLACCTINCOALISTITEM.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == SKA1.MANDT
Group Chart of Accts
  • Group Chart of Accts
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == T004.MANDT
Functional Area
  • Functional Area
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.FUNCTIONALAREA == TFKB.FKBER
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == TFKB.MANDT
G/L Account Group
  • G/L Account Group
  • Chart of Accounts
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.GLACCOUNTGROUP == T077S.KTOKS
  • I_ACTIVEGLACCTINCOALISTITEM.CHARTOFACCOUNTS == T077S.KTOPL
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == T077S.MANDT
Subtype of a GL Account
  • Subtype of a GL Account
  • Type of a General Ledger Account
  • I_ACTIVEGLACCTINCOALISTITEM.GLACCOUNTSUBTYPE == FINS_GLACC_SUBTY.GLACCOUNT_SUBTYPE
  • I_ACTIVEGLACCTINCOALISTITEM.GLACCOUNTTYPE == FINS_GLACC_SUBTY.GLACCOUNT_TYPE
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.PARTNERCOMPANY == T880.RCOMP
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == T880.MANDT
Carry Forward Budget Account To Account
  • Client
  • Carry Forward Budget Account To Account
  • ?
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == SKA1.MANDT
  • I_ACTIVEGLACCTINCOALISTITEM.PUBSECBDGTACCTCARRYFWDTO == SKA1.SAKNR
  • I_ACTIVEGLACCTINCOALISTITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Budget Consumption Type
  • Client
  • Budget Consumption Type
Number of the Sample Account
  • Number of the Sample Account
  • Chart of Accounts
  • Client
  • I_ACTIVEGLACCTINCOALISTITEM.SAMPLEGLACCOUNT == SKM1.MUSTR
  • I_ACTIVEGLACCTINCOALISTITEM.CHARTOFACCOUNTS == SKM1.KTOPL
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == SKM1.MANDT
Sponsored Class
  • Client
  • Sponsored Class
  • I_ACTIVEGLACCTINCOALISTITEM.MANDT == GMSPCLASS.CLIENT
  • I_ACTIVEGLACCTINCOALISTITEM.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS