date GDATU qustion

[Former Member]

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

[Former Member]

to make the fetch records sequential add ORDER BY gdatu at the end of where clause.

[Former Member]

to make the fetch records sequential add ORDER BY gdatu at the end of where clause.

[Former Member]

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

[Former Member]

from where your getting this value ??? Is it from selection screen or from a table fetch.

[Former Member]

Hello

No (-:

In your case

datecur = datecur - 1.

[Former Member]

Hi karthik ,

i take it from table tcurr.

Regards

[Former Member]

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.