on 09-12-2013 6:41 PM
Hello,
I'm trying to load a flat file in .CSV format. In the system the values of the KFs are decimal and when it is loaded into PSA, the values are getting Rounded. Eg. If the Value is 34.67 it is turning into 35. Is there any settings that can be changed in the file and what could be reason for this change?
Thanks in Advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ajantha,
Can you let us know, what is the PSA value , 34.67 or 35?
Regards,
S.Venkatesh Babu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It seems problem lies in BW rather than in excel . Make sure you have created the target info object KF in BW with correct data type i.e. DEC.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
So your Flat file shows 34.67. So no problem here. The problem is with BW system.
Check the KF domain in the KF definition. Check the decimal settings here. I think this is rounding off in PSA.
Try by selecting external format for your Kf in the datasource in RSA1.
Regards,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I assume your flat file contains already the two decimals otherwise your 34.67 would turn into 34 and not 35. Make sure the keyfigure you are using is either dec and has actually decimal places or float.
Quan would not work
hope it helps
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anshu and Raman,
Thanks for your help.
Yes, I have the settings in excel as u mentioned. In the same file for a different currency the value is loading as it is in Excel. But only for some currencies the values are rounding off and is somewhat different from actual data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check this document.
http://scn.sap.com/docs/DOC-29671
You can apply the techniques mentioned in the above doc.
Hope this helps.
Regards,
AL
Hi Ajantha,
its excel issue, you need to do the settings as stated by anshu at Excel and check at PSA how its look like.
Excel data and psa data both are same. so you need to do settings at excel only.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In your flat file--select that particular column which contains the values with decimals.Right click on it--Format cells-Number---in decimal places give 2.
Also check the infoobject in which you are loading the data.
Hope this helps.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.