Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Code tuning on SELECT SINGLE statement

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

ThomasZloch
Active Contributor
0 Kudos

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

3 REPLIES 3

ThomasZloch
Active Contributor
0 Kudos

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

0 Kudos

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

Jelena
Active Contributor
0 Kudos

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