Hello Mr.R.Gopal,
Optimize Access Sequence helps in following phase.
Improved performance by using prestep for accesses.
To improve performance, you can optimize the accesses to a condition type by having the system carry out a prestep:
You use the prestep to determine whether the system should first only search for condition records using the document header data. If the search is unsuccessful, then this access is not used to search from the individual items.
The prestep can only be used for accesses with header and item data.
The greater the average number of items in a document, the more useful prestep becomes.
The less likely it is that you will find a valid condition record, the more useful it is to use prestep (see the following example).
Example
In pricing, you use a customer-material discount. The condition records you create are based on customer data from the document header and material data from each document item. The discount is only valid for 2% of your customers, however. Normally, this would mean that the system would needlessly search through every available item for 98% of your customers. In this case, prestep would improve system performance.
Regards
Sadanand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.