P_FINS_GL_AGGR_OPENITEM_AMOUNT

GL Manual Clearing Worklist Item | view: PFINSAGGROIAMT | Extraction: Not supported | Component: Posting/Clearing
Column Name Description
CompanyCode FK Company Code
GLAccount FK Account Number
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
DebitAmountInCompanyCodeCrcy null
CreditAmountinCompanyCodeCrcy null
BalanceAmountInCompanyCodeCrcy null
Column Name Description
Column Name Description
PostedByDate null
Column Name Description
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
GLAccountName G/L Account Long Text TEXT50
GLAccountAuthorizationGroup Authorization Group BRGRU
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AlternativeGLAccountName G/L Account Long Text TEXT50
CompanyCodeName Name of Company Code or Company TEXT25
NumberOfOpenItems null
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.CHARTOFACCOUNTS == T004.KTOPL
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.COMPANYCODE == T001.BUKRS
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.MANDT == TCURC.MANDT
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.COMPANYCODECURRENCY == TCURC.WAERS
Account Number
  • Company Code
  • Account Number
  • Client
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.COMPANYCODE == SKB1.BUKRS
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.GLACCOUNT == SKB1.SAKNR
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.MANDT == SKB1.MANDT
Ledger Group
  • Client
  • Ledger Group
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.MANDT == FAGL_TLDGRP.MANDT
  • P_FINS_GL_AGGR_OPENITEM_AMOUNT.LEDGERGROUP == FAGL_TLDGRP.LDGRP