Skip to Content
avatar image
Former Member

Fetch the data between dates in JDBC receiver

Hi,

I am sending date requests(from date,to date) from ECC to JDBC and fetch the data between dates.

How to give the Receiver Message type.

In key

  • <Key> elements are equivalent to ‘WHERE’ conditions of sql query’
  • Column values within a <key> element are combined with a logical AND.
  • Different <Key> elements are combined with a logical OR.
  • Attribute ‘compareOperation’ can have values as given in following table for different comparison-operator:

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 30, 2017 at 10:28 AM

    Hi Sai,

    How you are sending the data from ECC ? (ABAP proxy or IDOC or RFC)?

    Is your scenario is ASYNC or SYNC?

    Your Receiver JDBC structure will be like this

    Table-->

    Action-->Insert (Async) /Select(Sync)

    Acesss--> you need create your target JDBC table fields under this node.

    If your scenario is Sync you need to refer this blog.

    https://blogs.sap.com/2006/07/03/jdbc-receiver-adapter-synchronous-select-step-by-step/

    Thanks,

    Pavan T

    Add comment
    10|10000 characters needed characters exceeded