P_APVendorOpenItems2

Accounts Payable Vendor Open Items. Cleared Payments | view: PFIAPVNDROPITM2 | Extraction: Not supported | Component: Information System
Tables used: BKPFBSEGT001TKA02T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
ClearedAmount Amount in Company Code Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
OpenAmount null
ClearingAccountingDocument Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year GJAHR
ClearingAccountingDocumentItem Posting View Item BUZEI
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year GJAHR
InvoiceItemReference Line Item BUZEI
SpecialGLTransactionType Special G/L Transaction Type UMSKS
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_APVENDOROPENITEMS2.MANDT == T001.MANDT
  • P_APVENDOROPENITEMS2.COMPANYCODE == T001.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • P_APVENDOROPENITEMS2.MANDT == TCURC.MANDT
  • P_APVENDOROPENITEMS2.DOCUMENTCURRENCY == TCURC.WAERS
Supplier
  • Client
  • Supplier
  • P_APVENDOROPENITEMS2.MANDT == LFA1.MANDT
  • P_APVENDOROPENITEMS2.SUPPLIER == LFA1.LIFNR