Select statement for JDBC receiver synch scenario for capturing random value from ECC portal

[Former Member]

Dear Experts,

I am working on ECC <----> SAP-PO 7.31 <----> JDBC synchronous scenario. I am clear about the config part except the Select statement. I will be

capturing 2 random values from the portal i.e. VendId and VendName in ECC to get the vendor details like Vendor Country, Vendor Status, Vendor Contact , Vendor Address etc from JDBC vendor table/view VENDETAIL.

What would be the select statement to capture the random values for ECC portal? My select statement would look some thing like this..

Select f1,f2,f3,f4 from table VENDETAIL where key1 = "VendId" and "VendName"

Please suggest if the above select statement works for the above scenario...

Regards

Rebecca

[Former Member · Accepted solution]

hi,

use the select statement as below.

Select f1,f2,f3,f4 from table VENDETAIL where key1 = "VendId" and key2 = "VendName"

[Former Member]

Hi Rebecca,

Your statement should work fine.

Please see the statement we use below.

SELECT eT_cashier, eT_proc_yn, eT_proc_date FROM eTest WHERE eb_proc_yn = 'N'

Just remember to update the change indicator so that you dont duplicate your records.

UPDATE eTest SET eb_proc_yn = 'Y' WHERE eb_proc_yn = 'N'.

Regards,

Jannus Botha