SD-Kondition with own formel

[Former Member]

Hi,

i create a new kondition (say Z099) für sales order and use a formel (say 700).

Now the code is in Report: RV64A700.

Now i will this: the netprice for an material is 100EUR. When i insert for Z099 = 10% the value for

this condition shell be 11,11EUR, and whole value for this Item shell be 111,11.

The reason is when i subtract 10% from 111,11 i get 100EUR, the original value.

I have tried anything in RV64A700 to set XKWERT, but i get not the value i need.

Has anyone an idea or is there any FM.

10% is an example, other values shell be possible.

Thanks.

Regards, Dieter

[Jelena]

Dieter, OK, this at least makes the formula clear. But still - how was the condition defined? There is 'condition class' and 'calculation type' in the pricing condition config, I believe they would have some influence on calculation.

Report name is irrelevant, sufficient to say it's a VOFM routine. What exactly have you tried before and what result did you get? Have you tried debugging it?

I've never used a formula with a manual condition, it's a rather unusual scenario, I think. There is a decent document available on the formula routines, you might want to check which standard formula is closest to your requirement and work from there.

[Former Member]

Hi Jelena, hi Jürgen,

i try to explain it a little bit more.

The condition Z099 is a manuel condition where i have connect a formel. The code of the formel is in RV64A700 which will be create over VOFM.

Now if a user insert for condition 10%, in the formel this value shell be calculatet to 11,11%.

If the user inserts 5% caculation shell be 5,26. The formel i use i 100*(100/(100-A2)-1).

A2 is the inderted value.

The reason is, that i will get the first price when i subtrac the inserted value.

Price is 100. condition 10 (will be calculated to 11,11). New price is 111,11.

When i subtrac 10 % from 111,11 i get 100, thats what i need.

When i only calculate 10% (100 + 10% = 110) and subtrac 10% i get 99 and not 100.

Hope it makes it more clear.

Regards, Dieter

[Former Member]

Change the logic in Pricing routine for Z099

define a variable x.

x =  (Net price *100)/(100-ZO99 condition value)

then calculate the ZO99 value based on X(As base vaule).

eg..  Net price 100 EUR

              ZO99 : 10%

X=  (100*100)/(100-10)= 1000/9 = 111.11

now 10 %(ZO99 value) of X = 11.11 EUR Pass this value as final value for ZO99(xkwert).

Hope this helps!

Rupesh

[JL23]

let me guess.

you want know how much percent you have to add to a value X, to promise a certain percentage discount to get finally again to your wanted target price of X

like you have to add 100% surcharge to the value of 100, if you want give a discount of 50% to finally get your 100

you have to add 11,11% to be able to give a discount of 10% to finally get your 100

is it this what you want?

[Jelena]

Not sure I understand the formula - 10% from 100 EUR is 10 EUR, so where did 11.11 come from?

Did you configure the condition as percentage or amount?