Problem related when alv report download in excel

[Former Member]

Hello Experts,

When i download my ALV report in excel then material number field (matnr) gets incorrect value in excel.

Suppose in my report matnr is : '000000001010000012'

when i download alv report it looks like : '101000001'

here last digit '2' is missing.

what is remedy for that.?

[former_member216408]

Hi AMEYA KARADKHEDKAR,

            How you are exporting to excel?

            Do you expanded the cells in excel if not expand it.

Regards,

Dinesh Jeyasurian.

[Former Member]

Hi J Dinesh,

       yes i expanded cells of the excel but that shows last number missing in matnr field.

       exporting path is : goto local files export-> spreadsheet-> save as filename as .xls format.   

        Onlu matnr field gets this problems occured other fields have correct values..

Regards

Ameya Karadkhedkar

[former_member188827]

Try giving ref_tabname and ref_fieldname in field catalog:

WA_FIELDCAT-REF_TABNAME = 'MARA'.

WA_FIELDCAT-REF_FIELDNAME = 'MATNR'.

Also, check the following link:

http://scn.sap.com/thread/2058108

Regards

[Former Member]

Thanks to All my query get solved..