If you are working in SAP Accounts Receivable(AR) sub-module, here the important list of SAP AR Tables with a customer master data table that every SAP consultant & user should know.
SAP Accounts Receivable is one of the important sub-modules of the SAP FICO module, where it deals with customer-related data and transactions. AR is completely integrated with the SAP SD module to handle customer-related activities like customer invoices, payments, correspondence, etc.
SAP Accounts Receivable (AR) Tables List
Here a complete list of important SAP Accounts Receivable Tables that are used for customer master data.
| Table | Description |
| T077D | Customer Account Groups |
| T079D | Customer Account groups per company code |
| T100C | Message control for customer master data |
| T001S | Accounting Clerk Identification code for customers |
| T021T | Line Layouts for open item processing |
| T021P | Standard Line Layout for Open Item Processing |
| T048 | Correspondence Type |
| T048K | Indicator for Periodic account statements for customers |
| KNA1 | Customer Master – General data |
| KNB1 | Customer Master – Company Code Data |
| KNVV | Customer Master – Sales Data |
| KNBK | Customer Master data – Bank Details |
| KNAS | Customer Master – VAT Registration numbers |
| KNAT | Customer master group – tax groupings |
| KNB4 | Customer Payment History |
| KNBW | Customer Master record – withholding tax types |
| KNC1 | Customer Master Transaction Figures |
| KNC3 | Customer Master Data with Special G/L Transaction Figures |
| KNEA | Customer master – Assignment of Bank Details & Payment method to revenue type |
| KNEX | Customer Master – Legal control |
| KNKA | Customer Master Data Credit Management – Central Data |
| KNKK | Customer Master Credit Management – control area data |
| KNKKF1 | Credit Management FI Status data |
| KNMT | Customer Material Info record data table |
| KNMTK | Customer material info record header table |
| KNVA | Customer Master uploading points |
| KNVD | Customer master record sales request form |
| KNVH | Customer Hierarchies |
| KNVI | Customer master tax indicator |
| KNVK | Customer Master Contract Partner |
| KNVL | Customer Master Licenses |
| KNVP | Customer Master Partner Functions |
| KNVS | Customer Master Shipping Data |
| KNVT | Customer master record text for sales |
SAP AR Tables in SAP S4 Hana
There are many tables that are moved to compatibility views, means no data is updated in the tables. In SAP FICO, the following are major changes in tables
- In SAP S4 Hana, the new table called ACDOCA table has been introduced
- It is called a universal journal journal table, and it includes all the fields from the different components of SAP.
- The secondary index and aggregate index tables are removed in S4 Hana.
- The AR tables like KNA1, KNB1, and KNVV are moved to compatibility view and now the data is stored in the business partner tables in SAP S4 Hana.
Also, if you want to know more about the complete SAP Tables & Other modules, you can refer