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


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="">

- <Statement>

- <dbTableName action="SELECT">


- <access>



<LAND1 />



- <key>










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

Have you executed the sql query standalone? 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