Skip to Content
author's profile photo Former Member
Former Member

send ALV-GRID Output as EXCEL-Attachment

Hello,

i have written a Report with ALV-GRID output. This output

is via Layout-Variant an Excel-sheet.

Now my Problem: I send this output as an Attachment

to an internet-Address (name@name.de). The Attachment

is in ALI and will be change via scon to HTML.

Is it Possible to send this Attachment as an EXCEL-Attachment?

Thanks for help.

Regards, Dieter

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:35 PM

    Hai

    Check the following Links

    In your ALV program after the alv output is build in the program do the following steps.

    1). Export the list to memory

    2). Import the list from mempry

    3). Do a COmpress of the data

    4). Send an email as an attachment using the normal FM.

    Take a look at the following links which will explain how to do the above steps.

    http://www.geocities.com/mpioud/Z_EMAIL_ABAP_REPORT.html

    http://www.thespot4sap.com/Articles/SAP_Mail_SO_Object_Send.asp

    http://www.sapdevelopment.co.uk/reporting/email/attach_xls.htm

    remember to change the doc type as 'HTM' in the FM to send email

    what you could do is , replace all @xx@ with the url for the same from the BSP mime repository

    (url pattern will be

    http://applicationserver.domain.com:port/sap/public/bsp/sap/public/bc/icons/ )

    but this would pose another issue, when the user opens the mail this would require authentication info for logging on to sap and get the MIME

    Regards

    Sreeni

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:32 PM

    have you written the code to send mail in the program ??

    by using "SO_NEW_DOCUMENT_ATT_SEND_API1" ??

    if so,

    IN the OBJPACK, DOC_TYPE change to XLS.

    IT_OBJPACK-DOC_TYPE = 'XLS' .

    regards

    srikanth.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Srikanth,

      no, it's an normal Report with GRID-output.

      In the Output-Window is a Send -Button wich i use.

      Regards, dieter