Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 08, 2014 at 09:17 PM

    hi,

    use the select statement as below.

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



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2014 at 11:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded