Code tuning on SELECT SINGLE statement

[Former Member]

Hi,

Is there a way to optimize a SINGLE SELECT statement ?

SELECT SINGLE pernr bukrs FROM pa0001
            INTO (it_pernr-pernr,it_pernr-bukrs)
           WHERE pernr = lv_pa9070-pernr
             AND endda GE lv_yhr_py_pdidom-begda
             AND begda LE lv_yhr_py_pdidom-endda.
      APPEND it_pernr.

Thanks in advance for your help.

Thibault

[ThomasZloch]

What do you mean by optimize? Runtime?

If the statement is inside a huge loop, there could be room for improvement.

Please describe the actual problem in detail.

Also look into the ABAP performance forum and .

Thomas

[Former Member]

Yes this is exactly runtime. I'm gonna have a look at that link you sent me

[Jelena_Perfiljeva]

Since Thomas already chimed in... I couldn't help but notice that you've been registered since 2008 and have 101 posts but 0 points. You might want to start contributing yourself and rewarding the answers to your questions that have been helpful. No one likes "leachers", you know...