on 2013 Feb 28 10:48 AM
Dear Experts
There is a new currency implemented for a company.
I have a report pulling from VBRK, VBRP, VBUK, VBUP.
Initially, there was only 1 currency. Now, with new currency, what are the fields relevant to check to get the value for the new currency?
Kindly could you please advise ?
Thanks for reading.
Regards
Pascal
Request clarification before answering.
Moved from SAP ERP SD Billing to Business Intelligence Solution Architecture
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Roland
Good day.
I was referring to SAP BI 7.0 (BW, not BO).
.
May I know how to convert the currency in SAP BI 7.0 in terms of getting the results accurately considering the decimal points ?
I understand that if converted with function module in BI, the values may not be exactly the same as in SAP R/3 FI database due to the rounding up or down. SAP FI I am told is in 5 decimal places. Will he BI FM give the same 5 decimals?
Thanks for reading..
Best regards
Pascal
Hi Pascal,
You can bring in the exchange rates and currency details from your ECC system (RSA1 > Source Systems > Choose your ECC system > rt click and Transfer Exchange Rates) This update the TCUR* tables and in table TCURX you can check the decimal places for each currency. If you can se your new currency here with 5 decimal places assigned, then that's what it will be when converted.
More important is to set up a correctly defined currency conversion type (transaction RSCUR). You can reference this conversion type when loading data or also in the queries.
Hope this helps...
Dear Bhanu
Thank you for responding.
I am not sure how to have same Sales amounts as found in FI module.
Our SAP BI pulls from SD Billing database eg. VBRK VBRP via 2LIS_13_VDITM.
In BI report, we are selecting billing documents with Flag 'Posted to Accounting' = C.
We need to match the FI database.
The SD Billing document now will have a 2nd Local currency.
So, BI now needs to convert to USD if Document currency is not already in this 2nd Local currency.
My understanding is FI side uses TCURR also when Billing doc flows into FI.
But I not sure what days rate to use.
In FI, they use posting date of FI doc.
In Billing, there is no posting date but posting period and FKDAT which is the Billing doc date.
Am I right to say FKDAT is the FI posting date?
Also, am I right to say normally, Billing module only allow creating billing documents in the current month? No backdated posting?
If so, I am thinking of using the TCURR to read current month rate in the currency conversion.
Currently, our TCURR in R/3 contains 1st day of each month only. So, same rate is used for the whole month.
I have loaded the TCURR from R/3 to BI via the steps mentioned here.
So, I need some functional advise if my understanding is correct to match SD billing amounts with FI based on conversion to 2md local currency using TCURR.
I am not sure the date to use .
Please help.
Thanks very much.
Best regards
Pascal
User | Count |
---|---|
60 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.