Issue in fields transfer ERP to PI TPM table

[Former Member]

Hi Gurus,

   I have a below scenario.

SAP ERP ==> SAP PI TPM table

One IDOC triggers from ERP and there are two fields which would be transfer to PI via SOAP. I have created a table of 2 columns in B2B TPM table.

One table is input and other one is output.I have already the WSDL file and related services for INSERT, UPDATE and DELETE.

Requirement :

1) when ERP send the fields , need to check whether it already exists in TPM table or not. If not then INSERT

2) When ERP send the fields. Need to check in PI, if values are wrong or not matching with PI TPM table then use DELETE

3) When ERP send the fields. If update is required then update the fields in PI TPM table using UPDATE.

How to proceed with the above scenario. Please help me out

Regards

Veeru

[former_member229310 · Accepted solution]

Hi Veer,

You can have look up function created on the tables and apply the logics accordingly on the STATEMENT conditions in message mapping.

Regards,

Hari

[Former Member · Accepted solution]

Issue resolved.

[Former Member]

Thanks Nitin. Any other ideas's please?

Regards

Veer

[nitindeshpande]

Hi Veer,

You can do this as you have multiple tables. You need to use join statement to join both the Output and Input table for this.

Please refer to the below thread for idea on this -

JDBC ,delete .insert ,update | SCN

Regards,

Nitin