New Requirement

[former_member308994]

Hi All,

I have one requirement JDBC to RFC.

Whenever Scan the one part that part details will store in database, so that data will send to SAP through SAP PI and in SAP GR will happen. This scenario is going on now. It is ok but the client asking one more requirement.

The Scanned data will already processed to SAP, Gr happened. But for some reasons the sent data has deleted in database, the requirement is in SAP also need to delete that data automatically means its reversal process.

Is it possible through PI?

If possible please help me on this.

Thanks & regards,

Ramu

[iaki_vila]

Hi Ramu,

May be i understood wrong your question, i understand that in the source database some register are being deleted and you want that data will be deleted in SAP. You can do a sync proxy - JDBC scenario:

1. Do a report in SAP ECC and SELECT all the data processed.

2. Make a call to PI via ABAP Proxy

3. In PI you do a scenario with jdbc receiver to select the data according the data retrieved in SAP ECC.

4. If PI returns to SAP ECC that the PI jdbc call don't find any register, you make a delete in SAP ECC.

Regards.

[former_member308994]

Sorry Vila, My english very poor and,

Thank you so much for understanding this. your understanding is very perfect.

But how to select the data through receiver JDBC channel. In Receiver JDBC channel select options will work?

[iaki_vila]

Hi Ramu,

. In Receiver JDBC channel select options will work?

The Select will work and it is easier than sender jdbc, at least for me. Check this link

https://help.sap.com/saphelp_nw74/helpdata/en/44/7b7171fde93673e10000000a114a6b/content.htm

You only need to create an XSD that respect that format pointe in the page, and do the map with the data that comes from ECC proxy to do the SELECT.

But with this approach you must do the control of the DB deletes form ECC, and to assure that the PI select is done right.

Regards.