Extract SAP CSD View with Parameters

[IamAlbinAntony]

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' )

[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.

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.

Regards,
Håkan