se16 down load into excel sheet problem with PO number

[Former Member]

Dear All,

While I download vbak table data using se16 from table VBAK ( using System > List> save --> local File --> Spreadsheet ), I get the PO number converted as error like at it's end, the last digit is becoming zero when po number is of 16 digits. means only the last digit is converted to 0.

For example : se16 -> vbak table -> the po numbers

1238643210249039, when I down load in the excel sheet it is appearing as 1238643210249030

(I means the last digit of the PO number is downloaded with error, it is always a u201C0u201D.

if the PO number is of less than 16 digits... the above problem is not there )

How to correct the error ? How to tell solution to functional consultant ? Can you please suggest me

Do we need to apply any OSS message ?

Thanks in ADVANCE.

Edited by: sam kumar on Dec 8, 2008 5:40 PM

[Former Member]

Hi

This is related to MS Excel, not SAP.

Select the entire column, right click -> Format cells -> Category -> Number (decimals 0).

You can even try category as Text

Regards

Raj

Edited by: Rajasekhar Dinavahi on Dec 8, 2008 10:26 PM

Edited by: Rajasekhar Dinavahi on Dec 8, 2008 10:30 PM

[Former Member]

Hi Rajasekhar,

I have selected as you said the entire column, right click -> Format cells -> Category -> Number (decimals 0)....however, I am getting the same error.

and also tried category as Text, in this case the PO value is appearing in excell as '1.91108E+15'

.

Don't understand why

[Former Member]

Hi,

Just found that 'Numbers in Microsoft Excel can never have more than 15 significant digits'.

check this link from Microsoft: [http://support.microsoft.com/kb/158071|http://support.microsoft.com/kb/158071]

check this [http://office.microsoft.com/en-us/excel/HA102748231033.aspx|http://office.microsoft.com/en-us/excel/HA102748231033.aspx]

[http://office.microsoft.com/en-us/excel/HA102748231033.aspx#5|http://office.microsoft.com/en-us/excel/HA102748231033.aspx#5]

What i can suggest is, put a apostrophe (') for the value of first cell content at the beginning.

Use Format painter to apply the same for all values in that column.

Regards

Raj

Edited by: Rajasekhar Dinavahi on Dec 8, 2008 10:59 PM

Edited by: Rajasekhar Dinavahi on Dec 8, 2008 11:00 PM

Edited by: Rajasekhar Dinavahi on Dec 8, 2008 11:05 PM

[Former Member]

Rajasekhar,

Much thanks. Great.

What i can suggest is, put a apostrophe (') for the value of first cell content at the beginning.

I kept apostrophe in that column's first cell.

then Could youplease be more specific on below

Use Format painter to apply the same for all values in that column.

one more thing is :

However, I found one more thing is --> if we display table output in ALV Grid display mode ( setting --> user parameters --> ALV Grid display ).

Then we have spread sheet ( ctrl + shift + F7 ) icon --> Select 3 rd radio button u2018All available formatsu2019 on th pop-up & select last one in drop down : Excel ( In exisiting XXL format ) --> then in the next pop-up Select second radio button ( Table) --> Microsoft Excel + Enter.

in this way , it is coming and sitting in excell table ....! ?

More over How to convey to my functional guy ( important )

[Former Member]

Hi

Firstly, convey to your functional consultant that " it's a limitation of MS Excel not to accomodate values greater than 15 digits [ you can show the webpages of Microsoft to support your statement]. "

If its working fine with ALV Grid display and then follwed by downloading.... ! you made it !

Regards

Raj

[Former Member]

THANK YOU Raj!