Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Error While ALV Grid is exported to Excel.

Former Member

‎2009 May 19 12:13 PM

0 Likes
1,072

Hi Experts,

I get an error OBJECTS_NOT_CHARLIKE , while I try to download an ALV Grid , to an excel file using the standard icon Export present on the ALV Grid.

Regards.

Edited by: sunitha j on May 19, 2009 1:15 PM

Reply
2 REPLIES 2
Read only

former_member242255
Active Contributor

‎2009 May 19 1:45 PM

0 Likes
547

Hi Sunitha,

For the fields in the ALV output ,please check if you have some fields of type packed decimals bcoz in ALV these fields lead to the dump while you download the data into excel thru the standard export button.

to avoid this you have to make the fields into CHAR types and then you can download the data.

Read only

Former Member

‎2009 May 19 2:18 PM

0 Likes
547

This happens when your output list contains qty. or amount fields.

To fix the error use sap table name instead of your internal table name while preparing field catalog.

In case you are forced to use int. table name while preparing field catalog , add "quantity" field for qty figures and "currency" field for amount figures.

Example :

it_catalog-fieldname = 'MENGE'.

it_catalog-quantity = 'NOS'.

it_catalog-tabname = 'i_bseg'.

it_catalog-seltext_s = 'Quantity'.

APPEND it_catalog TO it_fieldcat.

it_catalog-fieldname = 'DMBTR'.

it_catalog-tabname = 'i_bseg'.

it_catalog-seltext_s = 'Amount'.

it_catalog-currency = 'INR'.

APPEND it_catalog TO it_fieldcat.