Hi, Folks!
I have a question to a SAP BW topic! I haven´t no good knowledge in SAP BW yet and my Englisch isn´t really good, sorry for that.
I have a flat file with exchange rates, which should be loaded in BW. I have found possibilities to load such a file, but i don´t understand the differences respectively there are error messages by loading the file.
There are key figures in local currency, which should be convert in EUR in the reporting. The original file has 3 columns: Reporting Period, Currency, Exchange Rate. I create a new one with the columns: KURSTYP, FCURR, TCURR, GDATU, UKURS, FFACT, TFACT like the table TCURR and save the table as csv. Then Data Warehousing Workbench --> Modeling --> Sources Systems --> Transfer Exchange Rates. But it appears an runtime error: "Unable to interpret UKURS as a number", but i don´t know why!?
And what is the differences to the Transaction RSCURR by creating a currency translation type, which can i choose later in the Query designer for currency conversion?
What is the simplest way to upload an individual exchage rate file for currency conversions in the reporting?
Thank´s for comments!