topic Re: Currency fields in Application Development and Automation Discussions

Currency fields

Former Member — Wed, 02 Jun 2010 07:12:42 GMT

Hi experts,

I am facing following problem:

In my report I need some data from the table mbew. I need the value in field stprs. Where can I find the reference currency in this field and how can I convert it to dollar for using it in my smartform.

Thanks a lot for your help,

Christoph

Re: Currency fields

Former Member — Wed, 02 Jun 2010 07:22:53 GMT


> Hi experts,
> 
> In my report I need some data from the table mbew. I need the value in field stprs. Where can I find the reference currency in this field and how can I convert it to dollar for using it in my smartform. 
> Christoph

you can find reference field in mbew table itself (currency/quantity fields)

t001-->WAERS

Please search SDN for FM-convert currency (SD_CONVERT_CURRENCY)

or se37> convertcurrency*>press f4 you can see lot FM,choose as per your requirement

Re: Currency fields

Former Member — Wed, 02 Jun 2010 07:23:38 GMT

Hi Christoph

Just go to table MBEW ,

there If you double click on the field STPRS , it will open another window where you will find teh information you need.

Also while being on the field STPRS in MBEW, if you click on the button Currency/Quantity Fields(Upper right corner) , then also you will get the information about the referenced field.

I hope this is what you are looking for...

Regards,

Uma Dave

Re: Currency fields

Former Member — Wed, 02 Jun 2010 08:08:10 GMT

Hi,

thanks for the information so far. I found the currency in table t001 --> that´s fine. But I don´t know how I can convert the currency (CHF) to USD. I used different function modules, but it does not work.

Thanks for your help,

Christoph

Re: Currency fields

Former Member — Wed, 02 Jun 2010 08:29:09 GMT

Hi Christoph,

If you have any correct test data with you then you can check out in standard transactions , there you will get the exact factor used for conversion and you can accordingly calculate the amount and then hard code currency as USD

You can also try using this function module

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

EXPORTING

CLIENT = 001

date = sy-datum

foreign_currency = wa-waers

local_currency = tcurr-fcurr

foreign_amount = wa-dmbtr

RATE = 0

type_of_rate = 'M'

READ_TCURR = 'X'

IMPORTING

exchange_rate = tcurr-ukurs

FOREIGN_FACTOR =

local_amount = wa-total

LOCAL_FACTOR =
EXCHANGE_RATEX =
FIXED_RATE =
DERIVED_RATE_TYPE =

EXCEPTIONS

no_rate_found = 1

overflow = 2

no_factors_found = 3

no_spread_found = 4

derived_2_times = 5

OTHERS = 6

Regards,

Uma

Edited by: UmaDave on Jun 2, 2010 10:30 AM

Re: Currency fields

SuhaSaha — Wed, 02 Jun 2010 08:32:13 GMT

The exchange rates are maintained in the table TCURR. Check in TCURR if the rates are maintained for CHF --> USD.

Re: Currency fields

Former Member — Wed, 02 Jun 2010 08:52:43 GMT

Hi, thanks for your replies.

It is working now.

Christoph