Create an action flow that sends inividual emails to material Managers.Dear all, I have an SAP Table in Celonis that look like the one in the attachmet. It has the rows "Material Manager" "Date" "STOCK Level" and "Material number"

I know want o create an Action Flow that sends an individual Email to each Material Manager (Note that there could be over 50). The Email should contain the following information:

If a material of the MM has a negative stock or the stock becomes negative in the future the Email should contain this number togehter with the first date date where this happens and the corresponding stock. If this is true for multipe Material numbers they should all be in one Mail. Examples how the Output should look like are also in the Excel-Attachment.

To get the first negative values I tried using fomulas analog to this one because it workes in a view but it does not seem to work in the query-node in the action flow.

"PU_FIRST (DOMAIN_TABLE("Material Number"),"Stock","Stock"< 0)"

Also I havent found a way how to create individual aggregated email for each Material Manager

Does somebody have an idea how to solve this?

Page 1 / 1

Hint:in the AF add to the query the name and mail of the manager and group by it. That way you will have 1 bundle per manager. Then compose the mails. It will send 1 mail per bundle = 1 mail per manager.

HTH

Thank you! That helped a lot. Sending the email now works.

I used a Tools-Tableaggregator-Node to group the Data. Is there a way to alter the format of the created Table? I allready used the column and row seperator option but in the email it is still displays more like an continous string.

I use as colum separator a html tag like - &emsp;

and <br> as row separator

Then in the mail I put the object inside a <p> </p>

that way I get it enough formatted

Probably working a bit with html tags you will be able to create a fully formatted table

HTH

Thank you! That helped a lot.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN