P_APVendorOpenItems0

Account Payable Vendor Open Items. Accounting Document Item | view: PFIAPVNDROPITM0 | Extraction: Not supported | Component: Information System
Tables used: BSEGT001TKA02T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (DocumentCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
AccountingDocumentCategory Document Status Show values
FinancialAccountType Account Type Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
Column Name Description Domain name
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year GJAHR
InvoiceItemReference Line Item BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
SpecialGLTransactionType Special G/L Transaction Type UMSKS
ClearingAccountingDocument Clearing Document Number BELNR
TransactionTypeDetermination Transaction Key CHAR3
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_APVENDOROPENITEMS0.MANDT == T001.MANDT
  • P_APVENDOROPENITEMS0.COMPANYCODE == T001.BUKRS
Transaction Currency
  • Transaction Currency
  • Client
  • P_APVENDOROPENITEMS0.DOCUMENTCURRENCY == TCURC.WAERS
  • P_APVENDOROPENITEMS0.MANDT == TCURC.MANDT
Supplier
  • Supplier
  • Client
  • P_APVENDOROPENITEMS0.SUPPLIER == LFA1.LIFNR
  • P_APVENDOROPENITEMS0.MANDT == LFA1.MANDT