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.
saranya selvakumar replied
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