Skip to Content
avatar image
Former Member

date GDATU qustion

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2008 at 10:49 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.