Skip to Content

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

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

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