cancel
Showing results for 
Search instead for 
Did you mean: 

EXCHANGE RATE DETERMINATION IN SALES ORDER

Former Member
0 Kudos

Hello,

I have one question regarding Exchange Rate determination in Sales Order.

I have change the document Currency in the sales Order but the exchange rate determined in the sales order ( from Eur to USD) is not is the Table TCURR..

Could you please tell me where SAP takes this exchange rate ???

Thanks for your help

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

First check the setting in t-code (ONOT). This will tell you how the currency exchange rate is determined for this pair. Based on your information you've provided, I suspect it is maintained as an indirect quote. If it is maintained as an indirect quote, use t-code (OB08) to look up the rate, but this time look for USD to EUR. The system will use the reciprocal of that amount.

thanks,

Answers (2)

Answers (2)

claudia_neudeck
Active Contributor
0 Kudos

> close the thread, because no reaction over 3 months

jpfriends079
Active Contributor
0 Kudos

Use Tcode OB08, maintain the exchange rate with the exchange rate type S which is the SPOT RATE or you can try with M (or based on your customer requirement).

Also, check copying control setting for billing (VTFA / VTFF / VTFL)

Say , use tcode VTFL, select the item category for the combination of your delivery type and billing type where you can see a field Exchange rate. There you have the following options.

A::: Copy from sales order

B::: Price exchange rate = Accouting rate

C::: Exchange rate determination according to billing date

D::: Exchange rate determination according to pricing date

E::: Exchange rate determination according to current date

F::: Exch.rate determination accord.to date of services rendered

Thanks & Regards

JP

Former Member
0 Kudos

HELLO,

the question is regarding sales order..

When I change the document currency, the value of the exchange rate is not the one defined in table TCURR.. So where does it come from ?

Then, in copy control ( VTFL), the pricing exchange rate is blank. with this blank value what is the system behaviour ?

regards

jpfriends079
Active Contributor
0 Kudos

Use Tcode OB08 - maintain the exchange rate

100* Reference value = group value

1001 Current exchange rate

1002 Average exchange rate

1003 Historical exchange rate

1004 Current exch. rate prior year

200* Reference value = group value

2001 Current exchange rate

2002 Average exchange rate

2003 Historical exchange rate

2004 Current exch. rate prior year

B Standard translation at bk.selling rate

EURO EMU regulation, fixed exchange rates

EURX EMU regulation, variable exchange rates

G Standard translation at bank buying rate

I Intrastat exchange rate type

M Standard translation at average rate (generally preferred by sales guys)

P Standard translation for cost planning

Exchange rate type is key under which you define exchange rates in the system.

Its is use to define different exchange rates you must specify exchange rate types. For instance, you can use the exchange rate type to define a bank buying and selling rate and an average rate for the translation of foreign currency amounts. You can use the average rate for foreign currency translation, and the buying and selling rates for the valuation of foreign currency amounts.

Rest all (copying control) was FYI.

Regards

JP

Former Member
0 Kudos

Here are the entries in OB08 for EUR to USD

M 01.01.1997 X 1 EUR = 1,20075 X 1 USD

P 31.12.2008 X 1 EUR = 1,50000 X 1 USD

P 01.01.2001 X 1 EUR = 0,95000 X 1 USD

P 01.01.1997 X 1 EUR = 1,20075 X 1 USD

ZEND 01.03.2004 10,00000 X 1 EUR = X 1 USD

____ __________ .__,_____ X ___________ _____ = .__,_____ X ___________ _____

in sales order , I got this value as exchange rate 1,46140

as you can notice it is not the one maintained in the table.....do you know where this value is taken ?

thanks

jpfriends079
Active Contributor
0 Kudos

It you are talking about Table TCURR, then it should be maintain in OB08.

Else, what I can suggest is take assistance of FI consultant or explorer flollowing path in IMG.

Use tcode SPRO

>IMG - SAP NetWeaver - General Setting - Currencies.

Hope this can assist you.

Thanks & Regards

JP

Former Member
0 Kudos

OK..

You explained the different possiblities for Exchange rate in VTFL copy control ( A, B, C, D .....)

What happens if I leave this field blank ?

jpfriends079
Active Contributor
0 Kudos

Pricing date as base.

Regards

JP