topic Urgent : - Some Error in code while sending attachment thru SAP in Application Development and Automation Discussions

Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:01:42 GMT

hiii,

i have posted a problem in the following thread.

at some extent Surpreet is able to solve the problem, but now we r stuck to this that email is coming with attachment but not the exact that i am attching and trying to send the mail.

can any one check this code and rectify if any error is there.



REPORT YBALTEST.

DATA: gd_cnt TYPE i,
gd_sent_all(1) TYPE c,
gd_doc_data LIKE sodocchgi1,
gd_error TYPE sy-subrc.


DATA: it_message LIKE solisti1 OCCURS 0 WITH HEADER LINE,
it_packing_list LIKE sopcklsti1 OCCURS 0 WITH HEADER LINE,
it_contents LIKE solisti1 OCCURS 0 WITH HEADER LINE,
it_receivers LIKE somlreci1 OCCURS 0 WITH HEADER LINE,
it_attachment LIKE solisti1 OCCURS 0 WITH HEADER LINE.

* Binary store for PDF
DATA: BEGIN OF it_pdf_output OCCURS 0,
row(255).
DATA: END OF it_pdf_output.

START-OF-SELECTION.
perform send_email_message .

*&---------------------------------------------------------------------*
*& Form SEND_EMAIL_MESSAGE
*&---------------------------------------------------------------------*
* Send email message
*----------------------------------------------------------------------*
FORM send_email_message.
DATA: tab_lines LIKE SY-TABIX.

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = 'C:test.pdf'
filetype = 'BIN'
TABLES
data_tab = it_pdf_output .

* Populate the subject/generic message attributes
concatenate 'Attached is the '
' are waiting for.' into it_message.
append it_message.

DESCRIBE TABLE it_message LINES tab_lines.
READ TABLE it_message INDEX tab_lines.

gd_doc_data-doc_size = ( tab_lines - 1 ) * 255 + STRLEN( it_message ).
gd_doc_data-obj_langu = sy-langu.
gd_doc_data-obj_name = 'SENDFILE'.
gd_doc_data-obj_descr = 'Attachement'.
gd_doc_data-sensitivty = 'O'.

describe table it_pdf_output lines tab_lines.
* Describe the body of the message

CLEAR it_packing_list-transf_bin.
it_packing_list-head_start = 1.
it_packing_list-head_num = 0.
it_packing_list-body_start = 1.
it_packing_list-doc_type = 'RAW'.
it_packing_list-body_num = tab_lines.
APPEND it_packing_list.

describe table it_pdf_output lines tab_lines.

CLEAR it_packing_list.
it_packing_list-transf_bin = 'X'.
it_packing_list-head_start = 1.
it_packing_list-head_num = 1.
it_packing_list-body_start = 1.
it_packing_list-doc_type = 'RAW'.
it_packing_list-body_num = tab_lines.
it_packing_list-doc_size = tab_lines * 255.
it_packing_list-OBJ_DESCR = ' object '.
it_packing_list-obj_name = 'MAIL'.
APPEND it_packing_list.

it_receivers-receiver = 'sbal@.com'.
it_receivers-rec_type = 'U'.
it_receivers-com_type = 'INT'.
APPEND it_receivers .

* Call the FM to post the message to SAPMAIL
CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'
EXPORTING
document_data = gd_doc_data
* put_in_outbox = 'X'
commit_work = 'X'
* IMPORTING
* sent_to_all = gd_sent_all
TABLES
packing_list = it_packing_list
contents_txt = it_message
contents_bin = it_pdf_output
receivers = it_receivers
EXCEPTIONS
too_many_receivers = 1
document_not_sent = 2
document_type_not_exist = 3
operation_no_authorization = 4
parameter_error = 5
x_error = 6
enqueue_error = 7
OTHERS = 8.
ENDFORM. " SEND_EMAIL_MESSAGE

thanx

abhishek suppal

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:10:47 GMT

one error i left

describe table it_pdf_output lines tab_lines.

Describe the body of the message

CLEAR it_packing_list-transf_bin.

it_packing_list-head_start = 1.

it_packing_list-head_num = 0.

it_packing_list-body_start = 1.

it_packing_list-doc_type = 'RAW'.

it_packing_list-body_num = tab_lines.

APPEND it_packing_list.

describe table it_pdf_output lines tab_lines

delete first describe

although it will not remove the error we are facing

regards

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:14:23 GMT

What are you getting as the attachment? Is it just unreadable or some other pdf document?

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:17:00 GMT

just unreadable

like this

€¥ä™„ã„ã˜®â”î¢íà¨ãˆ±ãŒ¸ã€ æ¼ æ©¢ã° â¼¼æ¥Œæ•®ç‰¡ç©©æ‘¥ã„ ä°¯ãŒ ã”²ã˜²â¼¶âãˆ±ãœ¸ä”¯ã ã¤·ã´ä¸¯ãˆ â¼¹â”ã¤²ã”¹ã€´ä ¯å¬ ã„ ã˜µâ€·ãˆ¹å´¶ã¸¾æ”æ‘®æ‰¯àµªâ€ â€ â€ â€ â€ à¨ç‰¸æ™¥à¨ãˆ±ãŒ¸ã˜ à´±ã€Šã€°ã€°ã€°ã„°â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ°ã¤¶â€¹ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ°ãŒ¸â€·ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ°ãœ±â€³ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ°ãŒ³â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ°ã µâ€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ°ã„¶â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ°ã€¸â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ°ã ¸â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜°ã”µâ€±ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ´ãµâ€¹ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ´ãˆ¶â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ´ã€·â€³ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ´ã˜¸â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ´ãˆ¹â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ´ã °â€´ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ´ãŒ±â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ´ã³â€µã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ´ã„µâ€¸ã€°ã€°â€°àµ®

ã€Šã€°ã€°ãŒ´ãœµâ€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ´ã·â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ãŒ´ã¹â€µã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ã€±â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ã˜±â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ãŒ³â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ãŒ´â€¹ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ã¤´â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ã¤µâ€´ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ãŒ¶â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ã˜·â€´ã€°ã€°â€°àµ®ã€Šã€°ã€°ã´ã„¸â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ãˆ°â€´ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ã”²â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ã ³â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ã´â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ãœµâ€·ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ãŒ¶â€±ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ã ¶â€µã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ãŒ·â€¹ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ã€¹â€·ã€°ã€°â€°àµ®ã€Šã€°ã€°ã”´ã˜¹â€±ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ã€²â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ã˜²â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ã€µâ€·ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ã˜µ

â€±ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ãŒ·â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ã¤·â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ã˜´ã˜¹â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ã„°â€¶ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ãœ°â€°ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ãˆ±â€´ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ã ²â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ã³â€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ãœ´â€¸ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ãŒµâ€²ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ãŒ·â€·ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ã¤·â€±ã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ã¸â€µã€°ã€°â€°àµ®ã€Šã€°ã€°ãœ´ã¤¸â€¹ã€°ã€°â€°àµ®ã€Šã€°ã€°ãˆ°ã¤´â€³ã€°ã€°â€°àµ®ã€Šã€°ã€°ã„°ã˜µâ€·ã€°ã€°â€°àµ®çŠæ…²æ±©ç‰¥à¨ã°¼åŒ¯ç©©â¥ãŒ±ã´å€¯æ•²â¶ã¤²ã”¹ãœ²å ¯æ•’å¦æµ´ãˆ ã¤´â¼³æ½’ç‘¯ã„ ã ²â€µâ€°â½’æ¹…ç‰£ç¹â´ãˆ±ã¸ã€ åˆ ä¤¯æ™®â¯ã˜²â€³â€°â½’ä‘‰ã±›ã‰†ã„·ã€µã„±ãˆ²ã†ä•‚ä‘ƒä‰„ãœµä„³äŒ¸ãˆ¹ã„°ãˆ±ä˜±ã°¾ã”°ã¤°äŒ±ã…ãäŒ¹ãœ³äˆ´ä‰ã™‚ä´äŒµãœ·ä‘‚ãä™å´¾ã¸¾à¨ç‘³ç‰¡ç¡´æ•²àµ¦ã€Š

à¨â”¥ä½…àµ†â€Šâ€ â€ â€ â€ â€ â€ â€ â€ â€ â€ â€ â€ à´ ã„Šã³â€³â€°æ‰¯ã±ªâ¼¼æ•Œæ®æ¡´ã ã„²äŒ¯ã„ ãˆ³â¼·æ¥†ç‘¬ç‰¥ä˜¯æ…¬æ•´æ•„æ½£æ•¤ä¤¯ã„ ã´â¼²âŒãŒ±ã„±ä¼¯ã„ ã¤²â¼µâ“ã”¹ã¸¶çŒ¾ç‰´æ…¥àµ#í’œé·¾å§î”˜å‘ï¼‰á½ï‰¡ë‘ç›¿ï‡¼##á¼½ìŠ‚â’·ê–“âŽ‡â†¦â®æ†ºà®ŒíŽ™#ëŸ¼ë´ ä·ä¦“îŒˆë½‰ìš°Ø‰æ‚©ë¶£èµ¤èŒ¾é™à·å‡‡á®€à§ªê™«é¢ë‘„åª¸ì¯¨ä¶”â£‚î¡ä”í…†î“®ä“—é¿¦ì½›æžáŠé®½î‹™äŠæŸ¾ï‰ä˜šî ‚ã¥ªæ±£ï…¯ç±½é¡ƒç¨•âªˆä»ê‰ç„“ï·–ä¤˜à³®äŸœé§‚ãƒè©ä ƒæ¡¸î„¦â›³îºç©·ë†¿äŠ¹êŒêºž×¥æ£êŠ½îºŽ#çµ¥ì‡’ë€åŠ’í˜£ê¸¤îªµã¬ä®§î®ºä‰ã•´î´ç®¨ä”ˆé²ãŸ†êƒ¬î‘ã®å±¤#å€‹é¡ƒæŽå¯¶íž£ä–•à£ªå£ƒä˜â¬ç®²é¼¨í†äœ½é´”ïš·ï‹éƒ¶ì‹¥çŒ‘ë°‰ë°´â‚‡à¹¸é±¤ä‡é®‹æ®¢é”´ã€Šë±ä•»ï±ªÚ„ì·“ç”›ëŠ¢æ¿ á¼žå·»ë€¸âšë¯‡áµ¢æŠî€â¢®ï¥ì£¦î’ë¡¹ê’¼æ¾ é¢¹å‚‹äªè¨¹è‹ê·Žä‰½ì‘Äâ¤é»—î²±â‰æš£ë²¨è™„î‚»å‡¾#è¾ï®”

ê»†íŽ½î¼žã¥†â½›ä†ºã¬¸ïžœç²ï¥šã¤“ê’œè

regards

Message was edited by: Surpreet Singh Bal

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:21:34 GMT

yes something like this is getting in the attachment file.

also surpreet i have done something

CLEAR it_packing_list.
  it_packing_list-transf_bin = 'X'.
  it_packing_list-head_start = 1.
  it_packing_list-head_num = 1.
  it_packing_list-body_start = 1.
  it_packing_list-doc_type = 'RAW'.
  it_packing_list-body_num = tab_lines.
  it_packing_list-doc_size = tab_lines * 255.

*  it_packing_list-obj_descr = ' object '.

  it_packing_list-obj_descr = 'test.pdf'.
  it_packing_list-obj_name = 'MAIL'.
  APPEND it_packing_list.

by doing so we can get the exact file name, .

abhishek suppal

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:24:55 GMT

Does your internet email node allow PDF type documents to be sent? Check in transaction SCOT for the node, if *.pdf is there.

Srinivas

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:29:02 GMT

yes srinivas its there in scot

and also surpreet i have just check it for txt file it is going well, but for pdf file its something like the above format, may be i thing i have just debug the function GUI_UPLOAD the internal table got all the data in binary format may be we have to see there....

abhishek suppal

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:54:01 GMT

Hi Abhisek

I am pasting the exact code which will work.

REPORT YBALTEST.

DATA: gd_cnt TYPE i,

gd_sent_all(1) TYPE c,

gd_doc_data LIKE sodocchgi1,

gd_error TYPE sy-subrc.

DATA OBJBIN LIKE SOLISTI1 OCCURS 0 WITH HEADER LINE.

DATA: it_message LIKE solisti1 OCCURS 0 WITH HEADER LINE,

it_packing_list LIKE sopcklsti1 OCCURS 0 WITH HEADER LINE,

it_contents LIKE solisti1 OCCURS 0 WITH HEADER LINE,

it_receivers LIKE somlreci1 OCCURS 0 WITH HEADER LINE,

it_attachment LIKE solisti1 OCCURS 0 WITH HEADER LINE.

Binary store for PDF

DATA: BEGIN OF it_pdf_output OCCURS 0,

row(255).

DATA: END OF it_pdf_output.

START-OF-SELECTION.

perform send_email_message .

&----

*& Form SEND_EMAIL_MESSAGE

&----

Send email message

----

FORM send_email_message.

DATA: tab_lines LIKE SY-TABIX.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'C:\test.pdf'

filetype = 'BIN'

TABLES

data_tab = it_pdf_output .

Populate the subject/generic message attributes

concatenate 'Attached is the '

' are waiting for.' into it_message.

append it_message.

DESCRIBE TABLE it_message LINES tab_lines.

READ TABLE it_message INDEX tab_lines.

gd_doc_data-doc_size = ( tab_lines - 1 ) * 255 + STRLEN( it_message ).

gd_doc_data-obj_langu = sy-langu.

gd_doc_data-obj_name = 'SENDFILE'.

gd_doc_data-obj_descr = 'Attachement'.

gd_doc_data-sensitivty = 'O'.

describe table it_pdf_output lines tab_lines.

Describe the body of the message

CLEAR it_packing_list-transf_bin.

it_packing_list-head_start = 1.

it_packing_list-head_num = 0.

it_packing_list-body_start = 1.

it_packing_list-doc_type = 'RAW'.

it_packing_list-body_num = tab_lines.

APPEND it_packing_list.

loop at it_pdf_output.

move it_pdf_output-row to objbin-line.

append objbin.

endloop.

describe table objbin lines tab_lines.

CLEAR it_packing_list.

it_packing_list-transf_bin = 'X'.

it_packing_list-head_start = 1.

it_packing_list-head_num = 1.

it_packing_list-body_start = 1.

it_packing_list-doc_type = 'PDF'.

it_packing_list-body_num = tab_lines.

it_packing_list-doc_size = tab_lines * 255.

it_packing_list-OBJ_DESCR = ' object '.

*it_packing_list-obj_name = 'MAIL'.

APPEND it_packing_list.

it_receivers-receiver = 'sanjay.sinha@.com'.

it_receivers-rec_type = 'U'.

it_receivers-com_type = 'INT'.

APPEND it_receivers .

Call the FM to post the message to SAPMAIL

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

EXPORTING

document_data = gd_doc_data

put_in_outbox = 'X'

commit_work = 'X'

IMPORTING
sent_to_all = gd_sent_all

TABLES

packing_list = it_packing_list

contents_txt = it_message

contents_bin = objbin

receivers = it_receivers

EXCEPTIONS

too_many_receivers = 1

document_not_sent = 2

document_type_not_exist = 3

operation_no_authorization = 4

parameter_error = 5

x_error = 6

enqueue_error = 7

OTHERS = 8.

ENDFORM. " SEND_EMAIL_MESSAGE

Cheers

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 03:58:06 GMT

yes sanjay

you are right i missed to put data in objbin-line

regards

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 04:07:06 GMT

It will work even if you dont use OBJBIN . Just comment the following line in your original code -

it_packing_list-obj_name = 'MAIL'.

However it is a good practice to pass compatible / similar parameters to FM.

Cheers

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 05:38:51 GMT

yes it works,

important point

doc_type = 'PDF'.

regards

thanks sanjay, abhi please close your both threads

Re: Urgent : - Some Error in code while sending attachment thru SAP

Former Member — Tue, 20 Sep 2005 06:02:44 GMT

yes surpreet

doc_type = 'PDF'

is the main thing

and also i have checked it for excel file putting

doc_type = 'XLS'

and for Word file

doc_type = 'DOC'

it works fine....

thanx sanjay and surpreet for ur efforts

ya sure i am going to close both threads and reward the points..

abhishek suppal