Hi Experts,
I do have the usual issue with ITL currency in BEx (SAP BI 7.0 / BEx 3.5).
As you probably know, Italian Lire is a no-decimal currency, stored that way in TCURX table.
I do load my amounts from an Oracle database, through DBConnect.
Therefore, the amount 1000 ITL is displayed in BEx like 100000,00 ITL, which is obiously wrong.
There is an evident way to workaround this by removing the ITL record in TCURX, but I would like to implement another method, using for example conversion in my DataSource.
Here are my 3 questions:
1. Could someone explicitly explain me how the amount are stored into the database (with or without decimal) and when intervene the cross-check with TCURX.
2. Does it exist a standard conversion module in DataSources for converting my ITL amounts to the right SAP Amount format?
3. If not, I suppose applying a small routine in transformations like IF Currency = ITL then divide per 100 is not really a wrong method?
Thanks for all the explanations you could give me
Sylvain