Spool Setting for page format

[Former Member]

Hi all,

My requirement is to schedule a standar program (RFITEMAP) in background, and a mail should trigger with the output in .txt format, which is working fine.

But all data are not getting displayed only Page 1 to 20 is displayed in the mail .txt. when i go and check the spool sp01, all data is displayed.

Kindly advice how to display all data in the mail attachement .

Regards,
Rahul

[Former Member]

Submit standar program (RFITEMAP) exporting list to memory.

GET_LIST_FROM_MEMORY

Convert to text or html

mail by CL_BCS.

Regards,

Clemens

[Clemenss]

Submit standar program (RFITEMAP) exporting list to memory.

GET_LIST_FROM_MEMORY

Convert to text or html

mail by CL_BCS.

Regards,

Clemens

[Former Member]

Hi Clemens Li,

But i am using a standard program, just assigned that program and created a variant and schedule in backgroun through T-Code: SM36.

Now how can i create code in standard program.

Regards,

Rahul.

[former_member213851]

Hi Rohini,

May be you can try using FM SO_DOCUMENT_SEND_API1 .It works prfectly for all size and types of  attatchments.

Best Regards,

Sachin

[Former Member]

Refer this piece.

DATA list_tab TYPE TABLE OF abaplist.   

SUBMIT your_report EXPORTING LIST TO MEMORY  AND RETURN.

CALL FUNCTION 'LIST_FROM_MEMORY'  

         TABLES      listobject = list_tab   

         EXCEPTIONS      not_found  = 1     

                                   OTHERS     = 2.   

DATA string_tab TYPE list_string_table.  "use table type appropriate for attachment 

DATA ascii_tab TYPE soli_tab.   

CALL FUNCTION 'LIST_TO_ASCI'  TABLES    

listasci                 = ascii_tab    

listobject               = list_tab.   

DATA go_email_doc TYPE REF TO cl_document_bcs.

    go_email_doc = cl_document_bcs=>create_document(               i_type = 'TXT'   

                                                                                                  i_text    = text

                                                                                                                        ).

    go_email_doc->add_attachment( i_attachment_type = 'TXT'   

                                                    i_attachment_subject = 'My Attachment'    

                                                    i_att_content_text = ascii_tab ). 

CALL METHOD send_request->set_document( document ).

Check report BCS_EXAMPLE_5 if you want help with BCS.

Thanks,

Shambu

[Jelena_Perfiljeva]

Well, this is an ABAP forum, so it's easy to assume that some kind of a programming solution is expected.

I can only guess that email distribution is through the 'Spool list recipient' in SM36 and that your system is set up to send such emails with TXT attachments (HTML may also be used to preserve formatting). If so, then I also can only guess that perhaps by accident in the print options (either in the job or in the defaults for the user ID) it was set to print only pages 1 through 20. Otherwise such effect would be highly unusual.

Check if this happens with other reports / users. But in SP01 actually only the first 10 pages are displayed, I believe.

[DavidLY]

Hello,

Check SAP note 329537.

Regards,

David

[Former Member]

Hi David,

My issue is ressolved because of this Note. I was stucked with this issue for such a long day.

Thank You very much.

Regards,

Shegar.

[lcl1964]

Thanks a lot! It solved my issue.

Regards, Lucia