on 06-06-2013 11:45 AM
Hello everyone!
My client wants to calculate discount in SD pricing based on conditions that have been calculated earlier.
What do I mean? Let's imagine we have 4 condition types: ZBAS (for base price from which the rest types are calculated), ZDS1 (the first static discount), ZDS2 (the second static discount) and ZDS3 (the 'real' discount which is calculated based on 2 static discounts ZDS1 and ZDS2). The first and second static discounts (ZDS1 and ZDS2 respectively) are not applied directly to base price ZBAS. Instead, they are stored in KZWI1 and KZWI2. The real discount ZDS3 represents matrix of discounts ZDS1 and ZDS2. For example, the base price 100 US dollars, the first static discount 3 % , the second static discount 5 %. For ZDS3 I will determine a table which contains the following record: KZWI1 (3%) , KZWI2 (5%) = 2%. So the real discount will be 2 % which has to be applied to the base price.
I added the fields KZWI1 and KZWI2 to the field catalog. However, when I create a table with KZWI1 and KZWI2 these fields are not available.
How can I add these fields for my own table.
Best wishes, Dimitry
Looks like its very simple solution. There is no need to create field cataligue etc.
You want to calculate ZDS3 based on earlier calculated discount in ZDS1 and ZDS2. Confirm if I did not understand requirement completely.
You carry ZDS1 and ZDS2 to subtotal like you are doing by assigning subtotal in your pricing procedure. In normal sap pricing procedure Subtotal1 use to carry value to KZWI1 and subtotal 2 use to carry value in KZWI2.
now for third condtion ZDS3 you write a new calculation formula or a new condtion base formula based on how you want to apply this calculaton.
assign this formula to ZDS3 in pricing procedure.
Hope this will solve your query.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your replay, Neeraj!
You understood everything correctly. And you solution is feasible.
The problem is that I have to define the entire table (matrix) for all the possible values of ZDS1 and ZDS2. This is not the only one.
Seems that I have to create z-table for storing all the combinations of ZDS1 and ZDS2 and write a new calculation formula.
Best wishes, Dimitry
Hi Dimitry,
As per your example :
For example, the base price 100 US dollars, the first static discount 3 % , the second static discount 5 %. For ZDS3 I will determine a table which contains the following record: KZWI1 (3%) , KZWI2 (5%) = 2%. So the real discount will be 2 % which has to be applied to the base price.
Looks like your ZDS3 has difference of ZDS1 and ZDS2. Mean ZDS3 = ! ZDS1-ZDS2 !
Is it correct? If I am right, Then do you require to create table in this case?
If it is not as I understood then check possibility of using range.
Check with your business if they accept range rather than fix value. What I mean create table where you are maintaing range of difference of ZDS1 and ZDS2. For Example if ZDS1- ZDS2 is less than 1 then ZDS3 will have discount say 2%.
If ZDS1-ZDS2 is within 1 to 5 than ZDS3 will have 3% discount.
If your business accept this, than it will be easy to maintain and support. Normally I have seen many user mistake issue in case if there is complex table.
But this all depends upon busiess requirement.
Best wishes
Dear Dimitry,
Check the below thread.
http://scn.sap.com/thread/599477
Likewise , you might have to add the new fields in the pricing structures.
Thanks & Regards,
Hegal K Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.