Problems with ABAP CDS Views with Input Paramters in Data Preview

[D039507]

Hi all,

I have a problem with CDS-Views with Input Parameters in the Q-System.

I developed CDS Views, some with IPs and some without IPs. In the Development System they are all working fine. After transport the views in the next System, the views without IPs are still working, but for the Views with input parameter I get the following error message in the data preview of Hana Studio:

Query execution failed Table/View VIEW_XX (P_TODAY not found. Check whether active version of VIEW_XX (P_TODAY exists

This is the SQL-Statement, the parameter is filled:

SELECT VIEW_XX~INTRENO,

VIEW_XX~LATITUDE,

VIEW_XX~LONGITUDE

FROM VIEW_XX (P_TODAY = '20180202')

In the development system everything is working fine, in SE11 and SE14 the view is active.

Anyone an idea?

Thanks in advance and best regards

Thorsten

[D039507]

Hi all,

I have a problem with CDS-Views with Input Parameters in the Q-System.

I developed CDS Views, some with IPs and some without IPs. In the Development System they are all working fine. After transport the views in the next System, the views without IPs are still working, but for the Views with input parameter I get the following error message in the data preview of Hana Studio:

Query execution failed Table/View VIEW_XX (P_TODAY not found. Check whether active version of VIEW_XX (P_TODAY exists

This is the SQL-Statement, the parameter is filled:

SELECT VIEW_XX~INTRENO,

VIEW_XX~LATITUDE,

VIEW_XX~LONGITUDE

FROM VIEW_XX (P_TODAY = '20180202')

In the development system everything is working fine, in SE11 and SE14 the view is active.

Anyone an idea?

Thanks in advance and best regards

Thorsten

[retired_member]

Call the DDIC Hotline ...

[D039507]

Thank you, that was a good hint.

For all who have the same problem: Note 2569916 - Improve Authorization check flow for Data Preview - will solve the problem.