Upload Exchange Rates using TBEX option

[former_member206852]

Dear All

 

Here I am sharing a process through which one can use the exchange rate upload methodology instead of using the conventional OB08 TCode.

 

Step 1: Start transaction Code=TBEX.

 

Step 2: Check "Market data Selection for new create" indicator for ‘Currencies’

 

Step 3: Then press button "Create (F9)"

 





Step 4: Then you will get the pop-up asking for Macro enabling;

 



 

Click 'Enable Micros'

 

Once you enable it, Spreadsheet file will open in the "Spreadsheet" tab.

 

Step 5: This is vital step where you need to work on the existing template very cautiously.

 



 

 

Keep the data in your external excel file in the same format (i.e. Column sequence).

 

Step 6: Copy data from your external excel file and paste into spreadsheet in TBEX all data which you wanted to enter.

 

Step 7: Start "Import Market data (F5)".

 



 

If your data has any error, it will display inside your spreadsheet. Scroll to the fields "Status" and "Error messages" and read them carefully.



 

Correct the inconsistencies, which is highlighted in the column 'Error message'. If all things are in place, you should not get any error. In that case, status will be ‘OK’ for all lines.

 

Enjoy..!!!. Feedback's most welcome.

 

Regards

Syed Zia Abbas

[former_member378614]

Thank you!

 

[Ayman]

Thanks Sayed.

[former_member710345]

Generate the excel file for exchange rate via TBEX and found that decimal places is 2,

wondering if decimal pleases of exchange rate can be 5 instead of 2? many thanks.

[former_member206852]

Check your configuration for;

1. Set Decimal Places for Currencies: Tcode OY04


2. Define rounding rules for currencies: TCode OB90

Regards

Syed Zia Abbas

[former_member722192]

Thank you for this post, it is very useful to us.

[kodam_v]

Thank you for this post, its very helpful.

 

we are also getting errors value XXXXX.too.big.max 4 No. places.bef.dec.pt for IDR currrency.

Oy04 will help to resolve? or how did you resolve these errors.

 

Thanks and Regards,

VK

[gandhi7985]

Hi Syed,

Thank you for sharing. It is really helpful.

Best Regards,

Gandhi B