topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Wed, 05 Mar 2008 11:30:13 GMT

Hi,

following is my select query. I dont want the select query inside the loop. Please tell me how can i do this.

loop at gt_tvrot.

select tvro~route

tvro~trazt

tvro~traztd

tvro~tdvzt

tvro~tdvztd

tvro~tdvznd

tvro~fahztd

tvro~distz

tvro~medst

tvrot~bezei

appending table gt_tvro

from tvro join tvrot

on tvro_{route eq tvrot}route

where tvrot~spras eq sy-langu

Thanks.

and tvro~route eq gt_tvrot-route.

endloop.

Re: select query

Former Member — Wed, 05 Mar 2008 11:43:33 GMT

Use the below code

select tvro~route

tvro~trazt

tvro~traztd

tvro~tdvzt

tvro~tdvztd

tvro~tdvznd

tvro~fahztd

tvro~distz

tvro~medst

tvrot~bezei

appending table gt_tvro

*for all entries of gttvrot*_

from tvro join tvrot

on tvro_{route eq tvrot}route

where tvrot~spras eq sy-langu

and tvro~route eq gt_tvrot-route.

If you want further clarity on this, got to SE30, Press TIPS and TRICKS push button on the application tool bar. This will help you a lot.

Sree

Re: select query

Former Member — Wed, 05 Mar 2008 11:48:42 GMT

HI,

I didn't get ur answer can u please clarify. i dont want to write the select query inside the loop.

Thanks

Re: select query

Former Member — Wed, 05 Mar 2008 11:54:53 GMT

Yes if you use "for all entries" then you can write the select query outside the loop.

Please read the related documentation for the "for all entries"

key word. there you can find some examples also.

Sree

Re: select query

Former Member — Wed, 05 Mar 2008 11:55:22 GMT

Hi Ramya,

Instead of using LOOP..ENDLOOP se FOR ALL ENTRIES with select query as told above.

Regards,

Atish

Re: select query

Former Member — Wed, 05 Mar 2008 19:46:45 GMT

For all entries will join the internal tables on a select statement.

but at least one entry should be in itab else select wont take the joining itab.

regards

Jose

Re: select query

Former Member — Thu, 06 Mar 2008 03:58:10 GMT

instaed of LOP put a READ statment then it will be very easy

Re: select query

Former Member — Thu, 06 Mar 2008 04:22:17 GMT

Hi,

You can use for all entries as mentioned above. You need to check if there are any entries in the table mentioned in for all entries. If it is initial the query might give a dump.

Re: select query

Former Member — Thu, 06 Mar 2008 04:58:39 GMT

hi,

Use For ALL Entries Keyword.

But Keep In Mind That .

Check That First Table Contains Data and Use Where Condition.