Download problem in ALV

[Former Member]

Hi,

For ALV data dispaly using "REUSE_ALV_FIELDCATALOG_MERGE" am generating fieldcatalog and in report i can see the full description of field headings by stretching that columns.But when i downloaded into excel the field headings are suppressed i checked in Standard ALV are same like this.But what is the possible way to get fll description of that headers of fields in Excel.

THX

[Former Member]

did u set layout parameter for optimum length of columns.

[Former Member]

Ya i given optimum_lenth and Cell_merge option in that layout but still the same problem...

[Former Member]

Hi,

At time of downloading to excels whatever header is visible in ALV output will be downloaded ..in case as u said ur able to view it after streaching those colomns so it will not get populate .Give some length for those header field like for 'material' provide 8 if it is less it will truncate that text,.

Use wa_fieldcat-outputlen = '8'

Thanks

Shrila

Edited by: shrila joshi on Mar 11, 2009 11:28 AM

[former_member242255]

pass 'X' to colwidth_optimize in layout

or

fieldcat-seltext_l you can give and you will get the output fully

[Former Member]

Hi There ,

This problem genrally occurs...what u need to do is give the sufficient header length in field catalog ..it will solve your problem..

In case of any issues let me know...

Thanks

Shrila

[Former Member]

Hi,

http://www.lyriance-labs.com/sap-abap-program-examples/sap-abap-program-examples-utils-and-tools/fil...

Thanks and regards

Durga.K

[Former Member]

Hello,

See if you can try to implement this:

• Creating the document to be sent

wa_doc_data-obj_name = text-043.

• subject

wa_doc_data-obj_descr = p_subj.

i_contents-line = text-061.

APPEND i_contents.

i_contents-line = ' '.

APPEND i_contents.

i_contents-line = text-029.

APPEND i_contents.

DESCRIBE TABLE i_contents LINES v_tab_lines.

READ TABLE i_contents INDEX v_tab_lines.

IF sy-subrc EQ 0.

wa_doc_data-doc_size = ( v_tab_lines - 1 ) * 255 + STRLEN( i_contents ).

ENDIF.

• Creating the entry for the compressed document

CLEAR i_packing_list-transf_bin.

i_packing_list-head_start = 1.

i_packing_list-head_num = 0.

i_packing_list-body_start = 1.

i_packing_list-body_num = v_tab_lines.

i_packing_list-doc_type = c_raw.

APPEND i_packing_list.

that should solve your problem for when u r populating your excel file with the missing characters.

cheers

kevin