Skip to Content
0

Query Designer Prompt Filter 0CALDAY/0CALMONTH

Dec 01, 2017 at 06:40 AM

28

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Dec 04, 2017 at 09:04 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded