SAP PO with HANA Query
Hi All,
We are Planing to retrieve data from SAP HANA through View from a SAP PO
Structure Of View :
I want to execute below query but instead of passing hardcoded values like NOISDN.I need to pass this from SAP PI as inuput
SELECT "NO", "EMIB", "MANUFACTURER", "MODEL", "POSTG_DATE", "PURCHASE_ORDER", "MATERIAL", "BAN", "MSISDN", FROM "_SYS_BIC"."SAPOER.reporting/ZTMM_CVS_COU_OUT_WAR" ('PLACEHOLDER' = ('$$PI_ISDN$$', 'NOISDN'), 'PLACEHOLDER' = ('$$PI_BAN$$', 'NOBAN'), GROUP BY "EMIB", "MANUFACTURER"
I am Using SQL_QUERY in message and receiver JDBC adapter (SYNC Call).
Like to know how to pass query from SAP PI.Can anyone guide on this?
Thanks,
Dinesh