Changing the Sequence of the Access Sequence for Pricing Condition Type

[Former Member]

Hi Friends,

We have an access sequence to determine the pricing. We have 8 key combinations for the same.

Customer/Plant/Material/Batch

Sales Org/ Dist Ch/ Cust Region/Plant/Material/ Batch

Price List Type/Currency/Plant/Material/ batch

Plant/Material/ Batch

1st 4 is with batch. and 2nd 4 is without batch. At the time of implementation ie., before 8 years the 1st 4 key combinations were used. But now based on the business need we are not using the 1st 4 key combination rather we are using the 2nd 4 which is without batch.

My question is that can we change the access sequence so that while the system fetches the price it need not go through the entire ( 91,02,401 ) records.

If this is possible then

Will there by any impact during viewing of past data?

[Former Member · Accepted solution]

Hi,

There are two options.

1)Change the validity dates for those condition records to earlier date.

2)Usually the sytem checks from top to bottom.If it finds the record in first table then it will return that value and stop searching.

As your not required things are on the top,remove the condition records for them using VK12 T.Code.And maintain the records for what condition tables you are required.

Regards,

Krishna.

[Former Member · Accepted solution]

It is like that only now. On finding the record the system will stop. Here it will not find the record in the 1st 4 sequences as that will force the system to go through all the given records which i want to avoid.

ie., is there any possibility to move the 2nd set of 4 sequences to top.