9.12345E+11,9.12345E+11 csv values in sap bods

[Former Member]

HI All,

I have 12 digit values in csv file for customerno like 9123456700001,9123456700002,,,,

but it is showing 9.12345E+11,9.12345E+11,,,,

even when I load into bods also loading in 9.12345E+11,9.12345E+11,,,,.

HOw to solve this issue?

THanks in advance.

[former_member271656 · Accepted solution]

Hi,

Format the column in the csv file then create the file format and DF.

Hope this helps.

Thanks & Regards,

Abdul Majeed Mohammed

[Former Member · Accepted solution]

WHich format, please let me know.

[former_member271656 · Accepted solution]

Hi,

I think it is 'General' by default. Change it to Number and set the decimal places to 0, else you will get 9123456700001.00.

Thanks & Regards,

Abdul Majeed Mohammed