P_APVendorOpenItems7

Accounts Payable Vendor Open Items. Open Amount | view: PFIAPVNDROPITM7 | 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):
OpenAmount Amount in Company Code Currency
ClearedAmount null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SpecialGLTransactionType Special G/L Transaction Type UMSKS
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_APVENDOROPENITEMS7.MANDT == T001.MANDT
  • P_APVENDOROPENITEMS7.COMPANYCODE == T001.BUKRS
Transaction Currency
  • Transaction Currency
  • Client
  • P_APVENDOROPENITEMS7.DOCUMENTCURRENCY == TCURC.WAERS
  • P_APVENDOROPENITEMS7.MANDT == TCURC.MANDT
Supplier
  • Client
  • Supplier
  • P_APVENDOROPENITEMS7.MANDT == LFA1.MANDT
  • P_APVENDOROPENITEMS7.SUPPLIER == LFA1.LIFNR