Master data

Master Data:

Master data is a pool of data that is going to be centrally in the system and that is available for relevant documents when ever the want to access master data.

Customer master: The customer master record is the basis for all sales transactions as well as deliveries and

payments. It maintains the details of the customer in the form of master data. Every customer master is made up with three (3) sections:

(A) General data [KNA1 – Table]

(B) Company code data [KNB1 – Table]

(C) Sales area data [KNVV – Table]

The customer master partner functions captured into KNPA – Table

The customer master shipping details captured into KNPS – Table

VD01 is the customer record for sales view creation.

XD01 is the central customer master record creation with company code data.

General data section: In general data section data about the customer’s personal details like name, address, and telephone numbers is maintained. The customer number, not by the company code or sales area, only identifies this data.

Important fields:

KUNNR = Customer number

LAND1 = Country key

NAME1 = Name

NAME2 = Name

ORT1 = City

ANRED = Title

STCEG = VAT registration number

Company code data section: 

It is only of interest to the accounting department. It includes information on insurance or account management. This data applies to only one company code. In company code data section data about the reconciliation account number, terms of payment, interest calculation indicator, etc that is related to financial accounting maintained.

Important fields:

AKONT = Reconciliation account number

ZTERM = Payment terms

Sales area data section: In sales area data section data about the customer sales area like sales, shipping, billing, etc data maintained. It is only of interest to the SD area. It includes the data on pricing or shipping. This data only applies to one sales area and therefore is dependent on the sales structure (sales organization, distribution channel,and division) You would not have different customer numbers if your customer is serviced by more than one company code. Nor would you have different customer numbers if your customer is serviced by more than one sales organization.

Important fields: 

VKORG = Sales organization

VTWEG = Distribution Channel

SPART = Division

KALKS = Pricing procedure

KDGRP = Customer group

KONDA = Pricing group

PLTYP = Price list type

INCO1 & 2 = Incoterms

LPRIO = Delivery priority

VSBED = Shipping conditions

WAERS = Currency

KKBER = Credit control area

Account group: FI/CO consultants define account groups for each and every partner function. By using this account group we can control customer master data by changing or assigning field status to each and every field.As every customer master is made up with number of fields. Depending upon the partner function and transaction we assign or change field status to a particular field. Depending upon the field status system prevents the particular field in the customer master while maintaining the customer master data.

The account group defines what fields are available in the customer master records. A sold – to – party only needs sales relevant data. However, a sold – to – party can also be created as all the partner functions. A ship – to – party needs only shipping relevant data, such as unloading points and so on. A payer is the individual or company who settles the invoices for a service or for delivered goods. The bill – to – party need only have the basic data such as address and output fields.

SAP Table                       Field name                                       Description

RF02D                               KUNNR                                              Customer number

RF02D                               VKORG                                              Sales organization 

RF02D                               VTWEG                                              Distribution channel

RF02D                               SPART                                                Division

KNVV                               BZIRK                                                Sales district

KNVV                               VKBUR                                              Sales office 

KNVV                               VKGRP                                               Sales group

KNVV                               KDGRP                                               Customer group

KNVV                               KLABC                                               ABC classification

KNVV                               KONDA                                              Price group 

KNVV                               PLTYP                                                Price list type

KNA1                                BRSCH                                              Industry

KNA1                                BRAN1                                              Industry code

KNA1                                KUKLA                                             Customer classification 

KNVV                               KVGR1                                              Additional data customer group

KNVV                               KVGR2                                              Additional data customer group 

KNVV                               KVGR3                                              Additional data customer group

KNVV                               KVGR4                                              Additional data customer group   

KNVV                               KVGR5                                              Additional data customer group

Partner functions:

In the business every partner while performing business transactions they have to fulfill certain

mandatory functions. They are:

Sold – to – party

Ship – to – party

Bill – to – party

Payer

Standard account group             Partner functions                      Description

0001                                                Sold – to – party                     Who placed the order

0002                                             Ship – to – party                     Who receives the order          0003                                              Bill – to – party                      Who receives the invoice                  0004                                             Payer                                           Who settles the bill