Important list of Accounts Payable tables in SAP. If you are searching for the SAP AP Tables, then you refer below for all the tables of accounts payable.
Accounts Payable is one sub-module of SAP FICO, where it deals with all the transactions and data related to vendors/suppliers.
As an SAP consultant, business user, or developer who works accounts payable sub-module, it is good to know the important SAP tables list along with the SAP accounts tables.
SAP Accounts Payable Tables List
Refer to below for the Accounts Payable (AP) tables in SAP by topic:
Master Data Tables
The following important list of Accounts Payable Master Data Tables:
| Table Name | Description |
| LFA1 | Vendor Master – General Data |
| LFB1 | Vendor Master – Company Code Data |
| LFM1 | Vendor Master Record – Purchasing Org Data |
| LFBK | Vendor Master Bank Details |
| LFC1 | Vendor Master transaction figures |
AP/ Vendor Transactions Tables
The transaction tables include the records of vendor transactions such as Invoices, Payments, Debit, and Credit Memos.
Note: The financial accounting documents are stored in BKPF & BSEG Tables.
| Table Name | Description |
| BKPF | Accounting Document – Header |
| BSEG | Accounting Document – Line Item |
| BSIK | Vendor Open Items |
| BSAK | Vendor Cleared Items |
| BSET | Tax data Line Items |
Withholding Tax Tables
These Withholding tax tables store the tax details related to vendor transactions.
| Table Name | Description |
| WITH_ITEM | Withholding tax info per W/tax type and FI line item |
| T059Z | Withholding Tax Code |
| T059P | Withholding Tax Types |
Payment Tables
These Tables store the data related to vendor payments, clearing details, and payment programs.
| Table Name | Description |
| REGUP | Payment Program – Processed Items |
| REGUH | Payment Program – Payment Data |
| PAYR | Payment Medium File |
Accounts Receivable Tables in SAP S4 Hana
The following are the major changes in S/4HANA Accounts Payable compared to the ECC version.
- The transactional tables BSIK, and BSAK are replaced with ACDOCA Table (universal journal)
- The vendor master data tables LFA1, LFB1 are now managed through Business Partner Tables. Now BP acts as a single entry for customer/vendor master data.
- The traditional reports in ECC are now replaced with the advanced Fiori apps for real-time reporting and analytics.