Skip to Content
avatar image
Former Member

Variable (query between two dates)

Hello everybody,

I am having two date info object

Startdate

Enddate

Based on a key date(user entry) on the opening screen the query will show the lines with the conditions as below

key date >= startdate

key date <= enddate

I wonder how i could achieve this on the front end

Thanks a lot

Eddy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Nov 02, 2015 at 02:07 PM

    Hi Eddy,

    I donĀ“t see what the problem is.

    You do exactly what you say in your question.

    You create a variable for key date defined on infoobject 0date .

    Then you set the filter

    for startdate and end date as you say above.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Eddy,

      usually it work even though the system give an error message.

      But if the error message disturbs you - just create the replacement path variable, replace by first variable, use each one for just one of your data chars.

      regards

      Cornelia

  • Nov 02, 2015 at 10:19 AM

    I remember doing the same thing long time back and covered it in one of my blog as well.

    Please search with the term status of tickets based on their dates.

    Might be useful and helpful in your scenario as well.

    Regards,

    AL

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 09:59 AM

    Hello everybody,

    My variable design is as below but i am receiving the following error if i want to check the query:

    Systemerror in Programm CL_RSR_RRI2_LRECH and Form CHECK_CNTBIT_POSSIBLE_PARENT_01

    Startdate - Object1

    Enddate - Object2

    Variable 1- Object 1 (Restriction Area)

    -Characteristic Value

    -Manuel Entry

    -Single Value

    -Input Ready

    Variable 2 - Objekt 2(Based on Replacement Path) (Columns - Structure)

    -Formula

    -Replacement Path

    -Single value

    -Optional

    Thanks in advance.

    Eddy.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Eddy,

      Variable 2 should also be in Restriction Area and it should be of type characteristic value.

      BR

      Ondrej

  • avatar image
    Former Member
    Nov 03, 2015 at 11:49 AM

    It is allright.

    How would i see the key date in the output, the data I input on variable

    Thanks

    Eddy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Anshu Lilhori

      I followed the referred document step three. When I test I recieve the following error

      CL_RSR_RRI2_LRECH and Form CHECK_CNTBIT_POSSIBLE_PARENT_01 when I test the query.


      Design of the query is


      Rows


         Structure 1

                   Count

        

         SD Document
         Item

         Created Date

         Delivery Date

      Columns

          Structure 2

               Key Date(variable)

         



  • Nov 03, 2015 at 01:04 PM

    Hi Eddy,

    First create input variable based on SPECIFIC DATE FIELD ( Eg : 0calmonth , 0fiscper  etc )  and name it as KEY DATE

    NEXT

    Right click on SPECIFIC DATE FIELD and choose restrict  and choose value ranges

    and choose keyfield based on greater than option in value ranges

    You can create another variable as same .

    Regards,

    Sreeni


    KYD.JPG (169.7 kB)
    kyfd.JPG (142.7 kB)
    KYD.JPG (78.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 01:23 PM

    Ok. The problem was the structure 1. The Count formula Variable.

    If i remove it from the view no bug.

    But Can not i use a second structure ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 09:47 PM

    Hello everybody,

    replacement path works well but the KPI (Count) is not visible in the last column instead key date.

    I would kindly appreciate it if any have an idea on that?

    I see the description of Key Figure but not itself.

    Regards

    Eddy


    date.PNG (2.9 kB)
    Add comment
    10|10000 characters needed characters exceeded