need comparison operator

[Former Member]

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]

Hi

Pls try this code

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

[Former Member]

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]

Hi,

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

Darren

[naveen_inuganti2]

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]

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

[Former Member]

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

[former_member195383]

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]

i got the answer