Skip to Content
Former Member
Jun 16, 2008 at 05:49 AM

to select from database table based on date range



i have a selection screen in which date range is being given

say eg 23/06/07 to 23/12/08

based on this date i want to select data from a ztable

eg i want to select a field amount from table

and three is a field date range on the table

for this particular field i want to select all records for amount field and factual field falling wiithing this date range and sum it


based on date range as in selcetion screen

select amount( field1) factual ( field2) from ztable into it_ztable where date = ?....

please give me code for it and how to sum all values as i will get from the ztable into internal table the two values as fetched from the ztable

please suggest asap