topic Re: need comparison operator in Application Development and Automation Discussions

need comparison operator

Former Member — Fri, 03 Oct 2008 09:54:19 GMT

Dear All,

how to correct the below code..

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA = '1.01.2008' BT '31-01-2008'.

Regards,

Thiru.

Former Member — Fri, 03 Oct 2008 09:56:36 GMT

Pls try this code

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE ( BEGDA >= '1.01.2008' AND BEGDA <= '31-01-2008' ).

Former Member — Fri, 03 Oct 2008 09:57:14 GMT

put the range in an internal table and give begda IN s_begda.

Edited by: Midhun Abraham on Oct 3, 2008 11:57 AM

Former Member — Fri, 03 Oct 2008 09:57:34 GMT

Hi,

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA  GE '20080101' 
  and      BEGDA  LE  '20080131'.

Darren

naveen_inuganti2 — Fri, 03 Oct 2008 09:58:21 GMT

Hi..,

BETWEEN , AND statements meets your requirement.

Check this..,

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA between 'date1' and 'date2'.

Thanks,

Naveen.I

Former Member — Fri, 03 Oct 2008 09:58:29 GMT

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA between '20080101' and '20081231'.

Former Member — Fri, 03 Oct 2008 09:59:15 GMT

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA between '01.01.2008' and '31.01.2008'.

former_member195383 — Fri, 03 Oct 2008 10:00:18 GMT

Hi Make use of a Rangeobject for it. Assign the higher limit and lower limit to the Range ..and use the same in select query..

RANGES ra_smpl FOR PA0000-BEGDA.

ra_smpl-low = '01. 02. 2008'.

ra_smpl-low = '01. 03. 2008'.

ra_smpl-option = 'BT'.

ra_smpl-sign = 'I'.

APPEND ra_smpl.

SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA IN ra_smpl.

Former Member — Fri, 03 Oct 2008 11:21:12 GMT

i got the answer