topic Re: Function Currency/Country in Application Development and Automation Discussions

Function Currency/Country

Former Member — Mon, 21 Apr 2008 10:46:29 GMT

Hi,

knows anybody a function module, witch returns the national currency to a country?

Regards,

Anton

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 10:50:07 GMT

hi,

Check out T005, TCURR & TCURC tables ...

Regards,

Santosh

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 10:54:12 GMT

Sorry.

Regards,

Santosh

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 10:54:36 GMT

Hi Santosh,

i allready checked the T00* and TCUR* tables for relation between Country and Currency.

But id didn`t found them.

Regards,

Anton

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 10:58:31 GMT

use FM: CONVERT_TO_LOCAL_CURRENCY

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:05:53 GMT

Hi Dara,

thanks for your reply.

But this function doesn`t help me.

My Problem.

I get a file from a customer with invoices. For this invoices i get in this file the country of the business partner and i get the total gross value. But i get no currency.

So im must find to the country the national currency to save them with my invoice data.

Regards,

Anton

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:06:25 GMT

hi,

Use FUNCTION MODULE READ_EXCHANGE_RATE.

reward if helpful.

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:10:30 GMT

Hi Iyswarya,

sorry. No.

Please read my answer to Dara.

Regards,

Anton

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:10:52 GMT

Hi,

Am I missing something, or do you just need to read table T005 with key LAND1 to find the value of WAERS?

The only problem you might face is this data as standard is not complete, but there's no reason you couldn't populate it yourself.

Regards,

Nick

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:15:38 GMT

Hi Nick,

i get my import data like this :

PARTNERNUMBER | COUNTRY | NET_VALUE

001111111111 | GERMANY| 1000

002343434344 | USA | 1500

004535435435 | AUSTRIA | 900

But i need to save the data like this

PARTNERNUMBER | COUNTRY | NET_VALUE | CURRENCY

001111111111 | GERMANY| 1000 | EUR

002343434344 | USA | 1500 | USD

004535435435 | AUSTRIA | 900 | EUR

Regards,

Anton

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:22:47 GMT

Hi,

So, the problem is that your interface is passing the country name, not the country code recognised by SAP.

You need to read table T005T to get the country code from the name, then T005 to get the currency from the code.

Regards,

Nick

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:25:39 GMT

Hi,

to get the country ISO code is not the problem.

But in crm in table T005 is no currency code to country.

Regards,

Anton

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:37:42 GMT

Ah, well now you mention you're working in CRM this gets different.

The structure of T005 in CRM is different, so you either need to make an RFC to your ERP system (if there is one) or build your own table.

Regards,

Nick

Re: Function Currency/Country

Former Member — Mon, 21 Apr 2008 11:39:23 GMT

Hi,

thanks for this hint.

Regards,

Anton