Skip to Content

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

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

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

Tags:
replied

The error states that column W_DATE__FROM does not exist in this view.

Have you executed the sql query standalone?

Looks.like your query is incorrect

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