topic Select query in Application Development and Automation Discussions

Select query

Former Member — Tue, 03 Apr 2007 11:02:55 GMT

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

Re: Select query

amit_khare — Tue, 03 Apr 2007 11:08:12 GMT

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

Re: Select query

Former Member — Tue, 03 Apr 2007 11:09:40 GMT

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

Re: Select query

Former Member — Tue, 03 Apr 2007 11:39:25 GMT

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: