optimoze the code

[Former Member]

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]

SELECT * FROM zsbhdr into itab

WHERE vdatu GE start_date

AND vdatu LE end_date .

[Former Member]

Hi,

SELECT * FROM zsbhdr
into  table itab

WHERE vdatu GE start_date

AND vdatu LE end_date .

[Former Member]

Try this,

SELECT * FROM zsbhdr

INTO CORRESPONDING FIELDS OF TABLE ITAB[]

WHERE vdatu GE start_date

AND vdatu LE end_date .

[Former Member]

SELECT * FROM zsbhdr itab INTO TABLE itab[]

WHERE vdatu GE start_date

AND vdatu LE end_date .

Reward if useful

thanks Arjun

[Former Member]

SELECT * FROM zsbhdr

into table itab

WHERE vdatu >= start_date

AND vdatu <= end_date .

Give as many fields as possible in where condition .