PLEASE HELP

[Former Member]

hi guys,

i have to develop a object.

1. There is a selection screen of type parameter P_DATE.

2. when i give some date in input say 01-12-2006 it should select all the entries from table TCURR on the condition TCURR-KURST = 'TCL' &

TCURR-GDATU = date month year selected in parameter

As i have given here the month as 12 (december) it should select all the fields in december and go back to JANUARY and select all the fields there and FEBRUARY and select all the fields there AND MARCH, APRIL... so on till NOVEMBER.

IN TCURR-GDATU ===> DATE MONTH AND YEAR SHOULD COME DYNAMICALLY

It should check each day on every month for the condition.

Please help.

ahmed

[suresh_datti]

GDATU ie the effective date for the Exchange Rate is stored as an inverted date in the TCURR table. This makes it almost imposssible for comparison with a SELECT statement. Usually this table doesn't have that many entries.. One option could be to dump the table entries into an internal table & convert the GDATU into sy-datum format using the conversion routine CONVERSION_EXIT_INVDT_INPUT and then compare each entry with the input date.

~Suresh