P_FINS_GL_OPENITEM_AMOUNT

GL Manual Clearing Worklist Item | view: PFINSGLOIAMT | Extraction: Not supported | Component: Posting/Clearing
Column Name Description
CompanyCode FK Company Code
GLAccount FK Account Number
FiscalYear Fiscal Year
AccountingDocumentNumber Document Number of an Accounting Document
ItemNumber Reference Document Line Item
Column Name Description
DebitAmountInCompanyCodeCrcy Amount in Company Code Currency
CreditAmountinCompanyCodeCrcy Amount in Company Code Currency
BalanceAmountInCompanyCodeCrcy Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
GLAccountName G/L Account Long Text TEXT50
CompanyCodeName Name of Company Code or Company TEXT25
GLAccountAuthorizationGroup Authorization Group BRGRU
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AlternativeGLAccountName G/L Account Long Text TEXT50
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_FINS_GL_OPENITEM_AMOUNT.CHARTOFACCOUNTS == T004.KTOPL
  • P_FINS_GL_OPENITEM_AMOUNT.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_FINS_GL_OPENITEM_AMOUNT.MANDT == T001.MANDT
  • P_FINS_GL_OPENITEM_AMOUNT.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • P_FINS_GL_OPENITEM_AMOUNT.COMPANYCODECURRENCY == TCURC.WAERS
  • P_FINS_GL_OPENITEM_AMOUNT.MANDT == TCURC.MANDT
Account Number
  • Client
  • Account Number
  • Company Code
  • P_FINS_GL_OPENITEM_AMOUNT.MANDT == SKB1.MANDT
  • P_FINS_GL_OPENITEM_AMOUNT.GLACCOUNT == SKB1.SAKNR
  • P_FINS_GL_OPENITEM_AMOUNT.COMPANYCODE == SKB1.BUKRS
Ledger Group
  • Ledger Group
  • Client
  • P_FINS_GL_OPENITEM_AMOUNT.LEDGERGROUP == FAGL_TLDGRP.LDGRP
  • P_FINS_GL_OPENITEM_AMOUNT.MANDT == FAGL_TLDGRP.MANDT