Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Flat File Error

Hi All,

InfoObject is defined with Type: Curr, Length: 17 & Decimals:2.

Dta in CSV file, has some +ve values & -ve values, and negitive values indicating with - sign like -1.484,41

in the infopackage, When i'm going for'preview' in the 'External' tab, Data is displaying like 12.170, but in CSV file it is 12.170,49. Where as, - ve values are displaying correctly as it is -1.484,41

Can anyone have idea, why the last two digits are truncating in the preview for +ve values ?

Thanks.

V

Former Member replied

Hi V,

In the excel file select all the columns and chose the format as "general" or "text".

The other option is to open the ".csv" file in notepad and then edit.

Bye

Dinesh

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question