SAP SD - Customer & Material Master Data


Advertisements

Master data is one of the key factors in Sales and Distribution module. There are two levels of masters in SD.

The first level master includes −

  • Customer Master
  • Material Master
  • Pricing Conditions

While, the second level master is −

  • Output condition

Create a Customer Master Record

The customer master data contains the information about business transaction and how transactions are recorded and executed by the system. A Master contains the information about the customers that an organization uses to do business with them.

Key tables in Customer Master

Table Name Key Description
KNA1 KUNNR General Information
KNB1 KUNNR,BUKRS Company Code
KNVV VKOGRG,VTWEG,SPART,KUNNR Sales Area
KNBK KUNNR,BANKS,BANKL,BANKN Bank Data
VCNUM CCINS,CCNUM Credit Card
VCKUN CCINS,CCNUM,KUNNR Credit Card Assignment
KNVK PARNR Contact Person
KNVP VKORG,VTWEG,SPART,PARVW,KUNNR Partner Functions

Main Transaction Codes in a Customer Master

S.No Transaction Codes & Description
1

XD01, XD02, XD03

Used to create/change/display customer centrally

2

VD01,VD02,VD03

Used to create/change/display customer sales area

3

FD01,FD02,FD03

Used to create/change/display customer company code

4

XD04

Display change documents

5

XD05

Used to block Customer − Global, order, delivery, billing, sales area, etc.

6

XD06

Used for deletion

7

XD07

Change Account Group

8

VAP1

Create Contact Person

Creating a Customer Master Data

To create a customer master data, you need to use an Account group.

T-Code: XD01/VD01/FD01

Note that if you use −

  • XD01 − This Includes sales area in the customer master and data is stored in tables KNA1, KNB1 and KNVV.

  • VD01 − This includes sales area & data, which will be stored in tables KNA1, KNB1 and KNVV and there is no company code data in this.

  • FD01 − This is company code level & data is stored in tables KNA1 and KNB1.

Customer Master Data

Then a new window will open. Enter the following details −

  • Select the Account Group from the list.
  • Enter the customer number and select the company code.

Then you can enter the Sales Area details like −

  • Sales Organization
  • Distribution Channel
  • Division

In case you want to take reference from an existing customer to create customer master, you can use the reference option.

Once all the details are selected, click the Tick mark.

Customer Create Initial Screen

A new window will open to enter the customer master data. This customer master data has 3 key sections −

  • General Data like Title, Name, Address, etc.
  • Company Code Data and
  • Sales Area Data.
Customer General Data

Note that this region fields define the tax calculation like VAT, CST, etc. The next step is to go to Control Data and enter the following details.

Control Data

Then you have to enter the particulars in Payment Transaction tab and enter the details of – Bank City, Bank Key, Bank Account and Account Holder Name. You can also add more details by clicking on the Bank data button.

Bank Details

The next step is to go to the Sales Area data and enter the details – Shipping Data, Customer Pricing and Partner Functions, etc.

Sales Area Details

Next is to click on the Save icon at the top and you will get a confirmation that the customer has been created with #.

Saving Icon

If you have to make any further changes to the customer’s master data, you can use T-Code: XD02.

Advertisements