SAP PO with HANA Query

[Former Member]

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

[Former Member]

Hi,

May I Know the SAP System where the HANA DB is being used ? or what is the application from which you are trying to read the data from ?

Ideally you should be able to query from the HANA DB, if required..but not sure..you can try if required from the hana studio and executing the query straight away..

HTH

Rajesh

[Former Member]

Hi Rajesh,

We have Front End Middleware Request to SAP PO and Backend is SAP HANA

This is SYnchronous call from FrontEnd <--->SAP PO<---->SAP HANA DB

Hope this clears

Thanks,

Dinesh

[Former Member]

Hi All,

I can able to generate dynamic query in mapping itself and issue is resolved now

Thanks,

Dinesh