Problem to access OB08
I have a problem in below query. i am trying to pick currency rate from table TCURR [OB08] the lastest entry for that currency exchange rate.
but in TCURR, date format is different for eg -
79928974 for 25.10.2007.
but i want lastest date for currency exchange rate.
as the data format is different , after sorting the table , will get latest date as these numbers are in different format.
select SINGLE * from TCURR where gdatu = (latest date on which 0B08 was upated for particular curreny)
and fcurr = vbrk-WAERK
and tcurr = 'INR'.
if sy-subrc = 0.
CURR_RATE = TCURR-UKURS.