Help: how to design price condition with mixture of fixed price and monthly based rate?

[Former Member]

Dear all experts,

I need to find a way to solve following problem:

A service product is charged by duration of the service.

Pricing is as following (example):

Daily rate: $10

Weekly rate:$50

Effective rate for different duration will be:

Days   Rate

1          $10

2          $20

3          $30

4          $40

5          $50

6          $50 ( apply weekly rate because daily rate is more expensive)

7          $50 /7 X 7

8          $50 / 7 X 8

I can't manually maintain this rate with scale in VK11 because the different may result in different scale and effective rate.

Thank you for advice!

[Former Member · Accepted solution]

I am thinking of following solution.

Create 3 conditions

• ZPP1 Daily   

Add formula: If Daily X NoOfContract Days > Fixed rate, then deactive this condition

• ZPP2 Weekly 

Add formula: If NoOfContract Days >= 7 days, then active this condition, otherwise deactive

• ZPP3 Fixed

Add formula: Value = weekly rate. and the rate is fixed no matter how long is the contract. If Daily rate and Weekly rate are deactive, active this rate.

With the right condition active, billing plan can be generated correctly.

Not sure whether above will work?

[former_member184065 · Accepted solution]

Dear,

I can't manually maintain this rate with scale in VK11 because the different may result in different scale and effective rate.

If the Requirement is like above then " Why dont you develop one New Field as  " Days "  in VK11 and Condition Table V/03 and same  in Contract also ".

If you have any doubts / thoughts please let me know.

Thanks,

Naren

[Former Member · Accepted solution]

I did a review  once for a textile company and this was one of there requirements.  I can remember I pretty much followed the same method.

Also review http://scn.sap.com/thread/3160995.

Regards

Waza

[Former Member · Accepted solution]

Qi Yu -

If you totally want to avoid Coding,then i have one Workaround,Try this -

Create 3 Materials Daily Service Rate,Fixed Service Rate & Monthly Service Rate.Maintain Condition Records as follows:-

Daily Service Rate-     10 Per Day-- Calc type- C (Quantity)

Fixed Service Rate -    50-------------- Calc Type -B (Fixed Amount)

Monthly Service Rate- 50-Per 7Day-Calc Type-C (Quantity)

Now Create Sales Order and check results-

Let us know if you have any constraints.

Regards

Amit

[jignesh_mehta3 · Accepted solution]

Hello Qi Yu,

You can try the idea you have in your mind. But at some point you will have to apply a Formule (Routine).

Same is suggested in the thread pointed by Warren Nash above.

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Hi Amit,

I can't define more material to host the price. My price is created for the rented material. All prices need to be defined for the material.

[Former Member · Accepted solution]

Thank you all for the great help!

[former_member184065]

Dear,

May I know , Where this formula is fulfill your Requirement ?

Note : You meant to say , in V/08 in  " Alt . Calculation Formula for Condition Base Value " Field ?

Thanks,

Naren

[Former Member]

I think it's condition value formula.

[former_member184065]

Dear,

Sorry .

Note : I am not getting ....!

Thanks,

Naren

[Former Member]

I thought you might need a scale base formula where the routine would search through the scale table to find the correct day.  You would use the condition pricing date to determine where you are in the scale based on the "from date" for which I always used a Monday.

If I can recall "getting old" this is what I did in my proof of concept review.

Hope it helps.

Waza

[jignesh_mehta3]

Hello,

You can have Calculation Type as O - Quantity - daily price. Thus if you are charging for 4 days, the Quantity of your Service Item will be 4 & the Price condition Record value will be $ 10 per day. Thus the resulting value will be $ 40.

But for 6, 7 & 8 days it will not be possible with standard pricing settings. I will suggest to develop a routine & assign the same at Alternative formula for condition base value in your Pricing Procedure. This routine can do the special calculations as per your requirements.

Thanks,

Jignesh Mehta

[moazzam_ali]

Dear Jignesh

Can you please share what will be the logic in routine?

Thank$