I_APVendorOpenItems

Accounts Payable. Vendor Open Items | view: IFIAPVNDROPITMS | TRAN | Extraction: Not supported | Component: Information System
Tables used: BKPFBSEGT001TKA02LFA1LFB1T001T014
Column Name Description
CompanyCode FK Company Code
Supplier FK Supplier
AccountingDocCreatedByUser User that created the journal entry
TransactionCurrency FK Transaction Currency
Column Name Description
💲 Display Currency (DisplayCurrency):
OpenAmountInDisplayCrcy Open Amount in Display Currency
DownPaymentAmountInDspCrcy Down Payment Amount in Display Currency
OtherPaymentAmountInDspCrcy Other Payment Amount in Display Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SupplierBasicAuthorizationGrp Authorization Group BRGRU
SupplierFinsAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_APVENDOROPENITEMS.COMPANYCODE == T001.BUKRS
  • I_APVENDOROPENITEMS.MANDT == T001.MANDT
Supplier
  • Supplier
  • Client
  • I_APVENDOROPENITEMS.SUPPLIER == LFA1.LIFNR
  • I_APVENDOROPENITEMS.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_APVENDOROPENITEMS.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_APVENDOROPENITEMS.MANDT == TCURC.MANDT