Skip to Content
Author's profile photo Syed Zia Abbas

Upload Exchange Rates using TBEX option

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

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Agnieszka Drewniak
      Agnieszka Drewniak

      Thank you!

       

      Author's profile photo Ayman Mohamed
      Ayman Mohamed

      Thanks Sayed.

      Author's profile photo Nellie Chang
      Nellie Chang

      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.

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas
      Blog Post Author

      Check your configuration for;

      1. Set Decimal Places for Currencies: Tcode OY04
      2. Define rounding rules for currencies: TCode OB90

      Regards

      Syed Zia Abbas

      Author's profile photo Anna Strokova
      Anna Strokova

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

      Author's profile photo Venu Kodam
      Venu Kodam

      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