Skip to Content
avatar image
Former Member

Issue in fields transfer ERP to PI TPM table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 29, 2016 at 10:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2016 at 09:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2016 at 07:56 AM

    Thanks Nitin. Any other ideas's please?

    Regards

    Veer

    Add comment
    10|10000 characters needed characters exceeded