Function Currency/Country

[Former Member]

Hi,

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

Regards,

Anton

[Former Member]

hi,

Check out T005, TCURR & TCURC tables ...

Regards,

Santosh

[Former Member]

hi,

Check out T005, TCURR & TCURC tables ...

Regards,

Santosh

[Former Member]

Hi Santosh,

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

But id didn`t found them.

Regards,

Anton

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

thanks for this hint.

Regards,

Anton

[Former Member]

Sorry.

Regards,

Santosh

[Former Member]

use FM: CONVERT_TO_LOCAL_CURRENCY

[Former Member]

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

[Former Member]

hi,

Use FUNCTION MODULE READ_EXCHANGE_RATE.

reward if helpful.

[Former Member]

Hi Iyswarya,

sorry. No.

Please read my answer to Dara.

Regards,

Anton