Decimal Point is getting Rounded in Flat File Load

[former_member266270]

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!

[Former Member · Accepted solution]

Hi,

1st open CSV file in notepad and confirm that 34.67. If yes, Then make change in properties of Datasource as shown in below figure.

Fig. Change Decimal Place from 0 to 2 from Proposed Tab

Regards,

Sushant

[Former Member]

Ajantha,

Can you let us know,  what is the PSA value , 34.67 or 35?

Regards,

S.Venkatesh Babu

[former_member266270]

Its 35

[KamalMehta]

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

[former_member182470]

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

[former_member182470]

Check my reply..

[MGrob]

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

[former_member266270]

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.

[anshu_lilhori]

Hi,

Can you let us those currencies key so that we can check if its know issue or not.

Regards,

AL

[RamanKorrapati]

Hi Ajantha,

Take one key fig value which was as it easy of flat file and compare with other key fig(which was coming wrong/round off) settings. you will get some clue.

Thanks

[KamalMehta]

Can you please check and make sure you have created the target info object KF in BW with correct data type i.e. DEC.

[former_member266270]

Currencies are TWD, JPY, KRW

[anshu_lilhori]

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

[MGrob]

these currencies are handled differently in sap. they are internally stored with a factor 100. you might want to build in a routine that multiplies those currencies times 100 during the load. that should fix your rounding issue

Martin

[RamanKorrapati]

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

[anshu_lilhori]

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