Extract SAP CSD View with Parameters

IamAlbinAntony — Tue, 01 Jun 2021 15:50:39 GMT

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

Re: Extract SAP CSD View with Parameters

Hakan_Ronningberg — Wed, 02 Jun 2021 06:41:31 GMT

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

topic Extract SAP CSD View with Parameters in Connectivity & Data Prep

Extract SAP CSD View with Parameters

Re: Extract SAP CSD View with Parameters