Skip to Content
0

Is there any Forex Report/Table that shows the exchange rates used in the calculation?

Oct 12, 2016 at 01:51 PM

130

avatar image
Former Member

Dear All,

Could you help us by sending your knowledge regarding a Forex Report or Table that stores exchange rate data and based amounts for every line item reflected in FBL3n for Forex Gain/Loss GL accounts.

Thank you for sharing your thoughts. More powers to all!

BR,

Nigel, TDK

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sanil Bhandari Oct 13, 2016 at 07:14 AM
0

Hi

Your question is not very clear and what exactly you are trying to achieve. You should be able to fetch the amounts in local and document currency from FBL3N itself by specifying the GL Account No. Additionally, the information for exchange rate used is stored in Document Header and is stored in BKPF. So what are you trying to achieve?

regards


Sanil

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 25, 2017 at 09:58 AM
0

Hi,

To verify the exchange rates used in calculation, you can check Tcode EWCT.

You have to fill the different details required like translation date / Currencies wanted / Exchange rate type ..

Hope this has been helpful,

Best Regards,

Omar

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 01, 2017 at 12:59 AM
0

Hi,

Our client requested to make a Forex Report that shows the details of the original Asset or Liability (AR and AP) transacted, Historical Rate and Current Rate use for every line items appeared in FBL3n that have impact in Foreign Currency Valuation (FOREX). Yes you are right that there are exchange rate found in the Document header/bkpf... AND WE ARE VERY MUCH AWARE ABOUT THAT. Our problem is that for one line item in FBL3n, you can only see CURRENT exchange rate for that transaction (which is normally the rate maintained for that Posting date found in table TCURR), but the original data/historical data where this REALIZED GAIN/LOSS came from which also pertaining to the debited AR or credited AP transacted previously is not very clear, specially when we considered the document splitting in SAP (by the way, we are "new GL activated").

Of course, we know how to compute majority of line items using manual computation, but some items are not since the amounts already split into different profit centers.

That's the reason why we are asking if there are table in SAP that stores all these data: (1)The Original book amount for AR/AP, (2) the historical rate that was used during the first/original transaction, and lastly the (3) current exchange rate used upon Forex Realization, during payment of AP or receipts from AR.

Hope it is clear now.

Thank You very much.

Share
10 |10000 characters needed characters left characters exceeded