Skip to Content
0

Fetch the data between dates in JDBC receiver

Nov 30, 2017 at 09:39 AM

22

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded