Formula variables

[Former Member]

What are formula variables?

[Private_Member_9643 · Accepted solution]

In your query filter restrict the Cost Center with Cost Center values, and date with the mentioned date. Y u need Customer Exit for it?

[Former Member · Accepted solution]

Is it correct to say that formula variables are only for creating restriction for a key figure and a date?

What other ways to create the formula variables?

[Former Member · Accepted solution]

Hi Edna,

That is one of the usage.

Others are

--Formula Variables can be used to provide input to exceptions and conditions, like a Top N condition where the user can decide the output for Top 5 or Top 20. and the selected values can be input using the formula variable.

--Also in other places where you want an expernal input from user like some Percentage margin or commision etc for Bonus or Profit Calculation, this kind of entries will be made using Formula Variables -> User Entry kind.

please see this link for an example scenario

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

Hope this helps.

please let us know if you have a specific scenario.

Thanks,

CK

[Former Member]

Enda,

We use formula variables for two things.

1. Budget FX rates that are not in R/3 - BW. We create a formula variable with he yearly rate and then we use this formula variable for any conversions we may need to do.

2. Sometime you may want to convert characteristic numeric or date values to key figures so you can do some formula with them. We create formula variables from the characteristic value and can then use these values for Conditions - Exceptions and any formula that are applicable.

I dont understand the explanation given by KJ @Kamaljeet - I can't understand how characteristic variables could be classed as formula variables.

Regards

Gill

[Former Member]

hai

check this link

http://help.sap.com/erp2005_ehp_02/helpdata/en/5c/8db0b1555411d189660000e829fbbd/frameset.htm