How To pass a period variable

[Former Member]

Hi experts!

I have a model in visual composer that calls a query which has a filter on the characteristic 0FISPER, when I execute this query in the query Designer, the period of fiscal year is asked in the format "009.2007 - 008.2008".

The problem is that I don't know how to pass this value in VC, because if I indicate the static text "009.2007 - 008.2008" in the field "Fiscal year period" in the connector between the inputform and the query, when I execute the VC model the following error appears:

"Nested Exception. Failure to execute native function. Nested Exception.

INVALID_VARIABLE_VALUES"

Do you have any idea how to pass the values of the period to the variable of the query??

Thnks in advance!!!

[Former Member · Accepted solution]

Hi Roberto,

the solution is available in the WIKI:

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/howtoselectranges&">https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/howtoselectranges&</a>

Best Regards,

Marcel Salein

[Former Member · Accepted solution]

Hi Marcel!!!

Thnks a lot!!! this resolved my problem.

Regards.

[Lisi]

Hi Roberto,

Is the field type of the fiscal year date or string?

Regards,

Lisi

[Former Member]

Hi Lisi, thnks for your answer

In the query the variable is based on the characteristic 0FISCPER so, is of the type: <b>"NUMC - String only with numbers"</b>.

And in VC when I drag the 'variables port' of the query to get input form for capturing them before calling the query, it take these field with <b>TEXT</b> type.