Dynamic Select query in PI
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
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.
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