09-18-2008 11:47 AM
Hi,
i do this select and i wont to ask if gdatu is sequential,
i.e. if i have date
e.g.
date gdatu
1.1.2008 7000001
2.1.2008 7000002
3.1.2008 7000003
4.1.2008 7000004
Regards
09-18-2008 11:49 AM
to make the fetch records sequential add ORDER BY gdatu at the end of where clause.
09-18-2008 11:49 AM
to make the fetch records sequential add ORDER BY gdatu at the end of where clause.
09-18-2008 11:57 AM
Hi karthik,
Thanks i do it like this,
its o.k.?
ukurs = ''.
WHILE ukurs IS INITIAL.
SELECT SINGLE ukurs
FROM tcurr
INTO ukurs
WHERE kurst = '1002' AND
fcurr = wa_dp-currency AND
tcurr = 'USD0' AND
gdatu = datecur.
datecur = datecur + 1.
ENDWHILE.
Regards
09-18-2008 12:12 PM
from where your getting this value ??? Is it from selection screen or from a table fetch.
09-18-2008 12:31 PM
09-18-2008 12:47 PM
09-18-2008 1:21 PM
data : tcurr type TCURR.
SELECT *
FROM tcurr
INTO tcurr
WHERE kurst = '1002' AND
fcurr = wa_dp-currency AND
tcurr = 'USD0' AND
gdatu ge datecur
order by tcurr.
if sy-subrc eq 0.
exit.
endif.
endselect.