SAP Vendor Master Data Configuration

     Vendor Master Data contains information about vendors that supply an enterprise. Information that is stored in Vendor Master is vendor’s name, address, as well as data such as: Term of Payment, Bank of Payee, Withholding Tax Information, Ordering Address and etc. 

In SAP, there are 3 views of Vendor Master.

1. General View contains general data of vendor such as vendor’s address, contact information, tax information and bank information. Technically, SAP splits all of this into 3 tabs which are Address, Control and Payment Transactions.

2. Accounting View contains accounting information such as reconcile account, payment term, dunning procedure, withholding tax and etc. Data is kept at company level. It’s mean that 1 vendor can have different data in each company.

3. Purchasing View contains purchasing data which use in MM-PUR such as order currency, term of payment, partner function and etc. Data is kept at purchasing organization level.

Vendor Master Transaction Code

XK01 - Create Vendor Centrally

XK02 - Change Vendor Centrally

XK03 – Display Vendor Centrally 

XK04 –Display Change Vendor Centrally

XK05 – Block Vendor Centrally

XK06 –Mark Vendor for Deletion Centrally

XK07 – Change Vendor Account Group

***XK* is centrally (include accounting view and purchasing view), MK* is for purchasing view only and FK* is for accounting view only.

Vendor Master Configuration

Path: IMG > Financial Accounting (New) > Vendor Accounts > Master Data > Preparations for Creating Vendor Master Data

Define Vendor Account Group

In this activity, you can define vendor account group. Basically, vendor account group is used to classify group of supply of enterprise. Vendor account group is a key determination for vendor code and screen field of vendor.

Click “New Entries” to create new vendor account group

Define vendor account group (maximum 4 digits).

Enter name of vendor account group.

In field status, you can set whether which field should be optional field, required field or suppress.

One-Time account, you can activate one-time account. This feature is used in case of company contact business partner who have a business transaction only once. Activate this feature; you don’t have to create a master record for one-time vendor. You create collective master record for one-time vendor. Every time that using one-time vendor, SAP will ask you to enter vendor name, address and bank information. 

Change Message Control for Vendor Master Data

SAP provides standard validation. In this step, you can change type of message whether it should be error message, warning message, note in window or close it.

Create Number Range for Vendor Accounts 

T-Code: XKN1

Vendor number range is used to control range of vendor code. Vendor number range key has 2 digits maximum. To define number range, SAP limits number range only 10 digits (allow both character and numeric).

External Number; activate this feature for manual define vendor code while creating vendor master. Normally, SAP automatically assign vendor by running number internally.

Assign Number Range for Vendor Account Groups

In this step you allocate the number ranges you created in the preceding step to the account groups for vendors. You can use one number range for several account groups.

Vendor Master Table

LFA1 – Vendor Master General Data

LFB1 – Vendor Master Company Level

LFBK – Vendor Master Bank Details

LFBW – Vendor Master Withholding Tax Information (Company Level)

LFB5 – Vendor Master Dunning Information (Company Level)

LFM1 – Vendor Master Purchasing Organization Data

Label : SAP Vendor Master Configuration, SAP Vendor Master, SAP Vendor Table, SAP Vendor Tutorial, SAP Vendor Guide, How to configure vendor master