Extract report in SAP PI 7.31 Single stack

[former_member309357]

Hello experts,

      I have a strange question. In PI 7.31 Java Only do we have an option to extract report on daily/weekly basis. Say, if a proxy to file is processed. PI would have that payload xml file. From that payload file we need to get some fields and generate a log file with that particular fields and values in it and send it as attachment someone's email id.

     This question is strange but please give your valuable inputs. Waiting for your reply gurus.

Thanks

Ravi.

[Former Member]

Hi Ravi

You can do this in the below way

write an abap program in ECC system which will do the following

1. Take the sender interface of your proxy as input and search in the table SXMSPEMAS to get the list of message ID's.

2. Take the message id and then call standard function module

  SXMB_GET_MESSAGE_PAYLOAD to get the payload data.

3. Parse the payload data for the field value you want to put into report.

4. Prepare the excel with field value.

5. Send the email

[former_member309357]

Hi Indrajit,

      Thanks for your reply, from ECC we are already extracting the report from the tables and sending in PDF format. But in this case we require the report from the xml paylaods which ever are processed from PI to thirdy party.

Thanks

Ravi.

[former_member185856]

Hi Ravi,

             Could you please put this question more elaborated, as you said :

1. Extract report on daily/weekly basis : What report? does that should come as .xml / .xls / Web?.

2. Proxy to file is processed : are you sending data from SAP to PI?

3. Do you want to capture particular data from payload and send it to as email?

Pls let me know if this is correct.

Thanks,

Sunil.

[former_member309357]

Hi Suniel,

     1. Extract report on daily/weekly basis : What report? does that should come as .xml / .xls / Web?.

         That should come in an excel sheet.

       2. Proxy to file is processed : are you sending data from SAP to PI?

            Yes.

       3. Do you want to capture particular data from payload and send it to as email?

            Yes, particular fields in that xml payload, send in excel to an email.

Thanks

Ravi.