Price Scaling Transport Service

[Former Member]

Dear Expert,

As per our client requirement on pricing. We have a transport service material. We have to create a sales order for transport service material. Its unit of measure is Kilometers. If a vehicle travels from 1 to 100 km then there is fixed amount i.e. 10000 rs and if it goes beyond 100 Km then system should calculate 5 Rs. for each  KM after 100 km. That means if vehicle travels beyond 100 km then system should charge 10000 Rs. for first 100 KM and then 5 Rs for each KM after 100 Km.. Kindly provide a solution.

Regards,

Chakradhara

[Former Member · Accepted solution]

Try this -

Create two condition types one having Fixed Amount by using calculation Type as B and other based on Quantity having calculation Type as C.

• PR00- Fixed Amount (Calc Type - B)

Maintain Condition records as fixed amount 10000.

• PR01- Quantity (Per KM) -Based on Scales (Calc Type - C) and maintain Scale Type - D-Graduated Scale

Maintain Condition record based on Scales

To 100 KM----Rs 100

     1000 KM---Rs 5    

If Truck Covers 105 KMS then it will calculate 100*100 + 5*5 =10000+25 = 10025

Maintain condition exclusion for these conditions .Choose Option A - Best Condition between condition types.

So if Truck Covers Less Than 100 KM , let say 70 KM

PR00 = Rs 10000 (Best Condition)

PR01 = Rs 7000

Based on condition exclusion it should pick 10000

And If truck Covers 125 KM

PR00 = 10000

PR01 = 10125 - Best Condition

Try this option if it works for you, otherwise you can also right simple calculation formula using VOFM by taking help of ABAPer.

Let us know what suits your requirement.

Regards

Amit

[Former Member · Accepted solution]

Dear Amit,

As per your solution i am defined two condition types and both are maintained in Pricing Procedure. but at the time of sales order both PR01 is not getting properly. As per you solution i maintained condition exclusion for these conditions.

For Example, if i m putting 23 KM then it is taking value both condition type. Please check the Screen Shot. kindly resolve my query and briefly explain the process..

[Former Member · Accepted solution]

Dear Chakradhar,

Amit Gupta has given right solution for your requirement. But as per your screen shot given, you have to do some changes in your configuration.

1. PR00- Fixed Amount (Calc Type - B): Maintain Condition record fixed amount Rs. 10000. dont maintain any scale here.

2. ZPR0-Quantity (Calc Type - C), Scale type-D, Check Value-B:Ascending. Maintain condition record with Scale. Scale will be as below:

100 KM - 0.00

1000KM- 5.00

3. In SPRO: go to Condition Exclusion and Define Condition Exclusion Group> now assign PR00 and ZPR0 with your condition exclusion group.> now go to 'Maintain condition exclusion for pricing procedures' then maintain: Condition Exclusion procedure B-Best condition within the condition type. and assign your Exclusion group.

now create Sales Order and check the effect. It will work. if any further query let me know.

Thanks,

Tirtha M