topic Re: Where condition. in Application Development and Automation Discussions

Where condition.

Former Member — Fri, 22 Aug 2008 11:39:13 GMT

Hi friends,

can any one tell me how to give the where condtion.

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat = DATE1 AND DATE2.

actually DATE1 & DATE2 are 2 variable and iam geting them values from 01.01.2008 To 30.03.2008.

but its showing me some error.

can any one tell me where iam wrong.

Regards,

Priyanka.

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:42:37 GMT

Hi,

We need to use BETWEEN in WHERE clause.

plz try this way.

DATA: LOW TYPE I VALUE 200,

HIGH TYPE I VALUE 250.

SELECT * FROM SAPLANE INTO WA_SAPLANE

WHERE SEATSMAX BETWEEN LOW AND HIGH.

select mandt
mblnr
mjahr
budat
into table it_mkpf from mkpf
where budat BETWEEN DATE1 AND DATE2.


where budat GT Date1
and    budat LT Date2

even better option is to declare date as a select-option.

select-options: s_date for mkpf-budat .

intializtion.
s_date-sign = 'I'.
s_date-option = 'BT'.
s_date-low = '01.01.2008'.
s_date-low = '30.03.2008'.
append s_date.

select mandt
mblnr
mjahr
budat
into table it_mkpf from mkpf
where budat IN s_date.

hope this helps.

thanx,

dhanashri.

Edited by: Dhanashri Pawar on Aug 22, 2008 1:42 PM

Edited by: Dhanashri Pawar on Aug 22, 2008 1:51 PM

Edited by: Dhanashri Pawar on Aug 22, 2008 1:53 PM

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:43:30 GMT

hi priyanka jain

Use Between option in select query

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat BETWEEN DATE1 AND DATE2.

Hope it will help you

Regards

Deva

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:43:30 GMT

it may be

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat = DATE1 and

budat = AND DATE2.

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat >= DATE1 and

budat <= AND DATE2.

missing part is budat <=

Aditya

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:43:34 GMT

hi..

try

WHERE ( field >= start_date and filed <= end_date )

regards

vivek

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:43:41 GMT

i´m not sure i get your requirement but i suppose you need following solution.


select mandt
mblnr
mjahr
budat
into table it_mkpf from mkpf
where budat GT Date1
and    budat LT Date2.

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:43:46 GMT

it may be

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat = DATE1 and

budat = AND DATE2.

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat >= DATE1 and

budat <= AND DATE2.

missing part is budat <=

Aditya

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:43:56 GMT

where budat between date1 and date 2

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:44:25 GMT

Hi priyanka jain

try this

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat = DATE1 AND DATE2.

where budat between DATE1 AND DATE2.

Regards,

Sreenivas Reddy

Edited by: Sreenivas Reddy Dommata on Aug 22, 2008 1:46 PM

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:45:15 GMT

select-options: date for sy-datum.

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat in date.

Re: Where condition.

Former Member — Fri, 22 Aug 2008 11:48:36 GMT

solution.

take the varialble in a select option with out display.

declaration:

select-option: s_date for mkpf-budat no display.

intializtion.

s_date-sign = 'I'.

s_date-option = 'BT'.

s_date-low = '01.01.2008'.

s_date-low = '30.03.2008'.

Append s_date.

select mandt

mblnr

mjahr

budat

into table it_mkpf from mkpf

where budat in s_date.

************************************************

u can append the s_date internal table in intializtion if u want o hard code it.

else.

u can append acccording to logic by giving condition in codings.