Exchnage Rates

[Former Member]

Hi,

We are currently importing exchange rates in to SAP R/3 (ECC6.0) system using idocs of message type exchange_rate. The idocs come in with echange rates every day at 2:30 am in the morning for that particular day.

For eg on the 25th of June at 2:30 am we will get idocs for exchnage rate for that particular day.

However now as per business requirement we will be getting the exchange rate idocs at 3:30 pm in the afternoon with the next days rate (ie one day in advance).

For eg on the 25th of June at 3:30 pm in the afternoon we will get idocs for exchange rates with date 26th June.

My question is that due to this change, do we have change anything in R/3 either in config or anywhere else?

Thanks in advance.

Mick

[Former Member]

Hi,

We are currently importing exchange rates in to SAP R/3 (ECC6.0) system using idocs of message type exchange_rate. The idocs come in with echange rates every day at 2:30 am in the morning for that particular day.

For eg on the 25th of June at 2:30 am we will get idocs for exchnage rate for that particular day.

However now as per business requirement we will be getting the exchange rate idocs at 3:30 pm in the afternoon with the next days rate (ie one day in advance).

For eg on the 25th of June at 3:30 pm in the afternoon we will get idocs for exchange rates with date 26th June.

My question is that due to this change, do we have change anything in R/3 either in config or anywhere else?

Thanks in advance.

Mick

[former_member156446]

when ur getting the exchange rate just use TCURR-GDATU = sy-datum what ever value u have should be the final value.

[Former Member]

Thanks j@y.

A few more details that might help.

As is process:

XI/PI picks up an file at 2:30 am and then passes the data to R/3 as an idoc of message type exchange_rate. The file has a column called Valid_To. This column has todays date. The values from the file, column valid_to are entered in the table TCURR, field GDATU

For eg: on the 25th of June XI receives a file at 2:30 am with the value in the Valid_To column as 25th June, 2009

To be process:

Now as per the new business requirement, XI/PI will pick up the exchange rate file at 3:30 pm in the afternoon everyday. This file will have tommorows date in the valid_to column.

For eg: on the 25th of June XI receives a file at 2:30 am with the value in the Valid_To column as 26th June, 2009. Therefore the exchange rates are applicable from the next day.

The question is do we need to make any changes in R/3 for the idocs to post successfully as they are doing now? Will the system allow the next days date to be entered in the TCURR table in the Valid From field? Or do we need to make some changes.

Mick

Mick

[former_member156446]

Looks like as per your scenario, you are using previous dates value... but I guess that was the business decision to use in such a way. Check with ur Functional team and gather some info. I guess u can add a date ahead to be used in TCURR table as GDATU

[Former Member]

no more replies therefore closing the thread