topic Re: to select from database table based on date range in Application Development and Automation Discussions

to select from database table based on date range

Former Member — Mon, 16 Jun 2008 05:49:40 GMT

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

regards

arora

Re: to select from database table based on date range

former_member673464 — Mon, 16 Jun 2008 06:01:06 GMT

hi,

You can use the ranges table for your requirement.It is similar to select -option. You have to fill low as lower date , high as high data ,option as 'EQ' and sign as 'I'. You can write select query as

select sum(currency)

from dtab1

......

where date in r_date.

Regards,

Veeresh

Re: to select from database table based on date range

Former Member — Mon, 16 Jun 2008 06:36:29 GMT

i am using

sELECT field1 field2 FROM Ztable INto it_matu

where DATE GE sl_dat-low

AND DATE LE sl_dat-high.

i am getting data in internal table but

say i have twelve records now i want to sum it the both the columns into and use that sum final amount to display

let me know how to use sume in the intrranal tabl do i need to use control statement

how to use the sum for two columns and take into a serperate variable to display

regards

aRora

Re: to select from database table based on date range

Former Member — Tue, 17 Jun 2008 07:41:46 GMT

problem solved got the solution