FreeHand SQL query with input parameters

[jlopezm]

Good morning SAP Analytics Cloud and Datasphere experts.

I recently created a successful OData connection from a view with Datasphere parameters to use the data in an SAP Analytics Cloud Planning model.

The problem I have is that I want to select the parameters from a FreeHand query when creating the model and I get different errors.

I am testing several syntaxes:

CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)/Set

And I get this error:

If I use this syntax

CV_MOV_CCEE_RD_WP/CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)/Set

I get an error like this:

When I use this syntax:

CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)

I get this error:

So I understand that the syntax here is incorrect.

I have tried ending the statement with /Results but it doesn't work either.

I have consulted other questions and documentation such as these:

• https://community.sap.com/t5/technology-q-a/sac-how-to-use-odata-v4-with-parameters-exposed-from-a-s...
• https://community.sap.com/t5/technology-q-a/sap-sac-free-hand-query/qaq-p/12622748
• https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361384392.html

But I have not been able to find a solution

What would I have to do to be able to do the freehand query for views with input parameters coming from Datasphere over OData connections?

Thank you very much!

[XaviPolo]

If the object is a VIEW then try with:

SELECT * FROM CV_MOV_CCEE_RD_WP( 
	PLACEHOLDER.P_MANDT=>'100', 
	PLACEHOLDER.P_DATE_FROM=>'1980-01-01', 
	PLACEHOLDER.P_DATE_TO=>'1980-01-01' 
)

Regards,

[TuncayKaraca]

@XaviPolo I just noticed another good point in your example: the parameter values should be in single quotes.