topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 09 Aug 2007 13:30:51 GMT

hai friends,

Can we use SELECT statement in LOOP ... ENDLOOP.

If yes, what about the performance, can it be same.

Re: select statement

Former Member — Thu, 09 Aug 2007 13:33:38 GMT

hi,

we shdn't use SELECT stmt within the loop it will decreases the performance.

Re: select statement

Former Member — Thu, 09 Aug 2007 13:34:20 GMT

Hi,

Dont use the SELECT statement with in the loop it will effect the performance.

It will be better to select the data before using the loop

rgds

harris

Re: select statement

Former Member — Thu, 09 Aug 2007 13:34:21 GMT

You can use, but performance wise it is not preferable.....

You are hitting the database table 'n' number of times if you call it inside a loop. where 'n' is the number of records,

So, write SELECT outside a loop, using FOR ALL ENTRIES.

Regards,

Pavan

Re: select statement

Former Member — Thu, 09 Aug 2007 13:35:26 GMT

Hi,

You can use the Select statment in the LOOP and ENDLOOP. But it is performance issue, so better write the select out of the LOOP and use the READ statment with in the LOOP.

Regards

Sudheer

Re: select statement

Former Member — Thu, 09 Aug 2007 13:35:49 GMT

Sample code........

SELECT EBELN " Purchasing Document Number

ERNAM " Name of Person who Created

" the Object

LIFNR " Vendor's account number

EKGRP " Purchasing group

BEDAT " Purchasing Document Date

FROM EKKO

INTO T_EBELN

WHERE EBELN IN S_EBELN

AND BEDAT IN S_BEDAT.

SELECT OBJECTCLAS " Object Class

OBJECTID " Object value

CHANGENR " Document change number

USERNAME " User name

UDATE " Creation date

FROM CDHDR

INTO TABLE T_CDHDR

FOR ALL ENTRIES IN T_EBELN

WHERE OBJECTID EQ T_EBELN-EBELN

AND UDATE IN S_UDATE

AND TCODE IN ('ME21N','ME22N','ME23N').

Regards,

Pavan

Re: select statement

Former Member — Thu, 09 Aug 2007 13:37:11 GMT

Hi Jay

u can use no syntax error but it is performance issue try to avoid this one

reward points to all helpful answers

kiran.M

Re: select statement

Former Member — Thu, 09 Aug 2007 13:59:10 GMT

its advisable not to use select statement inside he loop , definitely, it ll reduce the performance.

Re: select statement

Former Member — Thu, 09 Aug 2007 14:07:03 GMT

its advisable not to use select statement inside he loop , definitely, it ll reduce the performance.