We have currency conversion issue, while running the report for CAR3 exchange rate type.

No translation ratio's have maintained for the mentioned currency pair for a month ex: 01/08/2019

Image Added

1) First check via the below program to test about the issue by proving Exchange rate and the currencies.

 RCURTEST

Image Added

The error itself clearly say's that the "Translation ratio's for EUR/AED" have not maintained for exchange rate type CAR3

2) Check in TCURF table

Where the ratios have not maintained in TCURF table from EUR to AED, BUt we have for AED to EUR.
So, We have to maintain EUR to AED ratio in TCURF table in order to fix this in OBP.

IMPORTANT for 90% of the translation the value is 1 ↔ 1 but it could be 1 ↔ 1000 so need to have the approval of finance and controlling team. 

3) We have to upload the TCURF table by the ( ZBW_TCURF_LOAD )program.

First we have to Create an excel file with ".xls" format with out headings, please find the below screenshot for reference + no space in the name (better) + not from too long folder 250 characters limitations.

Image Added

Note:  Please uncheck the check box "Respect Conversion exit" to get the value instead of date like above(81999898). date stored at  9's complement format, you can take on example on the TCURF form WBP.

Go to SE38 → Click on Execute

Image Added

Follow the below steps:

a) Select "Update TCURF"

b) Choose your Excel file

c) Click on "Preview" to check if we have any errors

d) Click on "Check File"

e) Click on "Load file"

Image Added

After loading the file, we will get a message "File as been loaded".

Now, Go and Check TCURF table, Where the factors for EUR to AED are maintained.

Image Added

Another way to maintain factors is to transport the factors from OBD to OBQ to OBV and then to OBP by using the SPRO tcode.

https://help.sap.com/docs/SUPPORT_CONTENT/erphcm/3354687751.html

Although currencies are maintained in table TCURR, this table is not responsible for the inverse calculation as there is a technical difference between the generation of values between TCURR and TCURF,

this means the portal values are derived from TCURF as each currency also needs a reverse ratio calculation. So in this case, you need to also follow the IMG path; 

Image Added

Tcode SPRO > IMG > SAP Netweaver > General Settings > Currencies > Define translation ratios for currency translation'*

Here, you should check the currency pairing and ensure that the same reverse ratio is entered, E.g pairing of USD:EUR/EUR:USD. You can also do this directly in view V_TCURR  and V_TCURF via SM30

• You must also have an entry in each field Ratio for the "from" currency units and Ratio for the "to" currency units.
• Finally, please also have an entry for this pairing in TCURR.

It is important to note for TCURF, that this table is not keeping the exchange rates but is concerned only with ratios. These need to be maintained correctly only once.
The checks in the ABAP based WebDynpro Travel Application are far stricter than in transaction PR05 and therefore any dump or error occuring in portal if the ratio and pairings are not correctly defined will not occur in PR05.

Image Added

Workbook/Query General Description

General parameters

Global properties

Variables

Definitions

Variable Name

Selection Type

Required

Description/Explanation

Variable Sequence

Filters

Key figures

Key Figure 1

Description

Calculation rule detail

Text Replacement Variable

Currency Conversion

Exchange Rate Type : 

Currency : 

Time Reference : 

Unit Conversion

Unit : 

Characteristics

Cells

Conditions

Active

By default

Key Figure

(Structure)

Exceptions

Active

By default

Alert Level

Other parameters

(if different from default)