topic To send mails to different users from 1 program in Application Development and Automation Discussions

To send mails to different users from 1 program

Former Member — Fri, 04 Jan 2008 14:46:06 GMT

Hi,

I need to send a mail to different users...Depending upon the conditions.

I have one internal Table Having 10 fields .

Suppose i have 6 records in the internal table ITAB.

I am passing this internal table to function module

'REUSE_ALV_GRID_DISPLAY'.

and I am getting 6 records in the output having 10 fields.

Suppose this is the format:-

AAA A C

AAA B D

AAA C E

BBB A C

CCC A C

DDD A C

In this case we need to send first 3 records to 1 person

4th record to another person

5th record to someone

6th record to someone else

We need to send the mail in below format:-

From: Mamta

To: (Name of the requestor)

subject: sub

some text Jan 4, 2008

========================================

===

Field1 : AAA

Field4 : some text

Field5 : some text

---

Field3 field6 field7 field8 field 9

---

Value Value Value Value Value

of Field3 of Field6 of Field7 of Field8 of Field9

---

some text

Thankyou,

Mamta Gupta

Please tell me how to do this...

I need this as soon as possible.

Thanks & Regards,

Mamta

Re: To send mails to different users from 1 program

former_member239282 — Fri, 04 Jan 2008 14:58:40 GMT

Sending an email to the Microsoft Inbox is a way of interacting with a non SAP system through ABAP code and hence is very interesting. A fair knowledge of UNIX shell scripting is assumed here.

The ABAP code to send an email to Microsoft inbox revolves around following UNIX script

Echo "From:" "<"$1">" > <unix file path name>

Echo "To:" "<"$2">" >> <unix file path name>

Echo "Subject:" "<"$3">" >> <unix file path name>

Cat $4 >> <unix file path name>

Uuencode $5 $6 >> <unix file path name>

Cat <unix file path name> | /usr/sbin/sendmail –f $fraddr $toaddr

(Note : the commands in the above script can be case sensitive. Check the actual case on the unix installation in question)

Let us understand the various parts of the above script.

$1 = Sender email address

$2 = Recipient email address

$3 = Subject of the email

$4 = Path of unix server file having email body

Form email body as an internal table in ABAP program, download it to a unix server file

$5 = Path of unix server file to be sent as email attachment

$6 = Name to be given to the attachment (like test1.doc, test1.xls). The corresponding Microsoft icon

will be shown in the email for the type of file attached ( Word document, excel document etc)

The script builds a temporary file and pipes the file to the sendmail command to achieve the mission.

This script can be invoked from SAP to send the mail to the intended recipient. Store this small script on the unix server. (Assume script name is sndmail )

To do this we should define a link in the SAP system between a customized command and this unix script.

The FM to define a customized command in SAP system has the following pattern.

call function 'SXPG_CALL_SYSTEM'

exporting

commandname =

PARAMETERS = ' '

importing

status =

tables

exec_protocol =

exceptions

no_permission = 1

command_not_found = 2

parameters_too_long = 3

security_risk = 4

wrong_check_call_interface = 5

program_start_error = 6

program_termination_error = 7

x_error = 8

parameter_expected = 9

too_many_parameters = 10

illegal_command = 11

others = 12.

Below an EXAMPLE:

REPORT ZTSAPMAIL.

DATA: X_OBJECT_TYPE LIKE SOOD-OBJTP.

DATA: BEGIN OF X_OBJECT_HD_CHANGE.

INCLUDE STRUCTURE SOOD1.

DATA: END OF X_OBJECT_HD_CHANGE.

DATA: BEGIN OF X_OBJCONT OCCURS 10.

INCLUDE STRUCTURE SOLI.

DATA: END OF X_OBJCONT.

DATA: BEGIN OF X_OBJHEAD OCCURS 0.

INCLUDE STRUCTURE SOLI.

DATA: END OF X_OBJHEAD.

DATA: BEGIN OF RAW_HEAD.

INCLUDE STRUCTURE SORH.

DATA: END OF RAW_HEAD.

DATA: BEGIN OF X_RECEIVERS OCCURS 0.

INCLUDE STRUCTURE SOOS1.

DATA: END OF X_RECEIVERS.

PARAMETERS: RECEIVER LIKE X_RECEIVERS-RECNAM. " Name

*BUILD MESSAGE HEADER

MOVE 'Sort field goes here' TO X_OBJECT_HD_CHANGE-OBJSRT. " Sort field

MOVE 'Name of the object goes here' TO X_OBJECT_HD_CHANGE-OBJNAM. " Name

MOVE 'Document title goes here' TO X_OBJECT_HD_CHANGE-OBJDES. " Title

MOVE 'F' TO X_OBJECT_HD_CHANGE-OBJSNS. " Functional OBJECT

MOVE 'E' TO X_OBJECT_HD_CHANGE-OBJLA. " Language

Object type of the new document

MOVE 'RAW' TO X_OBJECT_TYPE.

CLEAR X_OBJCONT.

MOVE 'Contents of mail' TO X_OBJCONT-LINE.

APPEND X_OBJCONT.

CLEAR X_OBJCONT-LINE. APPEND X_OBJCONT.

MOVE 'More contents' TO X_OBJCONT-LINE.

APPEND X_OBJCONT.

MOVE 'Still more contents'

to x_objcont-line.

APPEND X_OBJCONT.

MOVE ' ' TO X_OBJCONT-LINE.

APPEND X_OBJCONT.

Specific header (Dependent on the object type, here RAW)

REFRESH X_OBJHEAD.

DESCRIBE TABLE X_OBJCONT LINES RAW_HEAD-RAWSIZ.

MOVE RAW_HEAD TO X_OBJHEAD.

APPEND X_OBJHEAD.

*RECEIVERS table

CLEAR X_RECEIVERS.

REFRESH X_RECEIVERS.

MOVE RECEIVER TO X_RECEIVERS-RECNAM. " Name

MOVE 'B' TO X_RECEIVERS-RECESC. " Receiver type

MOVE 'X' TO X_RECEIVERS-SNDCP. " Send as a copy

MOVE 'X' TO X_RECEIVERS-SNDEX. " EXPRESS DOCUMENT

APPEND X_RECEIVERS.

CALL FUNCTION 'SO_OBJECT_SEND'

EXPORTING

folder_id = 'OUTBOX'

forwarder = x_forwarder

object_fl_change = x_object_fl_change

OBJECT_HD_CHANGE = X_OBJECT_HD_CHANGE

object_id = x_object_id

OBJECT_TYPE = X_OBJECT_TYPE

OUTBOX_FLAG = 'X'

OWNER = SY-UNAME

store_flag = x_store_flag

importing

object_id_new = x_object_id_new

sent_to_all = x_sent_to_all "May need to use

TABLES

OBJCONT = X_OBJCONT

OBJHEAD = X_OBJHEAD

objpara = x_objpara

objparb = x_objparb

RECEIVERS = X_RECEIVERS.

if helpful reward points are appreciated !

Re: To send mails to different users from 1 program

Former Member — Fri, 04 Jan 2008 15:20:08 GMT

Hi,

I need this without using unix script. It is possible without using unix script also.

Please help me in this regard.

Regards,

Mamta

Re: To send mails to different users from 1 program

former_member239282 — Fri, 04 Jan 2008 15:38:14 GMT

The ABAP code to send a sap mail is built around the FM SO_OBJECT_SEND

The main parameters and table interfaces of the FM

Import Parameters Name and Description Field name Field function

Object_hd_change (structure)Contains the process to be done when SAP mail is marked for execution.

When the Execute Icon in the SAP mail is clicked the corresponding object is executed

vmtyp ‘D’ for dialog module

‘F’ for function module

‘R’ for report

‘T’ for transaction

‘U’ for transaction with export

Acnam Name of the object which is to be executed, like name of transaction/report

Skips ‘X’ to execute first screen in background

Objsns Indicates sensitivity of the object.

‘P’ for private object

‘F’ for functional object

‘O’ for confidential object

‘C’ for company confidential object

Sensitivity level is restricted to ‘O’ for documents in shared folders

Objla Language of the document

‘E’ for English

sy-langu for system language

Objnam Name of the document

Objdes Short description (Title) of the document

Objsrt Name of the sort field. This is used to group documents based on certain criteria

Object_type

Type of document to be sent with mail

‘RAW’ for raw text (default)

‘DOC’ for word file

‘XLS’ for excel file

All classes can be used except for folders (‘FOL’) and distribution lists (‘DLI’)

Outbox_flag ‘X’ to indicate that mail should also be stored in outbox of the user after sending (default ‘ ‘)

Owner Sap login of the user responsible for transmission

Table Parameters Name and Description Field Name Field function

Objcont

Table to hold the body of the mail

Line Text lines up to 255 characters

ObjheadTable to hold number of lines in the body of the mail, i.e size of the table in lines

Line Text lines up to 255 characters

ObjparaTable to hold the set/get parameters to be transferred to the processing element

Name Name of the parameter. Only first three characters are used

Option Not used

Low Value of the parameter in name

High Not used

Objparb

Table to hold information for mails to which a certain processing type is assigned. For a report or transaction with transfer of values to global memory, the table has to contain the parameters with relevant values. The memory id is taken from the first row. For a FM or dialog module, data in table will be transferred as table parameter msgdial

Name For report or transaction with transfer of values to global memory, the field for first row should hold the name of the memory id used for export and the other rows should hold the parameter names. For FM or dialog module this field should hold the values as per the usage of the module

Value For report or transaction with transfer of values to global memory, the field for first row should remain empty and the other rows should hold values of the parameters. For FM or dialog module this field should hold the values as per the usage of the module

Receivers

Table to hold recipient details

Recnam SAP login of the recipient. Append all the recipients to this table

Sndcp X for sending mail as a copy

Sndex X for sending as express document. This will prompt a logged on recipient saying that he or she has received an express mail

Recesc ‘B’ for SAP user

‘E’ for external email address

‘U’ for unix address

Export Parameters Name and Description Field name Field function Object_id_new

Contains object id of document created during send process

Sent_to_all

X indicates that document was sent to all recipients. Flag is not activated if sending fails in one or more cases

Main Exceptions Name and Description Description

Too_much_receivers Number of recipients is greater than number for which sender is authorised to send

Object_not_sent Document was not delivered to any of the recipients

Object_not_exist Document class specified does not exist or cannot be sent

Object_no_authorisation Document could not be sent as one of the required authorisations does not exist

Parameter_error Invalid combination of parameter values transferred to FM

X_error Internal error occurred

Once all the parameters and table interfaces are properly filled, call the function module to send the SAP mail to the recipient inbox.