cancel
Showing results for 
Search instead for 
Did you mean: 

Pricing Formula in Variant Configuration

Former Member
0 Kudos

Hi,

I would like to seek suggestions on how to add a pricing formula in variant configuration. The scenario for material Elevator is as below

Characteristics:

1. Stops (N) = 3

2. Rope(R) = 5

pricing for characteristic A = 200 + 10 * N + 5* R

Result = $ 255

Please advice how I can maintain this formula and how to populate value from VK11 as the pricing value(200) can also change .

Regards

Rasheed

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Characteristics:

1. Stops (N) = 3
2. Rope(R) = 5

pricing for characteristic A = 200 + 10 * N + 5* R
Result = $ 255

If 200 is not a fixed price, means coming from VK11, then its not possible to code this logic in Variant configuration.

Alternative solution is:

let the system fetch 200 from Vk11 with pricing variant 'P1'.

And goto VOFM>formulae>condition value.

Write a new routine to fetch variant char value for 1. Stops (N) = 3

2. Rope(R) = 5, store it in local variable.

Calculate pricing for characteristic A = P1 + 10 * N + 5* R.

Assign this routine to your condition type in your pricing procedure.

try and revert

Edited by: Yadav on Nov 12, 2009 8:22 AM

Former Member
0 Kudos

Hi Yadav,

I shall try the method you have mentioned when my value 200 is coming from VK11

there are some cases where the value might be constant. So how do i calculate that value and push it to the pricing condition.

In the same case, is there a possibility where the characteristic value entered by the user goes straight to the pricing condition.

Regards

Rasheed

Former Member
0 Kudos

Hi Raseed

Best practice is to use routine for your requirement.

Alternative solution is:

let the system fetch 200 from Vk11 with pricing variant 'P1'.

And goto VOFM-->formulae-->condition value.

Write a new routine to fetch variant char value for 1. Stops (N) = 3
2. Rope(R) = 5, store it in local variable.

Calculate pricing for characteristic A = P1 + 10 * N + 5* R.

Assign this routine to your condition type in your pricing procedure.

It will work 100%.

Former Member
0 Kudos

Hi Yadav,

Thank you for reply.

Based on the given example

Calculate pricing for characteristic A = P1 + 10 * N + 5* R.

Case 1.

P1= 200 is maintained in vk11 and your solution can be adopted.will try and let you know.

Case 2.

Like case 1, i have to maintain p2=10 and p3=5 in vk11 so that

pricing for characteristic A = P1 + P2* N + P3* R. Please advise if there is any structured manner in which variant prices can be maintained

Case 3.

User Enters the price in the configuration and that price appears in pricing procedure.

Regards

Rasheed

Former Member
0 Kudos

Hi

Case 1.

P1= 200 is maintained in vk11 and your solution can be adopted.will try and let you know.

Ok I agree.

Case 2.

Like case 1, i have to maintain p2=10 and p3=5 in vk11 so that

pricing for characteristic A = P1 + P2* N + P3* R. Please advise if there is any structured manner in 
which variant prices can be maintained

Lets say condition type is PR00 and P1, P2, P3 are variants for that.

So the formula should be A = PR00 + 2* N + 3* R.

Case 3.
User Enters the price in the configuration and that price appears in pricing procedure.

You mean to say price is variable, then you should go for routine, assign that char value to condition type.

Answers (1)

Answers (1)

former_member211108
Contributor
0 Kudos

Hi Rasheed,

You have to add these characters to the pricing structure KOMG and other user exit like MV45AFZZ . Then create the condition table as per your requirement . Assign it to the access sequence. Assign access sequence to condition type. Create variant conditions(Discount and surcharge) to accommodate your need and assign this to your pricing procedure.

You have to define base price condition to calculate price as 200.

Feel free to revert back to forum in case of any doubts you have.

Regards,

Atul

Former Member
0 Kudos

Hi Atul,

Is there any other method without the use of userexit .

Regards

Rasheed