Import and Send E-Mail 
You can define a Data Manager package that can import data and send an e-mail afterward using the process chain /CPMB/IMPORT_A_SEND_EMAIL.
Prerequisites
You must configure SAPconnect for external communication.
Activities
Create a Data Manager package by using the corresponding process chains (see Package Usage).
Run the Data Manager package as follows:
Log on to the Planning and Consolidation Office module.
On the action pane, choose
Manage data 
Run a package 
.Choose the package created in step 1 and choose Run.
Choose the source file.
Choose a transformation file.
Select the method for copying the data:
Merge — Joins the data values
Replace — Clears existing data values and replaces them
To run the default logic after import, choose Yes, then choose Next.
To check the work status when importing the data, choose Yes.
Choose the name of the destination dimension.
Enter an e-mail receiver, copied receiver, and subject, then choose Next.
Write the e-mail message.
To attach the log, choose Yes.
Choose one of the following options:
Run now
Schedule
Run now & schedule
Choose Finish.
You can change the default package instructions (see Modifying the Dynamic Script of a Package).
Dynamic script task parameters
Task |
Parameter |
Default Value |
Description |
|---|---|---|---|
/CPMB/CONVERT |
CLEARDATA |
0 |
Delete data before writing 0 = NO 1= YES |
/CPMB/CONVERT |
FILE |
File name |
|
/CPMB/CONVERT |
SPACKAGE_SIZE |
40.000 |
Package size |
/CPMB/CONVERT |
TRANSFORMATIONFILEPATH |
Transformation file |
|
/CPMB/SEND_EMAIL |
ATTACHLOG |
1 |
Attach DM package log 1 = YES 0 = NO |
/CPMB/SEND_EMAIL |
MAILCC |
Mail CC receiver |
|
/CPMB/SEND_EMAIL |
MAILMESSAGE |
Mail text |
|
/CPMB/SEND_EMAIL |
MAILTO |
Mail TOreceiver |
|
/CPMB/SEND_EMAIL |
SUBJECT |
Mail subject |
|
/CPMB/LOAD |
CHCKLCK |
0 |
Check work status 1 = YES 0 = NO |
/CPMB/LOAD |
CLEARDATA |
0 |
Delete data before writing 0 = NO 1= YES |
/CPMB/LOAD |
RUNLOGIC |
0 |
Run logic after process 0 = NO 1 = YES |