Condition record lookup in SCM and performance

[Former Member]

Folks,

I have a question about the performance with respect to the number of condition records that the system has to search for the following activities

1. Initial location determination for CRM (rule to find the initial location)

2. Rule determination for location and product substitution

3. Condition records for Transportation and Shipment scheduling through CPS (Configurable Process Scheduling)

4. Condition records for third party order processing

For 1. above, we may have about 200000 records. It will based only on one condition table and that will have a maximum of two fields. The initial location determination will be based on product.

For 2. above, we may have about 500000 records for each condition table and there will be three condition tables in the access sequence.

For 3. above, we may not have that many records. My guess would be a maximum of 300000 records for one condition table that will model pick/pack times.

For 4. above, we may have about 100000 records. This is the number of products that are relevant for Third Party order processing.

Are any of these numbers concerning? These are some preliminary numbers based on the current design and they could increase.

In general SAP has mastered the act of condition record lookup and this is a fast process based on conversation with a friend. Can you give your thoughts on this?

Thanks,

Satish

[Former Member]

Satish

This is posted in the wrong forum. Please repost in the GATP forum.

That said, try using exclusive access for all condition tables and avoid using Access Type as Free Keys to improve performance.

Rishi Menon

[Former Member]

Rishi:

Thanks for the response - it is helpful. That forum is low volume and not sure if it would have got any attention. If your experience is otherwise, it will be good to know.

Satish