Hi Friends,

[Former Member]

Let me explain the process of exchange rate update in SAP R3 and the

change expected:

Current Process of updating exchange rate in SAP system:

We are using a custom program (tcode: ZFIGL_FXRATE) in SAP R3 to fetch the

currency wise exchange rate information from our group URL. The program

refers to link given below, which provides currency wise exchange rate in

.TXT format, that prompts the user to save the file on the user’s system.

This .TXT file (saved in users system) is then referred by the program to

update exchange rate in SAP table TCURR (this rate is used for document

posting).

http://masterdata-reports.abb.com/ReportServerAnon/Default.aspx?/ABB%20Master%20Data/Public/FX/FXDai...

This activity of running the custom program/transaction in R3 is currently

done manually.

Requirement and challenges:

There is a requirement to run this program in background for the purpose

of automating the process. With exchange rate residing in the above link,

the R3 program can not be run in background. Generally any program which

runs in background runs at application server level i.e. Unix. If any code

is dealing with GUI (Local Machine, as it is happening in this case) and

run in background, it goes for dump as the Program running at application

server on Unix does not understand the GUI running on windows. So,

technically current program (tcode: ZFIGL_FXRATE) is calling the

URL(mentioned above) which in turn open/save the file in the local machine

and therefore, there is no feasibility in ABAP to run the specified

program in background.

Expectation:

For ABAP program to fetch the data, it has to reside in a place which the

program can access. We need to find the possibility of transferring the

exchange rates to SAP Application Server so that the above R3 program can

refer to the file in application server (in background run) and update

exchange rates in SAP to achieve automation of the process.

Regards,

Sreekanth

[Former Member · Accepted solution]

Hi,

In ABAP we have an T-code: SPRO in there we can pass masterdata url in data feed by using webservice option . And again this data feed we call inn funtion module. By this way we reach our requriment.

Thanks,

Sreekanth

[Former Member]

Hi Srikanth,

Not able to find your attached file for ZFIGL_FXRATE.

and what is the standard program name which will process custom program : ZFIGL_FXRATE ?

Regards,

Ramesh

[nageswararao_v2]

Hi Srikanth,

         Your requirement is seems to what Michal Krawczyk has described in one of his blogs here is the link for Exchange Rates file from a webpage . Please try it and let me know if you had achieved your requirment with this or not....

        If it is helpful, don't forget to reward points...

Thanks & Regards,

Nagesh

[PeterJonker]

I think the url can be approached as well from a background job. Write the data to a server directory and you can use the rest of your program unchanged.

see also:

http://scn.sap.com/thread/0001874873

and the SAP HELP link in that discussion

[Former Member]

Hi All,

If that is case in sender side we can use SOAP adpet and recevier side we can use file adapter to place the file in AL11 .

So can anybody help out how to hit masterdata url in SOAP adapter.

Thanks,

Sreekanth

.