select query

[Former Member]

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.

[Former Member]

Hi

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.

BR

Sree

[Former Member]

HI,

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

Thanks

[Former Member]

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.

BR

Sree

[Former Member]

Hi Ramya,

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

Regards,

Atish

[Former Member]

hi

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

[Former Member]

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

[Former Member]

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.

[Former Member]

hi,

Use For ALL Entries Keyword.

But Keep In Mind That .

Check That First Table Contains Data and Use Where Condition.