Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Slow Select Statement from a Custom Field of Custom Table.

Hi Gurus,

Kindly assist me on how to make my code run faster. I made a custom field with 50 characters and include it to a custom field. The program really took a long time in processing the program segment where I'm getting the rows that match the custom field.

here is my pseudocode:

loop at it_tab.

    select zfield into it_tab-zfield from ztable where standard_field eq it_tab-standard_field.

    if it_tab-zfield ne ''.

         select min( standard_date ) into it_tab-standard_date from ztable where zfield eq it_tab-zfield.

          it_tab-standard_date = 1.

    modify it_tab.


clear: it_tab   " I put a breakpoint to this line and the system took more than 5 mins to display the debugger window.

I already put index on our custom field on that custom table yet, the performace does not change.

I hope you can help me with this issue.



Mon Magallanes

Not what you were looking for? View more on this topic or Ask a question