Solution required for storing & retrieving data in PI without using BPM or lookup tables

[Former Member]

Hi All,

We have a requirement where we need to send data from SAP TM to Legacy system.

SAP TM will send FO number and Container number. In response Legacy will send Reference Number corresponding to that FO number.

Now in PI we need to consolidate FO number,Container Number and Reference Number. Then this consolidated response message will be send back to SAP TM system. Please note that we are not going to use BPM or any lookup tables in PI.

Experts please proposed any alternative solution how we can achieve this without using BPM or any lookup tables in PI.

We have already thought about the attached solution. Do you think of any other possible way we can achieve this.

Thanks,

Priya Ranjan Saha

[iaki_vila]

Hi Priya,

If FO number and Container number are generated in the SAP TM system before the call to the sync proxy, why to store and retrieve it in PI?, when the the proxy call returns you will have these fields in the ABAP code in your request object, you can access to them after the response and to do what you want with the proxy response and those two fields.

Regards.

[gagandeep_batra]

Hi Priya,

If i understand you correctly:  you are using synchronous proxy, right ?

if yes that file part you can do in SAP TM proxy and when you get the response trigger that file part in SAP system only do your consolidation.

I would suggest you use tables in SAP instead of files.

Regards

GB

[former_member194786]

Hi Priya Ranjan,

Have you considered using GetPayloadValueBean and PutPayloadValueBean to achieve this?

Reference blog:

Regards,

Sanjeev.

[former_member190293]

Hi Sanjeev!

Yes, it is the good approach, it's just worth mention that in this case we have to modify external definition of receiving service to add elements where our stored values will be put.

Regards, Evgeniy.

[former_member190293]

Hi Priya!

Just save your values to Dynamic Configuration during request mapping and read it back in response mapping.

Regards, Evgeniy.