10-03-2008 10:54 AM
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.
10-03-2008 10:56 AM
Hi
Pls try this code
SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE ( BEGDA >= '1.01.2008' AND BEGDA <= '31-01-2008' ).
10-03-2008 10:56 AM
Hi
Pls try this code
SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE ( BEGDA >= '1.01.2008' AND BEGDA <= '31-01-2008' ).
10-03-2008 10:57 AM
put the range in an internal table and give begda IN s_begda.
Edited by: Midhun Abraham on Oct 3, 2008 11:57 AM
10-03-2008 10:57 AM
Hi,
SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA GE '20080101'
and BEGDA LE '20080131'.
Darren
10-03-2008 10:58 AM
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
10-03-2008 10:58 AM
SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA between '20080101' and '20081231'.
10-03-2008 10:59 AM
SELECT MASSN FROM PA0000 INTO TABLE lt_pa0000 WHERE BEGDA between '01.01.2008' and '31.01.2008'.
10-03-2008 11:00 AM
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.
10-03-2008 12:21 PM