Skip to Content
0
Former Member
Jan 02, 2008 at 01:12 PM

RANGE PROBLEM

20 Views

HALLOW

i declare range like below and i get wrong data

what i miss?

eg. i put in table range low 012007 and high 122007

and when i do the select i get data for 2008

Regards

year is input for year.

RANGES: all_year FOR zzepop-period.

CONCATENATE '01' year INTO mon_beg."Create year range

CONCATENATE '12' year INTO mon_end.

all_year-sign = 'I'.

all_year-option = 'BT'.

all_year-low = mon_beg.

all_year-high = mon_end.

APPEND all_year.

SELECT *

FROM (proj_tab_name)

INTO CORRESPONDING FIELDS OF TABLE proj_tab "from year start project until sy-datum

WHERE proj = project

AND period IN all_year.

Regards