04-03-2007 12:02 PM
Hi,
Need to write a select statement to get the records from IHPA table. The condition is to get the records where the System date between Start date and End date.
Pls let me know how to write the same.
Regards,
Venu
04-03-2007 12:08 PM
select * from IHPA inti table i_IHPA
where start date <= sy-datum
and end date >= sy-datum.
Choose the appropriate fields from the tables to replace start and end dates.
Regards,
Amit
04-03-2007 12:08 PM
select * from IHPA inti table i_IHPA
where start date <= sy-datum
and end date >= sy-datum.
Choose the appropriate fields from the tables to replace start and end dates.
Regards,
Amit
04-03-2007 12:09 PM
Hi,
Use the following:
SELECT fields into internal table FROM IHPA where sy-datum BETWEEN start date and ENDDAte.
Here, START DATE and END DATES are te user enterable parameters , ithink.
Regards,
Himanshu
04-03-2007 12:39 PM
Hi Ram,
data : GT_IHPA type table of IHPA .
select * from IHPA into table GT_IHPA where sy-datum between ERDAT and AEDAT.
regards,
Rajesh.
Message was edited by:
RK