Skip to Content
author's profile photo Former Member
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).
Example:

PROMPT (0CALDAY): START DATE (DDMMYYYY) - END DATE (DDMMYYYY)
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 04, 2017 at 09:04 AM

    Hi,

    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.

    grtz

    Koen

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.