Skip to Content

To Update SAP table from PI with the fields in message Payload.

Hello Experts,

We have a requirement to update a custom table in SAP with the fields in the incoming/outgoing message payloads in PI for a particular set of interfaces (around 60). All message have same fields which needs to be updated.

We need to update them on daily basis. Or can be real time also. 

I cannot modify any of the existing interfaces.

Pls let me know if it is possible.

Thanks,

Ashish

Message was edited by: Ashish Goel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 15, 2013 at 05:07 PM

    Hi Ashish,

    You can use RFC Lookup (a RFC needs to be exposed and RFC Code should update the fields in SAP table from PI xml payload). But in that case you have to add this look up and modify your message mapping.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ambrish,

      this is what I was looking for. With this function module ( modifying it according to my requirement),  I hope I can achieve it. Though looks bit complex.

      Thanks for your inputs.

  • Apr 15, 2013 at 08:10 PM

    Hi Ashish,

    You can create a function module in ECC and call this function module to update the Z table during inbound processing of the set of interfaces in play. This way you would not be required to change the interfaces in PI but yes, you might be required to call this function module within proxy code (in case of ABAP proxy) or user exit (in case of IDocs) within ECC. It will be very-very tricky to make this possible without changing the existing interfaces in ECC or in PI.

    Ambrish

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ambrish,

      Your solution just shifted the changes from PI to ECC side.😊

      For proxy code also, you need to make changes for each Outbound program. For standard IDocs, you need to again handle this in a custom User exit. If client is really want to handle these at SAP side not in PI, we can try, not sure whether would be achieve everything.