on 08-20-2009 6:38 AM
Dear all,
I have a scenario below regarding SD pricing. Do you think this can be configure in the standard SD module?
1. Scenario 1: The price is base on weight. Where a certain weight will have a certain price (STEP 1) and the balance weight will have another price (STEP 2). Then the total weight will become the total pricing. Max of weight is 20kg.
i.e. Merchandise 25 kg.
First 2 Kg = $ 3.00 ---> 2 Kg = $3.00
Additional every 1 Kg = $1.00 ---> 23 Kg = $ 23.00
Total Weight 25 Kg = $26.00 Total Pricing
2. Scenario 2 : Business is limited to 20 kg per 1 price cycle (STEP 1 & STEP 2). If > 20 kg, need to start the cycle again, than total
both cycle will be the total pricing.
i.e. Merchandise 25 kg.
First 2 Kg = $3.00 ---> 2 Kg = $3.00
Additional every 1 Kg = $1.00 ---> 18 Kg = $18.00
Cycle 1 20 Kg -
Start back 2 Kg , 2 Kg = $3.00
Additional every 1 kg --> 3 Kg = $3.00
Cycle 2 5 Kg -
Balance
Total(Cycle 1 + cycle 2) Weight 25 Kg = $27.00 Total Pricing
Thanks
Dear Nocole,
I think you can easi;y achieve the requirement by Scales in Condition Record maintenance.
Go to VK11, select the Condition Type & conbination.
Maintin the basic Price of the Material.
Now press F2 or click on Scales.
For Scenario 1:
From 1 Price = 1.5
From 3 Price = 1
For Scenario 2:
From 1 Price = 1.5
From 3 Price = 1
From 21 Price = 1.5
From 23 Price = 1
Hope this helps...
Thanks,
Jignesh Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jignesh,
Thanks for the reply..
The recommendation that you have given does not achieve the objective.
Objective:
i.e. Merchandise 25 kg.
First 2 Kg = $ 3.00 ---> 2 Kg = $3.00
Additional every 1 Kg = $1.00 ---> 23 Kg = $ 23.00
Total Weight 25 Kg = $26.00 Total Pricing
With your recommendation, what will be achieve is the following:
(Scale)
From 1 Price = 1.5
From 3 Price = 1
i.e. Merchandise 25 kg.
25kg x $1 = $25 Total Pricing
Rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The possible solution which is based on extention of the solution suggested by Jignesh is as under:
In Condition Type configuration, main the field 'Scale Basis' with appropraite value, field 'Scale Type' as 'D - Graduated-to interval scale' and also ensure to maintain the field 'Check Value' as 'B - Ascending'.
Please update if the same works.
Regards,
Rajesh Banka
Dear Nicole,
It would definitely work:
Quantity = 25 kg.
Now Scales are
From 1 - Price = $ 1.5
From 3 - Price = $ 1
See how this will work:
1. From 1 Price = $ 1.5 that is 2 * 1.5 + $ 3
2. From 3 to 25 Price = $ 1 that is 1 * 23 = $ 23.
Thus total Price = $ 3 + $ 23 = $ 26.
Hope this is clear now...
Thanks,
Jignesh Mehta
H i
Jignesh you solution is wrong , checked the same ....
Proof for 25 kg calculation should be
1.5*2 = 3
1*18 = 18
1.5*2 = 3
1 *3 = 3 total should be 27 not 26
As per me Two changes in condition Type V/06 are
Check Value : None ( If it is ascending or decending , then when you mention 1 after 1.5 and then again 1 values will not be taken)
Scale Type : D Graduated to interval Scale............. as mentioned by Rajesh ( Rajesh plz correct me on first point if any)
Plz correct me if i am wrong, IT's working fine for me .
Regards
Rohit
Hi Nicole
If your quantity is static (means quantity will never be more than 50 kg) then the solution suggested above is correct i.e. use SCALES.
But if quantity is dynamic (means may be more than 50 or less than 50), in this case scales will fail.
So the consistent mathod for your requirement is to use calculation routine. Take help of your ABAPer and prepared a calculation routine to meet your requirement.
If your require further logic, please revert.
try and revert.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
10 | |
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.