topic Re: date GDATU qustion in Application Development and Automation Discussions

date GDATU qustion

Former Member — Thu, 18 Sep 2008 10:47:18 GMT

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

Re: date GDATU qustion

Former Member — Thu, 18 Sep 2008 10:49:34 GMT

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

Re: date GDATU qustion

Former Member — Thu, 18 Sep 2008 10:57:08 GMT

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

Re: date GDATU qustion

Former Member — Thu, 18 Sep 2008 11:12:20 GMT

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

Re: date GDATU qustion

Former Member — Thu, 18 Sep 2008 11:31:34 GMT

Hello

No (-:

In your case

datecur = datecur - 1.

Re: date GDATU qustion

Former Member — Thu, 18 Sep 2008 11:47:05 GMT

Hi karthik ,

i take it from table tcurr.

Regards

Re: date GDATU qustion

Former Member — Thu, 18 Sep 2008 12:21:34 GMT

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.