cancel
Showing results for 
Search instead for 
Did you mean: 

Condition Index

Former Member
0 Kudos

What is meant by condition index, how we configured in you project? with Exanple and T.code

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member227476
Active Contributor
0 Kudos

dear RAJA

Condition Index:

By using condition Index for particular condition type we can maintain condition records. (Maintain condition record means, creation, change, setting deletion flag, copying etc)

Together with “condition update” we can restrict the usage of the condition type during sales order processing Ex: per particular sales order (3 or 4) or based on total condition value

Configuration setting for condition index:

Like pricing procedure we have to create condition table

Path:

 IMG

 SD

 Basic functions

 pricing

 maintain condition index

 maintain condition table of index

--Go to create mode (it will be change mode)

--Specify table number (ex: 890)

--Choose KUNNR (customer no.)

--Choose MATNR (material no.)

--Click on generate icon

--Click on local object

Activate condition Index:

System by default activates condition index

Activate and save it.

Change condition index:

Choose condition type K007, copy it rename it as Z007 (in V/06)

Check condition index and condition update (on master data section)

Save it and exit.

--Go to V/03 and create condition table with KUNNR and MATNR

--Go to V/07, go to new entries and create access sequence and assign our condition table that e define in previous step

--Go to V/06, chose our condition type Z007 and assign our access sequence to Z007

--Save it

--Go to VK12, select condition table

--Click on select using index

--Maintain selection criteria and click on execute button

--Change the values, save the condition records

rewards if it helps

siva

Former Member
0 Kudos

Suppose you want to know is there a condition record for condition type PR00 which gives data about Customer / Material / Distibution channel?

How will you search ? Will you always go to IMG to find out the condtion table?

For this reason a condition index is provided.

A condition index first tells you whether you can search condition records for condition type PR00.You can search the records for PR00 only if " Condition Index" field in the condition type PR00 ( VOV8) is activated.

Reward points if useful

Regards

Former Member
0 Kudos

Chk the following link:

https://forums.sdn.sap.com/click.jspa?searchID=4774296&messageID=3962335

Condition Index:

· It can be created for particular condition type to maintain condition records.

· When checked this specifies whether the system updates one or more condition indices when maintaining condition records.

· This makes it possible to list or maintain condition records independently of condition type and condition table.

Condition Update:

· Together with condition index, this field when checked allows to restrict the usage of the condition type for limited sales orders or for particular condition value.

Reward points if helpful.

Regards

AK

Manoj_Mahajan78
Active Contributor
0 Kudos

Raja,

Creating an Index

Creating a condition index is similar to creating a condition table. In Customizing for Sales, you select the combination of fields that you want in the index key. The system automatically proposes a list of permitted fields to choose from. The fields you specify for the key can have a maximum combined length of 100 characters. Further information on creating an index can be found in the IMG (Implementation Guide).

Reorganizing an Index

Reorganization means updating an index with current data. The following are examples of when this might be required.

After you create a new index and generate it, you want to fill the index with the current data in your system. (This also applies if you choose to activate one of the standard condition indexes).

After you specify that condition indexes should be updated for a particular condition type, you want to fill the indexes with the corresponding condition records that already exist.

Please note that since the system has to read all the relevant condition records, reorganization is automatically submitted as a background task.

Activating an Index

The activation function displays a list of all available condition indexes and indicates which are active. The system can use a condition index only when it is activated. Before you can use the indexes that are delivered in the standard version, you must first activate them in Customizing for Sales. Some indices are activated automatically during generation. In addition, you must specify one of the following index updating requirements for each condition index:

Requirement 1: The index is updated when the user provides data for all fields in the index

Requirement 2: The index is updated when the user provides data for at least the first index field

Controlling Index Update by Condition Type

You can specify for each condition type whether or not the system updates the condition indexes when you post condition records. In cases where updating condition indexes may not be necessary - for example, with freight- and tax-related condition records - you can leave the condition index indicator blank.

Selecting Condition Records Using an Index

After you have defined a condition index and the system has updated it with current data, you can use it to search condition records.

Procedure

To select condition records using an index:

Choose Logistics ® Sales and Distribution ® Master Data from the main menu.

Choose Conditions ® Select using index and specify whether you want to change or display condition records.

A dialog box displays the condition indexes that are currently available.

Select the condition index you want to use and choose ENTER.

You reach the screen where you enter selection criteria.

Enter your selection criteria and choose Execute.

The system displays a list of the condition records by condition type for the selection criteria you entered.

REWARD IF U FINDS THIS AS USEFUL..

Regds

MM

Former Member
0 Kudos

Hi Raja,

CONDITON INDEX:

You can create and use condition indices. You can use these indices to display, change and create condition records with reference. This transaction can include condition records with several condition types and tables. For example, you can use a condition index if you want to see all condition records that apply to a particular product regardless of whether the records are prices or discounts. In this case, you can use one of the standard condition indexes. Or you may want to see a list of condition records that contain a particular sales deal and a material from a user-specified list of products. To display this information, you can create your own condition index.

Creating an Index

Creating a condition index is similar to creating a condition table. In Customizing for Sales, you select the combination of fields that you want in the index key. The system automatically proposes a list of permitted fields to choose from. The fields you specify for the key can have a maximum combined length of 100 characters. Further information on creating an index can be found in the IMG (Implementation Guide).

Reorganizing an Index

Reorganization means updating an index with current data. The following are examples of when this might be required.

After you create a new index and generate it, you want to fill the index with the current data in your system. (This also applies if you choose to activate one of the standard condition indexes).

After you specify that condition indexes should be updated for a particular condition type, you want to fill the indexes with the corresponding condition records that already exist.

Please note that since the system has to read all the relevant condition records, reorganization is automatically submitted as a background task.

Activating an Index

The activation function displays a list of all available condition indexes and indicates which are active. The system can use a condition index only when it is activated. Before you can use the indexes that are delivered in the standard version, you must first activate them in Customizing for Sales. Some indices are activated automatically during generation. In addition, you must specify one of the following index updating requirements for each condition index:

Requirement 1: The index is updated when the user provides data for all fields in the index

Requirement 2: The index is updated when the user provides data for at least the first index field

Controlling Index Update by Condition Type

You can specify for each condition type whether or not the system updates the condition indexes when you post condition records. In cases where updating condition indexes may not be necessary - for example, with freight- and tax-related condition records - you can leave the condition index indicator blank.

Selecting Condition Records Using an Index

After you have defined a condition index and the system has updated it with current data, you can use it to search condition records.

Procedure

To select condition records using an index:

Choose Logistics ® Sales and Distribution ® Master Data from the main menu.

Choose Conditions ® Select using index and specify whether you want to change or display condition records.

A dialog box displays the condition indexes that are currently available.

Select the condition index you want to use and choose ENTER.

You reach the screen where you enter selection criteria.

Enter your selection criteria and choose Execute.

The system displays a list of the condition records by condition type for the selection criteria you entered.

Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula