Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
FruzoCrew
Creator
Creator

Extract SAP CSD View with Parameters

Hi All

Please help me to extract SAP CDS View table with parameter through SAP Connector. I'm using the below code and getting an error. There is no issue from SAP DB side.

Any other CDS view without parameter works fine with the same SAP connector. 

[ZSDDDLBILLINGC]:
SQL CDSSELECT * FROM ZSDDDLBILLINGC(
P_DATE_LOW = '20200101',
P_DATE_HIGH = '20200401' );

I'm getting an error as shown in the below part,

Error:

The following error occurred:
Connector reply error: RfcAbapException:NOT_FOUND ZSDDDLBILLINGC(
 
The error occurred here:
[ZSDDDLBILLINGC]: SQL CDSSELECT * FROM ZSDDDLBILLINGC( P_DATE_LOW = '20200101', P_DATE_HIGH = '20200401' )
1 Reply
Hakan_Ronningberg

Hi,

This CDS View with parameters might be available in your system. Try if that works!

SQL CDSSELECT * FROM demo_cds_parameters(
p_distance_l = 1,
p_distance_o = 7000,
p_unit = 'KM' );

If you have access to the SAP system you can try the function module /QTQVC/GET_CDS_INFO, using the Test tool in transaction SE37.

Hakan_Ronningberg_3-1622615895019.png

Enter the name of your CDS View in the DDLNAME field (like in the example below) and press the execute button.

Hakan_Ronningberg_0-1622615494939.png

Press the marked button:

Hakan_Ronningberg_1-1622615660939.png

You should now see a list with the parameters.

Hakan_Ronningberg_2-1622615763490.png

Regards,
Håkan