build xls table

[Former Member]

hi,

i am building xls table to send as an attachment to external mail.

i am able to generate will xls file as attachment.

i have 21 fields. but only 13 headers are coming in the output. rest 8 headers are not populating in the xls file.

infact while opening the file from mail message is coming as the file is not in recognisable format.

what will be root cause. any ideas

[Former Member]

hi,

i am building xls table to send as an attachment to external mail.

i am able to generate will xls file as attachment.

i have 21 fields. but only 13 headers are coming in the output. rest 8 headers are not populating in the xls file.

infact while opening the file from mail message is coming as the file is not in recognisable format.

what will be root cause. any ideas

[Former Member]

Hi,

in debugging i checked. at append it_attach values are not appending from text-016.

DATA: it_attach TYPE STANDARD TABLE OF solisti1 INITIAL SIZE 0

WITH HEADER LINE.

i declared it_attach like above.

FORM build_xls_data_table.

CONSTANTS : con_tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB,

con_cret type c value cl_abap_char_utilities=>CR_LF.

clear it_attach.

CONCATENATE text-006 text-018 text-007 text-008 text-009 text-010

text-011 text-012 text-013 text-020 text-014 text-015

text-016 text-017 text-019 text-021 text-022 text-023

text-024 text-025 text-026 into it_attach

SEPARATED By con_tab.

append it_attach.

sort t_output by lot_id ascending.

[Former Member]

solisti1 have only lenght 255 char.

increase it .it will work.

DATA: begin of it_attach occurs 0,

field1(1000),

end of itab.

FORM build_xls_data_table.

CONSTANTS : con_tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB,

con_cret type c value cl_abap_char_utilities=>CR_LF.

clear it_attach.

CONCATENATE text-006 text-018 text-007 text-008 text-009 text-010

text-011 text-012 text-013 text-020 text-014 text-015

text-016 text-017 text-019 text-021 text-022 text-023

text-024 text-025 text-026 into it_attach-filed1

SEPARATED By con_tab.

append it_attach.

null

[Former Member]

Hi kishan,

thnaks just now i seen it. how to increase the size.

is there any other standard structure like SOLISTI1 with more length.

thanks for patience.

[Former Member]

hi kishan,

problem solved.

thank you. closing the issue