topic Re: regarding select statement in Application Development and Automation Discussions

regarding select statement

Former Member — Thu, 31 May 2007 06:05:49 GMT

can i put select statement into the loop statement

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:06:34 GMT

technically, yes you can.

It may not be always gud from performance perspective.

You can fetch all the data into internal table at once.

Or you can use FOR ALL ENTRIES.

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:06:58 GMT

hi,

yes,u can

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:06:59 GMT

Hi,

Yes, but its never adviced...

As it reduces the performance

Regards,

pritha

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:07:03 GMT

Hi,

You can do but its not advisable. As an alternative you can use read statement inside the loop.

Regards,

Ram

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:07:19 GMT

No, u shud not.

Regards

Kannaiah

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:07:41 GMT

yes you can use but it may affect your performance . better to use for all entries statement with different itab.

reagrds

shiba dutta

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:07:44 GMT

Ya why not

Loop at <itab>

select single ..

select...

endloop.

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:10:49 GMT

can u send me one example code

with steps

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:12:17 GMT

hi,

u can loop at read statement.

here is an example,

LOOP AT IT_VBAP INTO WA_VBAP.

READ TABLE IT_VBAK INTO WA_VBAK WITH KEY VBELN = WA_VBAP-VBELN BINARY SEARCH.

IF SY-SUBRC = 0.

*MOVE DATA INTO IT_FINAL.

MOVE: WA_VBAK-VBELN TO WA_FINAL-VBELN,

WA_VBAK-AUGRU TO WA_FINAL-AUGRU,

WA_VBAP-POSNR TO WA_FINAL-POSNR,

WA_VBAP-MATNR TO WA_FINAL-MATNR,

WA_VBAP-ZMENG TO WA_FINAL-ZMENG.

ENDIF.

endloop.

Regards,

pritha

Message was edited by:

Pritha Agrawal

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:14:56 GMT

Hi rajesh

we can use loop in select statement

as follows


LOOP AT ITAB.
SELECT * FROM ZPAVAN_EMP INTO CORRESPONDING FIELDS OF ITAB.

            APPEND ITAB.

            ENDSELECT.

 



            WRITE : / ITAB-EMPNO, ITAB-EMPNAME,ITAB-DEPTNO.

            ENDLOOP.

but it was not advisable it may lead to problem in SAP system so u plz follow this


SELECT * FROM ZPAVAN_EMP INTO CORRESPONDING FIELDS OF ITAB.

            APPEND ITAB.

            ENDSELECT.

 

            LOOP AT ITAB.

            WRITE : / ITAB-EMPNO, ITAB-EMPNAME,ITAB-DEPTNO.

            ENDLOOP.

Rewards if helpfull

Regards

Pavan

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:15:52 GMT

hi,

We should try to avoid writing select statements inside the loop.It decreases the performance of the program as it hits the database as many times you are looping.You can select the data from database table outside the loop and read those tables indide the loop.

instead of this use FORALL ENTRIES.

SELECT * FROM BSAK INTO TABLE T_IBSAK

FOR ALL ENTRIES IN T_IAUG

WHERE BUKRS = T_IAUG-BUKRS

AND AUGDT = T_IAUG-AUGDT

AND AUGBL = T_IAUG-AUGBL

regards

null

Re: regarding select statement

Former Member — Thu, 31 May 2007 06:19:24 GMT

yeah u can but it effects the performance .

so it is better to go for other options