Help Send internal table for email

Former Member — Wed, 19 Aug 2009 17:48:49 GMT

<head>

Hi,

</head>

<body>

I would like to know if anyone can help me sending an email that is giving me problems. The problem is that when I try to send it, this parts are Ok: body, header, attachment "file with one line", but when I open the file u201C.txtu201D the items appear separated by space and this happens when I send file with a line, if I do it with several lines everything works ok.

Example:

With one line:

V - H 2 8 6 - 0 4 5 7 , 2 0 0 7 0 3 2 8 , C A R

with many lines.

V-H286-0457, 20070328, CAR

the parameters that I'm sending.

LOOP AT it_tab.

DO.

ASSIGN COMPONENT sy-index OF STRUCTURE it_tab TO <field>.

IF sy-subrc <> 0.

EXIT.

ENDIF.

* Look for Commas in the field value. If it exists, put quotes around

* value so that the file opens correctly with all the columns aligned

* in Excel.

SEARCH <field> FOR ',' IN CHARACTER MODE.

* If search for commas are successful.

IF sy-subrc = 0.

CONCATENATE '"' <field> '"' INTO <field> IN CHARACTER MODE.

ENDIF.

IF sy-index = 1.

i_dload-dload = <field>.

SHIFT: i_dload-dload LEFT DELETING LEADING space.

ELSE.

* Put Comma as a separator for values in IT_DLOAD internal table

SHIFT: i_dload-dload LEFT DELETING LEADING space.

CONCATENATE i_dload-dload <field> INTO i_dload-dload

SEPARATED BY ',' IN CHARACTER MODE.

ENDIF.

ENDDO.

it_objbin = i_dload-dload.

APPEND it_objbin . CLEAR it_objbin.

ENDLOOP.

DESCRIBE TABLE it_objtxt LINES tab_lines.

CLEAR it_objpack-transf_bin.

it_objpack-head_start = 1.

it_objpack-head_num = 0.

it_objpack-body_start = 1.

it_objpack-body_num = tab_lines.

it_objpack-doc_type = 'RAW'.

APPEND it_objpack.

it_objpack-head_start = 1.

it_objpack-head_num = 0.

it_objpack-body_start = 1.

it_objpack-body_num = 1.

it_objpack-transf_bin = 'X'.

it_objpack-doc_type = 'TXT'.

it_objpack-obj_descr = w_filename.

it_objpack-obj_name = 'BILLING'.

it_objpack-doc_size = tab_lines * 255.

APPEND it_objpack.

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

EXPORTING

document_data = doc_chng

commit_work = 'X'

TABLES

packing_list = it_objpack

* object_header = it_objhead

contents_bin = it_objbin

contents_txt = it_objtxt

receivers = it_reclist

EXCEPTIONS

too_many_receivers = 1

document_not_sent = 2

operation_no_authorization = 4

OTHERS = 99.

Rgds

Richard

</body>

Edited by: Richard Carrasco on Aug 19, 2009 7:50 PM

Re: Help Send internal table for email

former_member194669 — Wed, 19 Aug 2009 18:16:00 GMT

Try this way


IF sy-index = 1.
i_dload-dload = .
*SHIFT: i_dload-dload LEFT DELETING LEADING space.

condense i_dload-dload.
ELSE.

*SHIFT: i_dload-dload LEFT DELETING LEADING space.
*CONCATENATE i_dload-dload INTO i_dload-dload
*SEPARATED BY ',' IN CHARACTER MODE.

concatenate i_dload-dload ';' into i_dload-dload.
condense i_dload-dload.

ENDIF.

PS I am not 100% sure about this

a®

topic Re: Help Send internal table for email in Application Development and Automation Discussions

Help Send internal table for email

Re: Help Send internal table for email