topic SO_NEW_DOCUMENT_ATT_SEND_API1 - xml in Application Development and Automation Discussions

SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Tue, 03 Oct 2006 06:43:23 GMT

hi All,

kindly advise, i saw many posting on this function, but i cannot find the topic about "doc_type" ?

I am trying to generated the attachment as XML, and sent out in an email.

*-Prepare OBJPACK for the ATTACHMENT1----

DESCRIBE TABLE attachment1 LINES tab_lines.

READ TABLE attachment1 INDEX tab_lines.

objpack-doc_size = ( tab_lines - 1 ) * 255

+ STRLEN( attachment1 ).

CLEAR objpack-transf_bin.

objpack-head_start = 1.

objpack-head_num = 0.

objpack-body_start = LINES( mailbody ) + 1 .

objpack-body_num = tab_lines.

objpack-doc_type = 'RAW'.

objpack-doc_type = 'xml'.

objpack-obj_descr = "myfile".

APPEND objpack.

when i use above codes, the attachment file name become "myfile.txt", but the file content is correct.

Each line there is linefeed, the length of each line varies with the content. Filesize is small.

when i change it to:

objpack-doc_type = 'XML'.

the attachement file name become "myfile.XML".

But file content is wrong. There is not linefeed for each line. Line2 is immediately append after line1. Each line's length is 255. Filesize is huge, due to those excess spaces.

I cannot send a "myfile.txt" to customer, asking him to change the extension back to ".xml".

Thanks in advance.

regards

Ee Siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

anversha_s — Tue, 03 Oct 2006 06:49:52 GMT

hi,

use this function to convert to xml format.

SAP_CONVERT_TO_XML_FORMAT

thenn send it it using email FM.

rgds

anver

if hlpe mark points

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

amit_khare — Tue, 03 Oct 2006 06:53:56 GMT

Hi,

check this Forum link.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/collaboration">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/collaboration</a>

Regards,

Amit

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Tue, 03 Oct 2006 07:01:44 GMT

I was hoping someone will tell me objpack-doc_type can continue to be 'RAW', with the filename ending with any extension that the programmer specified.

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Tue, 03 Oct 2006 07:23:30 GMT

Hi Ee Siong,

Check with the following Classes

CL_APL_ECATT_WDR_GEN_XML-Superclass for Generation of XML

CL_APL_ECATT_XML -eCATT Basis iXML Wrapper Class

Hope this could help you.

Thanks,

Prashanth

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Tue, 03 Oct 2006 08:11:04 GMT

if you on WAS6.10 or above its quiet simple to manipulate the file extension and email with cl_bcs classes. let me know if you need help with this.

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Tue, 03 Oct 2006 08:20:05 GMT

hi Raja, i only know i m on ECC5.0, can i use the feature u mentioned ? how to do it ?

regards

Ee Siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Tue, 03 Oct 2006 08:26:28 GMT

yes you can use it.

check this thread for code sample.

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Tue, 03 Oct 2006 12:46:02 GMT

hi Raja / everyone.

sorry if i asked a silly questions, caused i try to follow this "/people/thomas.jung3/blog/2004/09/08/sending-e-mail-from-abap--version-610-and-higher--bcs-interface to create the function, but it din compile correctly.

when i try to looking into the domains for something like ZES*, I cannot find any, does it mean my SAP installation/setup does not permit me to use cl_bcs to send emails ?

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Tue, 03 Oct 2006 12:53:04 GMT

ZES* are custom objects which the weblog author (Thomas Jung) had developed , for which he has given screen shots. for your scenario, you dont need to develope all of them.

may be check my code samples using cl_bcs that may give you some idea.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5931ff64-0a01-0010-2bb7-ff2f9a6165a0

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7f601a65-0a01-0010-16a5-c369f2a9fa87

also check out the demo programs in the system

BCS_EXAMPLE_1

BCS_EXAMPLE_2

BCS_EXAMPLE_3

BCS_EXAMPLE_4

BCS_EXAMPLE_5

BCS_EXAMPLE_6

Do let us know how it goes

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Sun, 08 Oct 2006 06:15:49 GMT

hi Raja/Everyone, thanks for your replies.

Now i am able to send email thru: cl_bcs.

But my problem is exactly that same as i started.

I attached 3 files to the mail.

*attachment1

REFRESH mailbody.

CONCATENATE lf 'my att1 line 1' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf 'my att1 line 2' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

documents-type = 'RAW'.

documents-content_text = mailbody.

documents-subject = 'my att1.xml'.

APPEND documents.

*attachment2

REFRESH mailbody.

CONCATENATE lf 'my att2 line 1' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf 'my att2 line 2' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

documents-type = 'TXT'.

documents-content_text = mailbody.

documents-subject = 'my att2.xml'.

APPEND documents.

*attachment3

REFRESH mailbody.

CONCATENATE lf 'my att3 line 1' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf 'my att3 line 2' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

documents-type = 'XML'.

documents-content_text = mailbody.

documents-subject = 'my att3.xml'.

APPEND documents.

....

CALL METHOD document->add_attachment

EXPORTING

i_attachment_type = documents_line-type

i_attachment_subject = documents_line-subject

i_att_content_text = documents_line-content_text.

....

resulted mail attachments:

RAW = "my att1.xml.TXT" - no extra space at each line, filesize small.

TXT = "my att2.xml.TXT" - each line exactly 255 chars, filesize big.

file3 = "my att2.xml.XML" - each line exactly 255 chars, filesize big.

Seems very difficult to send out ".xml" file as attachment. Only can send out ".txt" file.

Can you advise pls ?

May i know where to find documentation on possible values for i_attachment_type ?

Thanks in advance.

regards

Ee Siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Sun, 08 Oct 2006 09:17:32 GMT

attachment type is simply various file externsions.

.doc, .xls, .rtf, .xml, etc.

can you post your code here i can correct it and post it back here.

(just post the xml part alone, (how you are getting the xml and how you are passing the same as attachment to mail)

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Sun, 08 Oct 2006 09:47:30 GMT

hi Raja,

lf = cl_abap_char_utilities=>cr_lf.

REFRESH mailbody.

CONCATENATE lf '<?xml version="1.0"?>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<XOEINSUR_04OCT2006>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<order>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<item1>apple</item1>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<qty>10</qty>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '</order>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<order>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<item1>orange</item1>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '<qty>20</qty>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '</order>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

CONCATENATE lf '</XOEINSUR_04OCT2006>' INTO mailbody_wa-line.

APPEND mailbody_wa TO mailbody.

documents-type = 'XML'.

documents-content_text = mailbody.

documents-subject = 'my att5'.

APPEND documents.

LOOP AT documents INTO documents_line.

document = cl_document_bcs=>create_document(

i_type = documents_line-type

i_text = documents_line-content_text

i_subject = documents_line-subject ).

....

Thanks & regards

Ee Siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Sun, 08 Oct 2006 10:14:33 GMT

just create a report program and copy paste the following code and change the sender and receiver email address. save/activate and run the program.

*&---------------------------------------------------------------------*
*& Report  Y_TEST_XML_ATT
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  y_test_xml_att.
DATA: xml_string TYPE string .
DATA: send_request       TYPE REF TO cl_bcs.
DATA: text               TYPE bcsy_text ,
      text1              TYPE bcsy_text .
DATA: xtext TYPE STANDARD TABLE OF solix .
DATA: document           TYPE REF TO cl_document_bcs.
DATA: sender             TYPE REF TO if_sender_bcs.
DATA: recipient          TYPE REF TO if_recipient_bcs.
DATA: bcs_exception      TYPE REF TO cx_bcs.
DATA: sent_to_all        TYPE os_boolean.
DATA: conlength TYPE i ,
      conlengths TYPE so_obj_len ,
      result_content TYPE string .
*      subject TYPE so_obj_des .
DATA: e_r_page TYPE REF TO cl_rsr_www_page.
DATA: content_length	TYPE	w3param-cont_len ,
      content_type	TYPE	w3param-cont_type,
      return_code	TYPE	w3param-ret_code .

DATA: html TYPE STANDARD TABLE OF w3html .
DATA: server TYPE string ,
      port TYPE string .
DATA: wa_rec TYPE ad_smtpadr .
DATA: bcs_message TYPE string .
DATA: binary_content     TYPE solix_tab.
DATA: xl_content TYPE xstring .
DATA: atta_sub TYPE sood-objdes .


CLEAR xml_string .


CONCATENATE '<?xml version="1.0"?>'  '<XOEINSUR_04OCT2006>' '<order>' '<item1>apple</item1>' '<qty>10</qty>' '</order>' '<order>'  '<item1>orange</item1>'
 '<qty>20</qty>' '</order>' '</XOEINSUR_04OCT2006>' INTO xml_string .

CALL FUNCTION 'SCMS_STRING_TO_FTEXT'
  EXPORTING
    text      = xml_string
  TABLES
    ftext_tab = text.

TRY.
    CLEAR send_request .

    send_request = cl_bcs=>create_persistent( ).

    CLEAR document .
    APPEND 'Test' TO text1 .
    document = cl_document_bcs=>create_document(
                    i_type    = 'HTM'
                    i_text    = text1
                    i_subject = 'Test' ).

    atta_sub = 'myxmlfile' .
    CALL METHOD document->add_attachment
      EXPORTING
        i_attachment_type    = 'xml'
        i_attachment_subject = atta_sub
        i_att_content_text   = text.

*     add document to send request
    CALL METHOD send_request->set_document( document ).

    CLEAR sender .
    sender = cl_cam_address_bcs=>create_internet_address( 'xxxx@yahoo.com' ).
    CALL METHOD send_request->set_sender
      EXPORTING
        i_sender = sender.

    recipient = cl_cam_address_bcs=>create_internet_address( 'yyyy@yahoo.com' ).

*     add recipient with its respective attributes to send request
    CALL METHOD send_request->add_recipient
      EXPORTING
        i_recipient = recipient
        i_express   = 'X'.
    CALL METHOD send_request->set_status_attributes
      EXPORTING
        i_requested_status = 'E'
        i_status_mail      = 'E'.

    CALL METHOD send_request->set_send_immediately( 'X' ).
*     ---------- send document ---------------------------------------
    CALL METHOD send_request->send(
      EXPORTING
        i_with_error_screen = 'X'
      RECEIVING
        result              = sent_to_all ).
    IF sent_to_all = 'X'.
      write:/  'Mail sent successfully '.
    ENDIF.

    COMMIT WORK.

  CATCH cx_bcs INTO bcs_exception.
    bcs_message = bcs_exception->get_text( ).
    write:/ bcs_message .
    EXIT.

ENDTRY.

Do let me know how it goes.

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Sun, 08 Oct 2006 11:07:08 GMT

hi Raja,

I created a new program using the exact codes.

the xml file produced, when view in notpad:

< ? x m l v e r s i o n = " 1 . 0 " ? > < X O E I N S U R _ 0 4 O C T 2 0 0 6 > < o r d e r > a p p l e < q t y > 1 0 < / q t

regards

Ee Siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Sun, 08 Oct 2006 11:11:01 GMT

why do you want to view that in notepad? if you view the xml in internet explorer, you will see the exact hierarchy.

if you are still interested in viewing in notedpad with the line breaks, like in your code add cl_abap_char_utilities=>cr_lf between the elements.

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Sun, 08 Oct 2006 11:21:57 GMT

hi Raja, the file cannot be opened with IE.

The whole file only contain these:

< ? x m l v e r s i o n = " 1 . 0 " ? > < X O E I N S U R _ 0 4 O C T 2 0 0 6 > < o r d e r > a p p l e < q t y > 1 0 < / q t

thanks & regards

Ee Siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Sun, 08 Oct 2006 11:25:06 GMT

did you change anything in the code i have posted, i have tested the code before posting and it works fine.

after concatenation can you check whether the variable xml_string contains the whole xml?

Regards

Raja

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

Former Member — Sun, 08 Oct 2006 11:48:11 GMT

hi Raja,

thanks in advance. I used below code to output the variables to screen, the concatenation seems ok.

text2 TYPE bcsy_text with header line.

text2[] = text[].

WRITE:/ xml_string .

loop at text2.

WRITE:/ text2-line .

endloop.

<?xml version="1.0"?><XOEINSUR_04OCT2006><order><item1>apple</item1><qty>10</qty></order><order><item1>orange</item1><qty>20</qty></order></XOEINSUR_04OCT2006>

But mail attachment received:

< ? x m l v e r s i o n = " 1 . 0 " ? > < X O E I N S U R _ 0 4 O C T 2 0 0 6 > < o r d e r > a p p l e < q t y > 1 0 < / q t

Even in SCOT, in overview of send orders, when i export the attachment, the file is also truncated as above.

regards

ee siong

Re: SO_NEW_DOCUMENT_ATT_SEND_API1 - xml

athavanraja — Sun, 08 Oct 2006 11:53:05 GMT

did you just copy paste my code or made some modifications?

generally the kind of error which you are experiencing will happen if you passed a wrong values to I_ATTACHMENT_SIZE parameter of add attachment method.

also check the itab (after converting the string to table) whether its ok.

Regards

Raja