Skip to Content
0
Former Member
Dec 26, 2006 at 04:25 AM

select statement

31 Views

hi abapers,

i want to select rows from the db table with month as the selection criteria .

the object is as follows :

parameter : date like sy-datum obligatory .

select * from tcurr into it where gdatu = date

here the date must fall within the month of the selection screen parameters.

ie if date = 26.12.2006, then the month is december and hence i have to retrieve all the rows from the table TCURR based upon the condition that the GDATU field must fall in the month of only december .

i have tried this but it didn't work out .

eg : select * from tcurr where gdatu = '12' .

can anybody can give me a hint .

thanx in advance .

anil