select query!!

Hi..

Write the select .. and in where condition for the dates ..

datab LE selection screen date

datbi GE selection screen date .

Regards,

GSR.

between is the right clause.

or you may use in...

but here into is missing try to include that.

and if you have an option to give select option for date do that because between clause may decrease your performance.

regards

shiba dutta

If the datab and datbi are inclusive , you can use like below

datab le f_date

datbi ge f_date

otherwise you can use like below,

datab lt f_date

datbi gt f_date

where f_date is the selection date

Hello,

U can check this in the at selection-screen event

If validon between batab and datbi.

If useful reward.

Vasanth

just wanted tp cross check thx a lot!!

Hi Gunjan,

Try with this code.

SELECT KNUMA DATAB DATBI BOSTA ABREX

FROM KONA

INTO TABLE IT_KONA

WHERE VKORG IN S_VKORG

AND VTWEG IN S_VTWEG

AND BONEM IN S_BONEM

AND ( <b>DATAB >= S_VALID-LOW AND DATBI <= S_VALID-HIGH</b> ).

Thanks,

Vinay

Hi,

tables kona.

types : begin of ty,

knuma type kona-knuma,

datab type kona-datab,

datbi type kona-datbi,

bosta type kona-bosta,

abrex type kona-abrex,

end of ty.

data itab type standard table of ty.

select-options : s_vkorg for kona-vkorg,

s_vtweg for kona-vtweg,

s_bonem for kona-bonem.

SELECT knuma datab datbi bosta abrex from table kona into table itab

where vkorg in s_vkorg

and vtweg in s_vtweg and bonem in s_bonem

and datab GE valid on and datbi LE datbi.