How to use Reserved or Additional Fields in SAP

SAP provides a set of additional fields in in both the Customer Master records and Material Master records. These fields also exist in the Sales Order documents and are copied over during sales order entry. These fields are not assigned to any standard SAP functionality but are provided to use for your own specific business purposes.

Customer Master – General Data (Additional Fields)

There are a total of ten fields available in the Customer Master: General Data area which are located in the KNA1 table. You will notice that fields 1-5 are two character fields while fields 6-10 are all three character fields.

To access the additional fields in the Customer Master: General Data screen, goto transaction code VD03 – Sales and Distribution and enter a customer number, sales organization, distribution channel and division. Press Enter. Goto the menu “Extras –> Additional Data”.

Table: KNA1 – General Data in Customer Master

Field Data Type Short Description Check Table Maintenance Views
KATR1 CHAR 2 Attribute 1 TVK1 V_TVK1
KATR2 CHAR 2 Attribute 2 TVK2 V_TVK2
KATR3 CHAR 2 Attribute 3 TVK3 V_TVK3
KATR4 CHAR 2 Attribute 4 TVK4 V_TVK4
KATR5 CHAR 2 Attribute 5 TVK5 V_TVK5
KATR6 CHAR 3 Attribute 6 TVK6 V_TVK6
KATR7 CHAR 3 Attribute 7 TVK7 V_TVK7
KATR8 CHAR 3 Attribute 8 TVK8 V_TVK8
KATR9 CHAR 3 Attribute 9 TVK9 V_TVK9
KATR10 CHAR 3 Attribute 10 TVK0 V_TVK0

The check tables are TVK0 – TVK9 and the corresponding maintenance views are V_TVK0 – V_TVK9.

Customer Master – Sales Area Data (Additional Fields)

There are a total of five fields available in the Customer Master: Sales Area Data screen which are located in the KNVV table. All five fields are three character fields.

To access these fields goto transaction code VD03 – Sales and Distribution and enter a customer number, sales organization, distribution channel and division. Press Enter. Click on the [Sales Area Data] button to goto the Customer Master: Sales Area Data screen. Click the menu “Extras –> Additional Data” to see the sales area additional fields.

Table: KNVV – Customer Master Sales Data

Field Data Type Short Description Check Table Maintenance Views
KVGR1 CHAR 3 Customer group 1 TVV1 V_TVV1
KVGR2 CHAR 3 Customer group 2 TVV2 V_TVV2
KVGR3 CHAR 3 Customer group 3 TVV3 V_TVV3
KVGR4 CHAR 3 Customer group 4 TVV4 V_TVV4
KVGR5 CHAR 3 Customer group 5 TVV5 V_TVV5

The check tables are TVV1 – TVV5 and the corresponding maintenance views are V_TVV1 – V_TVV5. These fields are also included in the the following tables and their values are copied from the customer master record of the Sold-To Party and used in the sales order process. See below for more information.

VBAK Sales Document: Header Data
VBRP Billing Document: Item Data
LIPS SD Document: Delivery: Item Data
KUAGVZ Customer Modifications: Sold-to Party View of Customer Master

Material Master (Additional fields)

There are also additional fields available in the Material Master table MVKE which can be configured for your individual business requirements.

Table: MVKE – Sales Data for Material

Field Data Type Short Description Check Table Maintenance Views
MVGR1 CHAR 3 Material group 1 TVM1 V_TVM1
MVGR2 CHAR 3 Material group 2 TVM2 V_TVM2
MVGR3 CHAR 3 Material group 3 TVM3 V_TVM3
MVGR4 CHAR 3 Material group 4 TVM4 V_TVM4
MVGR5 CHAR 3 Material group 5 TVM5 V_TVM5

The check tables are TVM1 – TVM5 and the corresponding maintenance views are V_TVM1 – V_TVM5. These fields are also included in the the following tables and values are copied from the material master record and used in the sales and distribution transaction. See below for more information.

VBAP Sales Document: Item Data
VBRP Billing Document: Item Data
LIPS SD Document: Delivery: Item Data
MAAPV Material Master View: Sales Screen 1

Sales Order (Additional fields)

The additional field values that are in the Customer Master record in KNVV-KVGR1…5 are copied to the Sales Order header records in the table VBAK – Sales Document: Header Data.

Table: VBAK – Sales Document: Header Data

Field Data Type Short Description Check Table Maintenance Views
KVGR1 CHAR 3 Customer group 1 TVM1 V_TVM1
KVGR2 CHAR 3 Customer group 2 TVM2 V_TVM2
KVGR3 CHAR 3 Customer group 3 TVM3 V_TVM3
KVGR4 CHAR 3 Customer group 4 TVM4 V_TVM4
KVGR5 CHAR 3 Customer group 5 TVM5 V_TVM5

The additional field values that are in the Material Master record MVKE-MVGR1…5 are copied to the Sales Order item data records in the table VBAP – Sales Document: Item Data.

Table: VBAP – Sales Document: Item Data

Field Data Type Short Description Check Table Maintenance Views
MVGR1 CHAR 3 Material group 1 TVM1 V_TVM1
MVGR2 CHAR 3 Material group 2 TVM2 V_TVM2
MVGR3 CHAR 3 Material group 3 TVM3 V_TVM3
MVGR4 CHAR 3 Material group 4 TVM4 V_TVM4
MVGR5 CHAR 3 Material group 5 TVM5 V_TVM5

To get to the additional fields in the sales document, goto Header –> Additional data or Item –> Additional data.

How to change the Descriptions of Additional Fields

To change the short descriptions of additional fields that appear on the screen to your own requirements, use the following steps:

  1. Place your cursor on the desired field and press F1. Click on the [Technical details] button and copy the Data Element value.
  2. Enter transaction CMOD – Project Management which can also be found on th SAP menu Tools –> ABAB Workbench –> Utilities –> Enhancements –> Project Management
  3. Once in the Project Management screen, click on the menu Goto –> Text enhancements –> Keywords –> Change
  4. Enter Data Element – KATR0…9 and change the descriptions from “Attribute0…9” to the desired text.
  5. Save the changes and create a transport for the changes as prompted.

How to Add Valid Values to Additional Fields

You can add valid values to the additional fields by using the transaction code SM30 – Call View Maintenance. Follow these simple steps to add valid values:

  1. Enter transaction cdoe SM30 – Call View Maintenance.
  2. Enter the maintenance Table/View: V_TVK0…9 and click on the [Maintain] button.
  3. Enter the values that are to be valid and click the [Save] button.
  4. Press the [Transport] button to create a transport to move the changes downstream in your SAP environment.

Special Note

The valid values are stored in the check tables TVKO…9 while the changes are made using the corresponding maintenance view tables V_TVK0…9.

Leave a Reply

Your email address will not be published. Required fields are marked *

*