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

ALV Grid to Excel Problem

Former Member

‎2008 Nov 06 3:28 PM

0 Likes
667

Hi Folks,

I have developed a report using ALV GRID for an user. However when he tries to export it to excel my field LIFNR (vendor no.) its 1 character short.

For example:

ALV GRID VIEW:

103190325 2000004610 37,900.00

EXCEL File:

10319032 2000004610 37,900.00

This is pretty strange for me, never had this problem before. Can anyone help me with this problem.

Thanks in advance for your help.

Regards,

Gilberto Li

Edited by: Gilberto Li on Nov 6, 2008 4:28 PM

Hi Folks,

I have developed a report using ALV GRID for an user. However when he tries to export it to excel my field LIFNR (vendor no.) its 1 character short.

For example:

ALV GRID VIEW:

103190325 2000004610 37,900.00

EXCEL File:

10319032 2000004610 37,900.00

This is pretty strange for me, never had this problem before. Can anyone help me with this problem.

Thanks in advance for your help.

Regards,

Gilberto Li

Edited by: Gilberto Li on Nov 6, 2008 4:28 PM

Reply
4 REPLIES 4
Read only

naimesh_patel
Active Contributor

‎2008 Nov 06 4:09 PM

0 Likes
642

Check the output length of the that field in the fieldcatalog.

Regards,

Naimesh Patel

Read only

Former Member
In response to naimesh_patel

‎2008 Nov 06 4:15 PM

0 Likes
642

Hi Naimesh,

Thanks for your reply.

Yes I have checked the output length for the field. Right now I have it on 12 just in case, but LIFNR is a 10 character field, and I am still having this problem.

When I hit the button for a preview on the grid it shows like this:

10319032... 2000004610 37,900.00

Strangely, don't know why this last digit is getting cutted.

Thanks again.

Regards,

Gilberto Li

Read only

Former Member

‎2008 Nov 06 4:22 PM

0 Likes
642

Hi

When you definen the field cat, please maintain the technical filed name, as in reference to the standard SAP techincal field. This will pass the correct attributes of the field while passing to alv.

regards

ravish.

Read only

Former Member
In response to Former Member

‎2008 Nov 06 4:50 PM

0 Likes
642

Hi again,

I have solved the problem. I changed the data element of the a Z table I was using from LIFNR to CHAR10.

For some reason this was the cause of the problem. I'm thinking that LIFNR is configured as a internal number and programs using this table are not using the correct internal no. conversion causing the view of the data to be incorrect.

Anyway I really appreciate your time and help.

Regards,

Gilberto Li