Send Mail Excel attachment program in SAP ABAP

Send Mail Excel attachment program in SAP ABAP.

DATA: lt_mailrecipients  TYPE STANDARD TABLE OF somlrec90 WITH HEADER LINE,

      lt_mailtxt         TYPE STANDARD TABLE OF soli      WITH HEADER LINE,

      lt_attachment      TYPE STANDARD TABLE OF solisti1  WITH HEADER LINE,

      lt_mailsubject     TYPE sodocchgi1,

      lt_packing_list    TYPE STANDARD TABLE OF sopcklsti1 WITH HEADER LINE,

      gv_cnt             TYPE i.

Add Recipients

lt_mailrecipients-rec_type  = 'U'.

lt_mailrecipients-com_type  = 'INT'.

lt_mailrecipients-RECEIVER  = 'someone@erpdb.info'.

APPEND lt_mailrecipients .

CLEAR lt_mailrecipients .

Put in the Mail Contents

lt_mailtxt = 'Hi How are you'.      APPEND lt_mailtxt. CLEAR lt_mailtxt.

lt_mailtxt = 'Here is a test mail'. APPEND lt_mailtxt. CLEAR lt_mailtxt.

lt_mailtxt = 'Thanks'.              APPEND lt_mailtxt. CLEAR lt_mailtxt.

Create the attachment

  DATA: BEGIN OF lt_po_data_cons OCCURS 0,

         ebeln LIKE ekpo-ebeln,

         ebelp LIKE ekpo-ebelp,

        END OF lt_po_data_cons.

  SELECT ebeln ebelp INTO TABLE lt_po_data_cons

  UP TO 10 ROWS

  FROM ekpo. 

  CLASS cl_abap_char_utilities DEFINITION LOAD.

  CONCATENATE 'PO' 'PO Line'

              INTO lt_attachment SEPARATED BY

              cl_abap_char_utilities=>horizontal_tab.

  APPEND lt_attachment. CLEAR lt_attachment.

  LOOP AT lt_po_data_cons.

  CONCATENATE lt_po_data_cons-ebeln lt_po_data_cons-ebelp

              INTO lt_attachment SEPARATED BY

              cl_abap_char_utilities=>horizontal_tab.

  CONCATENATE cl_abap_char_utilities=>newline lt_attachment

              INTO lt_attachment.

  APPEND lt_attachment. CLEAR lt_attachment.

 ENDLOOP.

Pack the mail contents and attachment

 lt_packing_list-transf_bin  = SPACE.

  lt_packing_list-head_start  = 1.

  lt_packing_list-head_num    = 0.

  lt_packing_list-body_start  = 1.

  lt_packing_list-body_num    = LINES( lt_mailtxt ).

  lt_packing_list-doc_type    = 'RAW'.

  APPEND lt_packing_list. CLEAR lt_packing_list.

  lt_packing_list-transf_bin  = 'X'.

  lt_packing_list-head_start  = 1.

  lt_packing_list-head_num    = 1.

  lt_packing_list-body_start  = 1.

  lt_packing_list-body_num    = LINES( lt_attachment ).

  lt_packing_list-doc_type    = 'XLS'. " You can give RAW incase if you want just a txt file.

  lt_packing_list-obj_name    = 'data.xls'.

  lt_packing_list-obj_descr   = 'data.xls'.

  lt_packing_list-doc_size    = lt_packing_list-body_num * 255.

  APPEND lt_packing_list. CLEAR lt_packing_list.

  lt_mailsubject-obj_name     = 'MAILATTCH'.

  lt_mailsubject-obj_langu    = sy-langu.

  lt_mailsubject-obj_descr    = 'You have got mail'.

  lt_mailsubject-sensitivty   = 'F'.

  gv_cnt = LINES( lt_attachment ).

  lt_mailsubject-doc_size     = ( gv_cnt - 1 ) * 255 + STRLEN(

  lt_attachment ).

Finally, send the mail out.

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

    EXPORTING

      document_data              = lt_mailsubject

    TABLES

      packing_list               = lt_packing_list

      contents_bin               = lt_attachment

      contents_txt               = lt_mailtxt

      receivers                  = lt_mailrecipients

    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.

  IF sy-subrc EQ 0.

    COMMIT WORK.

    SUBMIT rsconn01 WITH MODE = 'INT' AND RETURN.

  ENDIF.

AL11 ,CG3Y, CG3Z, CACS_FILE_COPY, download and copy and delete file application server in SAP .

SAP ABAP  AL11 ,CG3Y, CG3Z, CACS_FILE_COPY  details.

AL11 ,CG3Y, CG3Z, CACS_FILE_COPY  details.

AL11 T-Code meanly used for the controlling to store file in the application server. All the file directories you can see in the AL11 .This step can be done in AL11 transaction for uploading, downloading and deleting files.

Below are details step you can see.

Uploading a file in Al11 Directory in SAP.

Step 1: Located the file location in which we have to upload the file.

 

Step 2: Next->GO to-> CG3Z this is for uploading the file in AL11 directory.

Step 3: Write you’re the source location for file from the front end system and the target file location in the AL11 directory. Next you click Upload Button.

·         When you transfer your file this Transfer file format for Data ( by default, it is set to BIN for Binary)

·         If you want overwrite file check this checkbox.

·         This is the below message will be display.

Now directory will contain the uploaded file.

You can see text file will be uploaded.

---

Next step is downloading a file from AL11 directory in SAP.

Step 1: At first you select your file which you want to download in your local system.

Step 2: Next ->>GO TO->> CG3Y.

Step 3: You write your source location and the target location where you can store your file after you click on download button.

When you’re downloaded successfully you can get below message.

---

Next step is deleting a file in AL11 directory in SAP.

Step 1: Go to àSE37, after enter Function module name EPS_DELETE_FILE after click on the execute button.

Step 2: Next ->put your file name and file path-> FILE_NAME and the directory path in the DIR_NAME and execute.

 

After you get  deleted successfully message.

---

SAP Copy File with CACS_FILE_COPY in SAP.

This T-Code CACS_FILE_COPY is very helpful also.
If you want to copy File Application to Presentation Server and Presentation to Application. This time you can use This T-Code CACS_FILE_COPY SAP Standard.

First you set your Copy direction

·         Application To Presentation Server

·         Presentation Server to Application

And set your file source and file destination details.