topic Re: Code tuning on SELECT SINGLE statement in Application Development and Automation Discussions

Code tuning on SELECT SINGLE statement

Former Member — Tue, 29 Jun 2010 14:43:54 GMT

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

Re: Code tuning on SELECT SINGLE statement

ThomasZloch — Tue, 29 Jun 2010 14:47:44 GMT

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

Re: Code tuning on SELECT SINGLE statement

Former Member — Tue, 29 Jun 2010 14:49:22 GMT

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

Re: Code tuning on SELECT SINGLE statement

Jelena_Perfiljeva — Wed, 30 Jun 2010 19:44:43 GMT

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...