Scales

[Former Member]

Hi,

If a customer orders for 1000 Qty

The Scale should apply, Like

For the first 100 Qty the sys should calulate price rs10/-

For the next 100 Qty, it should be Rs 9/-

and for the remaining , It shoul calculate Rs 8/-

How should I maintain the scales in this scenario.

pls advise me on this

Regards

VASU

[Former Member]

Hello Vasu,

Your requirement can definitely be met through standard SAP. You will have to use "graduated scale".I will create a scenario like yours & explain it to you in detail:

Say my requirement is as follows:

Scale Quantity(to)----

---

Discount(%)

10----

---

5%

20----

---

8%

50----

---

10%

The unit of measurement is "PC". The above scaling means :

From Qty 1 to qty 10 = discount ill be 5%

From Qty 11 to qty 20 = discount ill be 8%

From Qty 21 to qty 50 = discount ill be 10%

Solution for your requirement:

1. Transaction code V/06 - select the discount type say K007 - in the scales section use scale basis "C-quantity scale" & scale type as "D-graduated to interval scale". Save the settings & maintain the condition record as explained above.

Now create a sales order:

Suppose customer gives order for "50" PC, the basic price of the item is Rs.100/-, then you want the system to calculate the discount as under:

For the first 10 qty,

total price = 50*100 = 5000

Discount = (5000510)/(100*50) = Rs. 50/-

For the second 10 qty,

total price = 5000-50 = (4950 )

Discount = (4950810)/(100*50) = Rs.79.2/-

For the remaining 30 qty,

total price = (5000-50-79.2) = 4870.8/-

discount = (4870.81030)/(100*50) = Rs.292.25/-

So if you take out the average of the discount will be (5079.2292.25)/50 = 8.429%

So instead of giving the discount of "10"% to all 50 quantities, the system has given a lesser discount of 8.429% per piece.

Hope this solves your problem.

With best regards,

Allabaqsh G. Patil

[former_member550050]

Hi

Your problem is very simple

Select the condition type PR02 with scale type standardly configured as D and maintain condition records in VK11 chose scale and give those appropriate values

It is very simple

Regards

Raja

[Former Member]

Hi

The scenario you want to configure is SLABS.

Unfortunately SAP doesn't differentiate between Scales and Slabs. Both are referred as Scales.

If you are looking something like this:

For 1-100units Price is INR 10 for each.

From 101 to 200units Price is INR 9 for each

and from 201units and above it's INR 8

If the sales order has got the qty as 500units then the price should be calculated as

First 100 Units: 100*10 = 1000 INR

Next 100 Units: 100*9 = 900 INR

The rest 300 Units: 300*8 = 2400 INR

Total: 10009002400 = 4300 INR

Then the settings are like this:

In Tcode V/06 Copy the PR00 into some z or y Condition type and go to details of the Copied condition type (Say ZPR0).

Under SCALES area the values should be as follows:

SCALE BASIS: C

CHECK VALUE: blank

SCALE TYPE: D

Then save the condition type.

Now maintain the Condition records:

Tcode VK11: Enter the copied condition type ZPR0 press enter.

Now enter the material and press F2

In this screen the values must be as follows

"to" "100" "EA" "10" "EUR" "1" EA

"3.000"; "9"

"999.999.999.999"; "8"

This has worked for me; hope it helps you too..

Hope poiints rrewarded if helpful.

Thanks

Vikas Patil

[former_member217082]

Hi vasu

So if your price wants to trigger in such a way that for

1st 100 pcs - Rs 10

upto 200 -Rs. 9

From 201 onwards - Rs 8

Then for PR00 condition type go to VK12 (if you have already maintained conditon record ) or if you have not maintained conditon record for PR00 go to VK11 and then go to scales and then enter the values as following

From To price

1 100 10

101 200 9

201 8

check weather the scales are in ascending or desecening in PR00 conditon type also

Reward Points if useful

Regards

Srinath

[Former Member]

Hi,

For ur requirement, Try to use for ur condition type, Use Graduated Scale type.

Hope it solves ur requirement.

Reward points if useful.....

[Former Member]

Hi Vasu,

For that particular conditon type while maintaining condition record in VK11 u can do that.

Reward if useful.

Thanks,

Pramod

[Former Member]

Go to the condition record and in scales maintain :

From 1 to 100 - Rs 10

From 101 to 200 - Rs 9

From 200 - Rs 8

regds

Jude

[Former Member]

Jude,

I think he is talking about slabs and not scales:

E.G. Qty 290 then the total should be

10010 + 1009 + 90*8

Regards

Raju

[Former Member]

yes

my requirement is exactly like ths only

What will be the solution for this

Regards

VASU

[Former Member]

Dear Sri nath,

In VK12 , I am able to see only from quntity, .there is no To qty.

Suggest me on this

Regards

VASU

[Former Member]

'from' quantity works until the next 'from':

from 1 PC. - 15€

from 5 PC. - 13€

from 9 PC. - 12€

this means:

from 1 to 4 PC you have the price 15€

from 5 to 8 PC you have the price 13€ and

from 9 (included) to the rest, you have 12€.

[Former Member]

Thanks for the response

When I checked in the System, it is not taking in that way.

the System is taking on Totality, whichever is applicable.

like, if the customer orders 2qty 15

if the customer orders 9 it is taking 12.

But for me, if the customer orders qty9, it has to calculate

415+513+1*12.

How can we do this.

Regards

VASU

[Former Member]

OK.

Try this.

VK12. Enter your pricing condition. You will get a display of all applicable records.

Now choose one record that you want to maintain and click on the icon "Details" (or F6) looks like a magnifying glass with a blue minus sign in the middle.

Go to the control data. Change the Scale Type to D = Gradualted-to interval scale.

Now you can maintain the graduated scales in the record.

All this possible only if the conditon itself is configured as "allowed to maintain scale type in condition records".

Regards

Raju