Application Development 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
Showing results for 
Search instead for 
Did you mean: 

ALV report Export with text columns truncated and numeric with '*'

Former Member
0 Kudos

Specifically, In transacton S_P99_41000111 the ALV grid reads complete on the screen, have to widen columns for some text, but all data is in the grid.

the report is saved to a local file, Spreadsheet

When it is opened the text field are truncated and number have asterick '*' in them indicating too many chacaters.

If i Widen all columns on the ALV view of grid and THEN export, all characters are in EXCEL

If i run it in the background the spool file has truncated fields.

Is there a way so the report will default to all characters downloading?

Thank you

Althea

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Althea,

Specify REF_TABNAME and REF_FIELDNAME when populating ALV field catalogue.

Regards,

Nisha Vengal.

8 REPLIES 8

Former Member
0 Kudos

Hi Althea,

Specify REF_TABNAME and REF_FIELDNAME when populating ALV field catalogue.

Regards,

Nisha Vengal.

0 Kudos

Hello Nisha

This is a standard report, I am not populating the field catalog.  I do not do ABAP - is this something my programmer can do for me?

thank you

0 Kudos

Hi Althea,

Sorry, I overlooked that it was a standard report.

Please check OSS note 1486374

https://service.sap.com/sap/support/notes/1486374

Regards,

Nisha Vengal.

0 Kudos

Thank you so much!  The OSS note was a little difficult as it refers to "Use push button Views "  I found that to be the Print Preview on my screen.  The list of fields and their widths were there and have now been reset to the standard widths.  –

Again, “Thank YOU”

Althea

Former Member
0 Kudos

Try save with unconverted type and import it to excel.

Regards,

Ikrar

0 Kudos

Ikrar -- even the unconverted text file is truncated and has '*' in the numberic fields

Thank you

Althea

Former Member
0 Kudos

Hi Althena,

Increase the length of the fieldcat so that it will display the long text .

Let me know if any clarification/help required.

Thanks & Best Regards.

Pavan Neerukonda.

0 Kudos

Hello Pavan,

More clarification would be useful as I will need to pass this on to my programmers to review.

thank you.

Althea