Skip to Content
avatar image
Former Member

How To pass a period variable

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!!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 08:12 AM

    Hi Roberto,

    the solution is available in the WIKI:

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2007 at 05:10 PM

    Hi Roberto,

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

    Regards,

    Lisi

    Add comment
    10|10000 characters needed characters exceeded

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