Discussion board where members can learn more about Qlik Sense Data Connectivity.
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,
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.
Enter the name of your CDS View in the DDLNAME field (like in the example below) and press the execute button.
Press the marked button:
You should now see a list with the parameters.