Skip to Content
avatar image
Former Member

Query Designer Prompt Filter 0CALDAY/0CALMONTH

Hi everyone!

I´m building queries with the "Query Designer"

I would like to build a query with a prompt with 0CALDAY:

Start date: ddmmyyyy

End date: ddmmyyyy

Using the month of the start date, I want to bring the 12 months prior to that month in another variable (customer).

0CALDAY contains the days between
"Start date " and "End date ".
Customer exit contains the days(0CALDAY) of the 12 months preceding "Start date ".

If I input start date: 10/10/2015 end date: 15/10/2015

then the customer exit has to take from 01/10/2014 to 31/09/2015.

How can I do this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 09:04 AM


    note that you can not use the variables in the general filter, because this will give you limited data. Add them as restricted keyfigures in your query. First restricted keyfigure is a simple one as an input ready variable on calday and as an interval (from and to will be generated). The second restricted key figure is one with an user exit and the code in

    exit EXIT_SAPLRRS0_001

    will be if I_step = 2. you'll need to set it as not input ready and mandatory, you can fetch in the code the user entry of the first variable. and adjust it to your needs.



    Add comment
    10|10000 characters needed characters exceeded