IDOC to JDBC scenario

[Former Member]

Hi,

My scenario is Idoc to JDBC. here i need to check the purchase order number coming from

Idoc(SAP) with the purchase order number in table in the database. If the PO number is exist

in the database then i need to update the corresponding fields of the table, if it not exist

need to insert fields in to the database.

Please help me to solve this..

Thanks

Karthik.

[Former Member]

ok

[Former Member]

Hi Karthik,

You can use UPDATE_INSERT for action in your mapping. This will updates if there are updates else it will inserts the data into the database.

See this help:

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

---Satish

[Former Member]

HI ,

Use Insert_update at the action attribute in the mapping it will do your requirement,

Regards,

Rama

[rajasekhar_reddy14]

Hi,

This is ver simple

IDoc-->PI-(jdbclookup)->Data Base.

at mapping level perform Data base look up to check PO number available or not.

based on condition you can insert the data in data base as per PO value.

search in sdn fpr hoe to perfrom DB lookups.

Regards,

Raj