Select query

[Former Member]

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

[amit_khare]

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

[Former Member]

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

[Former Member]

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