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

[Former Member]

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

[Former Member]

Hi Althea,

Specify REF_TABNAME and REF_FIELDNAME when populating ALV field catalogue.

Regards,

Nisha Vengal.

[Former Member]

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

[Former Member]

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.

[Former Member]

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]

Try save with unconverted type and import it to excel.

Regards,

Ikrar

[Former Member]

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

Thank you

Althea

[Former Member]

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.

[Former Member]

Hello Pavan,

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

thank you.

Althea