Skip to Content
Author's profile photo Dibyendu Patra

Search / Change / Display Condition record by using Condition Index

In MEK2/MEK3/MEK32, We can Create / Change / Display the condition record by using the Key combination. Then key combination works as per access sequence for the condition type. There is one more procedure where you can change / display the condition records by using the condition index. The procedure is quite same as key combination, but this is an excrescent feature beside of key combination.

Before using the Condition index, you need to know about the Condition Index and how to configure the condition index from IMG activity.

Note: Condition index is well applicable for SAP SD users, for these condition records which are created from VK11/VK12.


Condition Index:


Condition Index is used to search (along with modify) condition record with its own earmarked selection field. As per your selection field, system will display all condition records with the aid of condition index. In MEK2/MEK3/MEK32, you can also continue without entering a condition type. System will fetch the condition record with regards to all condition types.

You need to do below configurations to use a condition index.

  • Change Condition Types
  • Define Permitted Fields
  • Edit Condition Index Tables
  • Activate Condition Index Tables
  • Rebuild Condition Index Tables
  • Define Overviews
  • Assign Overviews

You can find these above configuration in the IMG path : SPRO-Materials Management-Purchasing-Conditions-Configure Condition Index.


==>Change Condition Types


The first option is to configure the condition type. All condition types will be configured as per pricing procedure in your system [which you have already created from M/06 {explained in this blog Pricing procedure Steps and Details in SAP MM}]. You just need to allow the condition index for the condition type here. Although you can change other things for the particular condition type from this configuration path. After execute the option, double click on your condition type which you want to activate the condition index then just tick the option Condition Index as below:


Save you entry and go back to the IMG activity.


==>Define Permitted Fields


The second option is to configure the permitted fields. It is quite same as field catalog for condition table. You also need to add your entry to use the field for condition index. These fields will be used as selection fields for condition index. Some fields are already entered by SAP. You can see them by executing the IMG activity. If you need an extra field, then you can add the entry by clicking the option “New Entry”. You just be sure that the field should exist in the structure KOMK and KOMP and KOMGF. By pressing F4, you will get the list of all fields, you need to choose one of them. Add the necessary field as per your requirement. I have added WERKS- Plant field in this section.


Save you entry and go back to the IMG activity.


==>Edit Condition Index Tables


In this activity, you need to configure the condition index table. It is exactly same as create condition table (to get an idea, please have a look into the Blog Post , Condition table portion). As same as also here, you need to select the field as per your requirement and generate the condition index table.


Save your entry and put it on appropriate package for further transport it to other client.


==>Activate Condition Index Tables


In this step, you will confirm the condition index table is activated to update the condition index. System will tick the “Update condition index” tick option by default. If required you can deactivate later. Also you need to specify a Condition Index Requirement as required. You will find two options as “001 – All index fields must be filled” and “002 – Only the first index field must be filled”. This field is specified to control when the index is updated.


Save you entry and go back to the IMG activity.


==>Rebuild Condition Index Tables


If you are using your own condition table index that means if you have create a new condition index table, then you need to run the Rebuild Condition Index Tables. By running the activity, system will create condition index for the existing condition records. It is essential if you are using some additional condition index table. So in my case, I need to run that because I have added an extra field as Plant. Execute the t-code and enter the data as below :


Choose the Application as M, M indicates the function used for Purchasing. Enter the Condition index as 936 (new condition index table) and enter the date as current date. Then execute the operation. System will create a background job to update the condition index update.


==>Define Overviews


In this step, you can define the overview for a condition index. the overview will define the view of several condition records although with having different different condition types. You can create an overview with a four digit numerical key and you need to assign a screen number to each view.

Generally, you do not need to create a new overview, you may can continue with existing.If needed, you can create your own.


==>Assign Overviews


In this step, you need to specify an overview to view the condition records. That means you need to specify the overview in which sequence the condition index’s views will be displayed. Here, you can create more than one view, tabs will be appeared in the overview screen and you can switch it by selecting the views.

I have assigned two views for this condition index.


Mark one view as initial view. if you will do not maintain the tick option, system will take one view as default automatically.




Now we are ready to use the condition index. Go to MEK32 and just click on the “Select Using Index” as below:


Then select the condition index (table) as per your requirement and press continue.. You can see the selection screen as per your assigned condition index table.


Here give your entire data like as plant and vendor, then press execute. Your all condition records will be available with regards to the selection parameter.

Here, you will find all these option to modify the condition record..

2015-01-05 21_20_16-Change Discount (ZCAH) _ Overview.png

It is the view of the validity periods (as I have selected this view as initial view in the activity Assign Overviews), you can switch the view easily by clicking Term of payment.

2015-01-05 21_24_00-Change Discount (ZCAH) _ Overview.png



Condition Index – Pricing and Conditions (SD-BF-PR) – SAP Library

Changing Time-Dep. Conditions Collectively (Condition Index) – Purchasing (MM-PUR) – SAP Library

Configure Condition Index – Purchasing – SAP Library


Some useful SAP OSS notes :

1055925 – Condition index reorganization not carried out

356662 – Reoroganizatn. condition index: SAPSQL_ARRAY_INSERT_DUPREC

323731 – Condition index on sales deal does not function

438386 – Condition index for application ‘F’ (freight conditions)

502673 – No condition information for selection via secondary index

135375 – Upd. termination during update of condition index

370951 – Condition maintenance: VK351 “Assign overviews”

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi Dev

      We have same functionality in SD as well and this is really useful tool. Thanks for sharing.


      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Hi all ;

      It is generally used in sd module to increase performance. Can you explain that your idea to implement indexes in document ?


      M.Ozgur Unal

      Author's profile photo Nassar fathy
      Nassar fathy

      Hi Dev.

      nice document thanks for sharing



      Author's profile photo Former Member
      Former Member


      Yes, It's a really nice functionality and been used in SD module too.

      Thanks for sharing across.


      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Great document dear 🙂



      Author's profile photo Rohtas Sharma
      Rohtas Sharma

      Nice Document

      Thanks for sharing

      Author's profile photo Former Member
      Former Member

      Nice Dev. But please let us know the use of it or why did you thought of using it. I mean the purpose of business.

      Author's profile photo Dibyendu Patra
      Dibyendu Patra
      Blog Post Author

      Its an extra facility to search / modify / display condition record instead of using key combination (condition table). You need to enter a condition type to using the key combination but condition index will enable you to search condition record without entering the condition type in MEK2/MEK3/MEK32.

      Author's profile photo venu gopal
      venu gopal

      Nice document 🙂

      But one doubt please tell me how we can activate condition table index ?

      And define permitted field values 

      Author's profile photo Former Member
      Former Member

      I am your fan Dibyendu Patraji, well executed document and it's a good startup but need

      more detailed manner i.e.,topic like condition table index. Kindly consider its my suggestion

      to addon the document.