Customer Master Data is one of the important components of SAP that stores the complete customer-related information. Understanding the customer tables in SAP is important for all SAP consultants, business users, and developers who are working on the customer data.
If you are looking for the customer tables in SAP, refer below for all the important list of customer master data tables in SAP ECC & S4 Hana
Customer master tables in SAP
Each customer master stores in different segments.
- General
- Company Code (Financials)
- Sales & Distribution
In SAP, the customer data is stored in multiple tables. Here are some of the important lists of customer master tables in SAP:
- Customer General Data Tables
- Customer Company Code Tables
- Customer Sales Area Tables
- Customer credit management tables
- Customer sales documents tables
- Customer financial document tables
Customer General Data Tables
The general customer master data includes the customer name, address details of the customer, and communication data.
Table | Description |
KNA1 | General Customer Master Data |
KNAS | Customer VAT Registration details |
ADRC | Customer Address Details |
Customer Company Code Tables
The customer company code data contains financial accounting-related data including company code data, dunning data, and customer banking details.
Table | Description |
KNB1 | Customer Master (Company Code) |
KNB5 | Customer Master dunning data |
KNBK | Customer Banking details |
Customer Sales Area Data Tables
The sales area data contains Sales and distribution data specific to the sales organization, distribution channel, and division.
Table | Description |
KNVV | Sales area data |
KNVP | Customer partner functions |
KNVD | Customer sales text |
Customer Credit Management Tables
Table | Description |
KNKK | Customer master credit control area |
KNKA | Customer master credit central data |
Customer Sales Document Tables
Table | Description |
VBAK | Sales document header data |
VBAP | Sales document item data |
VBPA | Sales document partners |
VBRK | Billing document header data |
VBRP | Billing document item data |
Customer Financial Transactions Tables
Table | Description |
BSEG | Financial Document Header |
BKPF | Financial Document line items |
Customer Master Tables in S4 Hana
In SAP S4 Hana, the customer master tables of KNA1, KNB1, and KNVV are replaced with a new table. These changes are due to a customer vendor integration with a single data structure called a business partner (BP).
Now in S4 Hana, customers and suppliers are created as Business Partners and they are identified with the roles.
Table Name | Description |
BUT000 | BP (Business Partner)- General Data |
BUT020 | BP – Address data |
BUT100 | BP – Roles |
BP000 | Business Partner Master (General Data) |
BUT050 | BP Roles/ Relationships (General data) |
TB039A | BP ID Types |
How to download SAP customer master tables
To download the sap tables in PDF, refer to the step-by-step guide:
- On this customer table in the SAP page, right click and then click on the print option
- Select the PDF option and click on the save button
- Now the customer master tables in PDF will be downloaded and saved on your device.