Customer Master Data Table in SAP
Customer Master Data Table in SAP – Complete important list of Customer Master Data tables that are using for day to day customer business transactions.
Customer Master record in SAP contains the core business information about the customers that helps how the business transactions of customers are recorded and processed in the system.
Customer master record is maintained at different levels:
- General Data
- Company code level (FI-AR) and
- Sales org level (FI-SD).
The Account Receivable module can be integrated with the SAP SD module to process the customer master data for sales order processing, shipping, delivery & billing.
It is mandatory to maintain the customer master data before posting and processing the customers’ related business transactions. Without maintaining the required customer master record, it is not possible to process customer transactions.
All the customer-related business transactions that are processed in the SAP system are stored in the different tables as per the transactions. For example, the customer company code data stores in the table of KNB1 and the customer sales organization data is stores in the table KNVV.
Important list of Customer Master Tables in SAP
Here are tables of customer master data that are used for day to day business transactions.
| Table | Description |
| KNA1 | Customer Master Data – General Data |
| KNB1 | Customer Master Data – Company Code |
| KNVV | Customer Master Data – Sales Org |
| ADRC | Customer Master Data – Address |
| KNBK | Customer Master Bank Data |
| KNVP | Customer Master Partner Functions |
| KNB5 | Customer Master Dunning Data |
| KNVS | Customer Master Shipping Data |
Note: Each customer master record is assigned to an address number (ADRNR), The complete address details of the customer is stored in a table called ADRC.
Important Transaction Codes that are used for the creation of Customer Master Data in SAP
- XD01 – Create customer centrally
- XDN1 – Maintain Number Ranges for customer account groups
- FB70 – FI customer Invoice
- VF01 – Billing Document.