topic Re: optimoze the code in Application Development and Automation Discussions

optimoze the code

Former Member — Thu, 13 Mar 2008 07:26:10 GMT

hello all,

can i optimize the code.

SELECT * FROM zsbhdr itab

WHERE vdatu GE start_date

AND vdatu LE end_date .

APPEND itab .

CLEAR itab .

ENDSELECT .

Former Member — Thu, 13 Mar 2008 07:29:05 GMT

SELECT * FROM zsbhdr into itab

WHERE vdatu GE start_date

AND vdatu LE end_date .

Former Member — Thu, 13 Mar 2008 07:32:04 GMT

Hi,


SELECT * FROM zsbhdr
into  table itab

WHERE vdatu GE start_date

AND vdatu LE end_date .

Former Member — Thu, 13 Mar 2008 07:33:11 GMT

Try this,

SELECT * FROM zsbhdr

INTO CORRESPONDING FIELDS OF TABLE ITAB[]

WHERE vdatu GE start_date

AND vdatu LE end_date .

Former Member — Thu, 13 Mar 2008 07:38:55 GMT

SELECT * FROM zsbhdr itab INTO TABLE itab[]

WHERE vdatu GE start_date

AND vdatu LE end_date .

Reward if useful

thanks Arjun

Former Member — Thu, 13 Mar 2008 08:35:15 GMT

SELECT * FROM zsbhdr

into table itab

WHERE vdatu >= start_date

AND vdatu <= end_date .

Give as many fields as possible in where condition .