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.
Testing:
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..
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.
References:
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"
- SAP Managed Tags:
10 Comments
