Skip to Content
0
Apr 05, 2016 at 08:13 PM

JDBC connection from SAP PI to HANA - Read from a View instead of Table

597 Views

Hello,

We have a scenario where we need to read data from HANA DB using JDBC connection via PI 7.31 SP12. Though we are able to read the data successfully from a table on HANA db the requirement is to read the data from a view on HANA DB. Is it feasible to read the data from the a view and if yes could you please share the schema for it as well or direct me to the required documentation.

The schema being used to read from the Table:

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:MT_KNA1_HANA_Request xmlns:ns0="http://abc.com/hana">

- < Statement >

- < dbTableName action =" SELECT " >

< table > ECCDATA.KNA1 </ table >

- < access >

< MANDT />

< KUNNR />

< LAND1 />

< PSTLZ />

</access>

- < key >

< MANDT > 080 </ MANDT >

< KUNNR > 0000000106 </ KUNNR >

</key>

</dbTableName>

</Statement>

</ns0:MT_KNA1_HANA_Request>

Thanks,

Ashish