Issue with sales order pricing with graduated scale.

[Former Member]

Hi All,

Need your urgent help on this.

I got the requirement for cumulative pricing. where I am maintaining graduated scale. It is for a service material and customer wants to calculate the rate after calculating the total usage from historical data.

Example:

For a contract we have one service material (MAT1). Contract start date is say 01-01-2011. We have below usage list for that service material in history.

Year	Total Usage
2011	1000 Hr
2012	1200 Hr

And we are maintain condition record with graduated scale for that service material like this:

Usage	Rate
0 - 1000 Hr	60 $
1001 - 2000 Hr	55 $
2001 - 3000 Hr	50 $
3001 - 4000 Hr	45 $

Now I am creating a order today (i.e. in yr 2013) with usage hr 1500 .

If I enter this 1500 Hr for MAT1 in sales order, then SAP calculating pricing as below..

(for first 1000 * 60$ ) + ( remaining 500 * 55$) = 87,500$. Which is correct as per standard. but our requirement is different!!

We want calculation, to be done based on total usage.... i.e.

• Since we already have usage from history as (1000+1200) i.e. 2200 Hr
• for current Sales Order, as we have 1500 Hr as item quantity
  • first 800 will fall in range [2001 - 3000 Hr] so rate should be 50$.
  • Next 700 will then fall into [3001 - 4000 Hr] so rate should be 45$.
• So total should be ( 800 hr * 50$ ) + ( 700 hr * 45$ ) = 71,500$

Can anyone please help how to replace the rate in the order line item.

Regards,

Pritam Banerjee

[phanikumar_v3]

Dear-- in this given case--- if you want to give first 800hrs and there on ---then maintain the scales from 2000hrs onwards and remove the other scale settings(It is strictly based on your current business approvals)

But kindly let me know how you are accumulating the data year-wise to get the proper condition records....

Phanikumar

[Former Member]

Hi,

00

Please create Two condition types

1. Base price condition based on your total hours (Current + history). In this case it will be 2200 +1500 = 3700 hrs

2. Discount condition for Historical hours already billed. ( In this case it will be 2200 hrs)

Maintain same scales for your for price calculation separately for base price and discount condition.

Base price calculation for your case will be as below

60*1000 + 55*1000 + 50*1000 + 45*700 = $196500

Discount will be as below

60*1000 + 55*1000 + 50*200 = 125000

Net Value  =  base price - discount

                =  196500 - 125000

                =  71500

I hope this can help.

Thanks & Regards,

Rashpinder Singh

[Former Member]

Hi,

you can create your own scale formula (tcode VFOM) updating field XKWERT as required. Then update in custo your sales condition assigning G to scale basis and assigning scale formula number in Scale formula field.

Regards,

JM

[Shiva_Ram]

To me it looks, you may need to develop a routine with the calculation logic based on previous year(s) usage + current year usage in T.code VOFM and assign the routine in the field Scale formula in the condition type (t.code V/06). Not sure on how you pull the value of previous consumptions but if needed, you may need to develop a Z-table to store the values for the calculation purposes.

Regards,

[Former Member]

Hi Pritam,

The simple approach is to have your condition records maintained during your Start of the year as required.

Regards