Using the SQL Trace, find out which index (if any) is being used. Index 4 on BKPF is AWTYP, AWKEY, and AWSYS. If you specify all these values, then the database read may use this index. It seems likely, however, that it will be using the primary index. One way around this will be to use database hints, as suggested in OSS Note: 129385. This site gives excellent advice on the use of hints. http://www.intelligenterp.com/columns/archive/abap4.jhtml
Dig Deeper on SAP ABAP
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.