Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dynamic Select query in PI

Hi Experts,

We have requirement as below.

Our scenario is SAP-->PI<-->JDBC integration. We are going to use sync async bridge concept for this.
                             <--

We need to get the records from the DB table with the below condition

select

filed1
field2
...
...
date
id1

where id1 = <unique id>and date is between <today>and <today minus 90 day>

Unique id will be sent from ECC.

Kindly share your inputs on this select query.

Regards,

Saranya

Former Member
Former Member replied

Hi,

Below is the select query which we have made for the above condition that I mentioned.

SELECT shipto_id,inventory_date,dropped_product_id,sales_gallons,sales_costs,sales_taxes,sales_freight,sales_tax from vw_fuel_inventory where dropped_product_id = product_id and inventory_date > getdate()-90

Regards,

Saranya

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question