Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Exchange rate upload throuhg Transaction ob08

Hi,

I need to load automatically the exchange rates which are downloaded from company site which are in pounds every month to transaction ob08

I'm trying to use TBDM to upload exchange rates, and I'm having problems.

I created an excel file according the help information. But when I try to run TBDM, my list and error log file are empty. No error messages, but no results.

I tried saving the file as comma delimited and as tab delimited text file, but neither worked. When I first tried to run TBDM, it wanted me to enter a data provider, so I had to set one up in the Treasury config. Is there other config I need to do? You said something in your message about using Access to make a fixed length file. Apparently I'm missing something.

I am also trying to load through Transaction TBEX but that does work either.

I just want to know from Financials gurus if I am proceeding correctly or not.

I'd really appreciate any hints!

MaRk

Former Member
Former Member replied

This is the structure

Fld no. Meaning Cat. Length R/E Description

1 Data class CHAR 2 R Fixed value '01'

2 Key 1 CHAR 20 R FROM currency

3 Key 2 CHAR 20 R TO currency

4 Market CHAR 15 R Rate type

data type (e.g. bid, ask, middle)

5 Date CHAR 08 R Contribution date

(!!!Format: DDMMYYYY)

6 Time CHAR 06 E Contribution time

(!!!Format: HHMMSS)

7 Value CHAR 20 R Value for data

8 Currency CHAR 20 E not relevant

9 FROM curr. CHAR 07 R Factor for units of

factor FROM currency

10 TO curr. CHAR 07 Factor for units of

factor TO currency

11 Price CHAR 05 E not relevant

notation

12 Status CHAR 02 E Error status

(Values 50..99)

13 Error CHAR,80 E Error message

message

Note:

Refer the documentation of RFTBFF00.

The Catch in text file is that yu may have to strictly follow the exact Char length ( may be blank though it is separated by Comma).Then it will work. I tried and it works . If you need any more details please let me know.

Thanks,Chitra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question