topic Re: select query!! in Application Development and Automation Discussions

select query!!

Former Member — Thu, 11 Jan 2007 11:17:10 GMT

Hi,

i need to select record from kona and the query shud go like this:

SELECT knuma, datab, datbi, bosta and abrex from table kona where vkorg,

vtweg and bonem are equals to values of selection screen and ‘valid on’

value is between datab and datbi.

need to check while writing select query if the selection screen date is between datab and datbi how shall i achieve this?

regards

Gunjan

Message was edited by:

Gunjan Kumar

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:19:17 GMT

Hi,

You cann use the event

At selection-screen on field S_date.

Write the validation code here.

Regards,

Aman

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:21:12 GMT

this is not the validation code..normal select query!!

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:21:32 GMT

Hi..

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

datab LE selection screen date

datbi GE selection screen date .

Regards,

GSR.

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:22:07 GMT

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

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:22:45 GMT

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

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:23:39 GMT

Hello,

U can check this in the at selection-screen event

If validon between batab and datbi.

If useful reward.

Vasanth

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:24:42 GMT

just wanted tp cross check thx a lot!!

Re: select query!!

Former Member — Thu, 11 Jan 2007 11:25:32 GMT

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

Re: select query!!

jayanthi_jayaraman — Thu, 11 Jan 2007 11:27:20 GMT

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.