P_FINS_GL_CLEAREDITEMS

GL Open Items select to clearing | view: PGLCLEAREDITEMS | Extraction: Not supported | Component: Posting/Clearing
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Local Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
Column Name Description
FinancialAccountType Account type Show values
AccountingDocumentCategory Document Status Show values
Column Name Description Domain name
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
ClearingAccountingDocument Document Number of the Clearing Document BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Document GJAHR
AssignmentReference Assignment number ZUONR
DocumentItemText Item Text TEXT50
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
FollowOnDocumentType Follow-On Document Type REBZT
SpecialGLCode null
AccountingDocumentItemType null
PaymentCardItem null
CashDiscountAmtInCoCodeCrcy null
AmountInAdditionalCurrency1 null
AmountInAdditionalCurrency2 null
Master Data Relations Join Conditions
Account Number
  • Account Number
  • Company Code
  • Client
  • P_FINS_GL_CLEAREDITEMS.ACCOUNT == SKB1.SAKNR
  • P_FINS_GL_CLEAREDITEMS.COMPANYCODE == SKB1.BUKRS
  • P_FINS_GL_CLEAREDITEMS.MANDT == SKB1.MANDT
Document Type
  • Document Type
  • Client
  • P_FINS_GL_CLEAREDITEMS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FINS_GL_CLEAREDITEMS.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_FINS_GL_CLEAREDITEMS.COMPANYCODE == T001.BUKRS
  • P_FINS_GL_CLEAREDITEMS.MANDT == T001.MANDT