Query?

[Former Member]

My requirements are:

1) Take input variable as number of days

2)Subtract these days from the current date

3)Restrict key figure 'Amount' by values for date > the above calculated date.

How could I do this?

The problem I am facing is:

1) How to subtract the user entered days from current date and store it in a value.

2) How to restrict a key figure by the above stored value.

[Former Member · Accepted solution]

Nikhil,

Create a formula variable of the date you want to restrict values on. The date characteristic will appear in your rows but you can change it's display to No Display.

Create a formula variable which is a Customer Exit for Today's date.

Create a formula to subtract the date in your query from the For Variable for today's date. This 'Result' will give you a no. of days.

Create a condition on 'Result' which has a variable allows the user input the no. of days. Only the no. of days entered will be displayed in your results.

Regards

Gill

[Former Member · Accepted solution]

How to create a formula variable which is customer exit for todays date?

I dont want to subtract 2 dates and get the number of days, but want to subtract no. of days from date and use the resulting date to restrict a key figure...

Any help on how to do this?

Message was edited by:

Nikhil DOZ

[Former Member · Accepted solution]

hai Nikhil,

check these links for creating customer variable exits and formula variables

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f1a7e790-0201-0010-0a8d-f08a4662...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/72f4a790-0201-0010-5b89-a42a3222...

regards

abi ram

[Former Member]

Hi

You have to write a Customer exit code. In that code you have to use offset-( number of days) and store in a internal table to restrict the kf values by amount

Regards

N Ganesh

[Former Member]

How do I write a customer exit code and where do I write it?

Is there any help on it?