topic date format in table in Application Development and Automation Discussions

date format in table

prince_isaac — Tue, 13 Nov 2007 16:55:00 GMT

incorrect date format saved thru transaction spro>General settings>Currencies>Enter Exchange rates. date format entered is 98.98.9898 now the system wont allow you to maintain exchange rates without specifying correct date format for the entries. in tables TCURR i cannot get the entries as they are stored in nines compliment. how then can i delete the entries with abap script??

Re: date format in table

Former Member — Tue, 13 Nov 2007 17:01:58 GMT

Hi,

use delete statement on TCURR table.

ex:

delete from TCURR where KURST = <your exchange rate type>.

commit work.

Reward points for helpful answers,

Satish

Message was edited by:

Satish Panakala

Re: date format in table

Former Member — Tue, 13 Nov 2007 17:03:49 GMT

You can use the FM "CONVERSION_EXIT_INVDT_INPUT", to converte a normal date in the date that is used in table TCURR.

I hope it's usefull.

best regards,

Aline.

Re: date format in table

prince_isaac — Thu, 12 Aug 2010 08:42:01 GMT

Had to delete the entry to enable exchange rates to be captured.

regards

Isaac Prince