Reg Counting the number of records and sending the whole as one mail...

[Former Member]

Hi All,

In my scenario,Alert mail will be sent for every failure record.Now,I should consolidate or count the number of records and send one mail for one batch saying this many "no. of records failed" and these are particular "ID's".

Thanks,

Lavanya.

[Former Member · Accepted solution]

Kindly check this [http://help.sap.com/saphelp_nw04/helpdata/en/b2/de0741375cf16fe10000000a1550b0/frameset.htm]

and

[http://help.sap.com/saphelp_nw04/helpdata/en/16/62073ced568e59e10000000a114084/content.htm]

[former_member200962]

In my scenario,Alert mail will be sent for every failure record.Now,I should consolidate or count 
the number of records and send one mail for one batch saying this many "no. of records failed" 
and these are particular "ID's".

Is it that you will be getting the X-messages failed record information in one message?...in this case you can easily apply the count function to get a sum of all the failed records and send it as a mail....both message mapping and XSLT mapping have count functions

If you will be getting the information via different messages arriving at different time intervals then you can make use to BPM to collect all the messages and then apply a N:1 mapping to get all the failed record message count .....

Regards,

Abhishek.

[Former Member]

Hi,

As per my understanding, record will get fail if the footer is missing/ some mandatory field is missing. if so try to develop the module which will count the record which are going to fail based on the condition and then send the consolidated mail from the module with the record count and the particular IDs.

Regards,

Chandra Shekhar.