Generate pivot table in BG process

[Former Member]

Hi Everyone,

I have a requirement which is to send a email everyday with a report.

Report should have a attachment in which a summary report(PIVOT TABLE) and the actual report(EXCEL SHEET) should be given. Also the summary report should be in the email body as well.(Like a screen print).

NOTE : ALL THIS HAS TO BE DONE IN BACKGROUND PROCESS.

I'm able to pull the report into a excel sheet and attach it to the email and manually write the summary report into the email body.

Could someone help me resolving this? I'm looking to get the data in a pivot table and put that as an attachment to email.

Please kindly help. Thanks.

Regards,

Santo.

[Former Member]

Hi Everyone,

I have a requirement which is to send a email everyday with a report.

Report should have a attachment in which a summary report(PIVOT TABLE) and the actual report(EXCEL SHEET) should be given. Also the summary report should be in the email body as well.(Like a screen print).

NOTE : ALL THIS HAS TO BE DONE IN BACKGROUND PROCESS.

I'm able to pull the report into a excel sheet and attach it to the email and manually write the summary report into the email body.

Could someone help me resolving this? I'm looking to get the data in a pivot table and put that as an attachment to email.

Please kindly help. Thanks.

Regards,

Santo.

[Clemenss]

Hi santo29,

no standard solution for this.

Search the forums, use CL_BCS, just do it. This is called learning by doing.

You are Welcome to come back with more detailed questions in the development phase.

Regards,

Clemens