on 05-29-2013 6:57 AM
Hi Experts,
My client requirement is Sales tax should be calculated after Price + Excise + Insurance + Freight for a specific plant and for other plants the sales tax calculation should be after Price + Excise then add Insurance and Freight. Pricing procedure is same for all plants. Cal anyone pls suggest me how to map this two scenario in one pricing procedure.
Regards,
JJ
Janmejay,
The field "Alternate BaseType" has to be used for this requirement.
In the pricing procedure, the row with the tax condition type, in the field "Alt BasT" add your routine that shall -
1. If plant is specific, then the base value for calculating tax is then the base value for calculating tax is Price + Excise + Insurance + Freight
2. If the plant is something other than the specific, then follow the as-is standard SAP pricing logic
Explain your ABAPer, the logic based on which he/she shall create the routine (write the code).
In the pricing procedure -
10 Price
110 Exercise
180 Insurance
200 Freight
250 Tax From 10, To 110
---- In general, Tax is calculated based on the value Price + Exercise
But if it is specific plant, then the routine in the Alt BasT shall make the base value as Price + Excise + Insurance + Freight
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Janmejay,
I am thinking in the following way ( I have not tried and tested so, you may have to test it in your sandbox before propose this to business).
Create 2 condition types (say ZWST and ZVAT). Assume that ZWST will be calculated on Price + Excise + Insurance + Freight and ZVAT will be on Price + Excise.
In your pricing procedure:
step 10: Price
step 20: Excise
step 30: ZVAT
step40: Insurance
step50:Freight
step60: ZWST.
Now, keep both tax related condition types as mandatory condition types. However, in the access sequence, ensure that you have Plant region as one of the fields. So, when Plant X comes you will see ZVAT will activated and ZWST also will be activated (but, in your records you have to maintain ZWST as 0% with plant X combination) If plant Y comes ZWST will be activated with actual tax value and ZVAT will be 0%( in your records for Plant Y, ZVAT should be maintained as zero)
Note: You may need to play with above step numbers to get the base value.
Please check and post your results here, so that we can suggest you other solutions.
@ others: Please correct if my above logic is wrong.
Regards, Sai Krishna.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
It seems not Good Solution but problem is Note: You may need to play with above step numbers to get the base value.We need to change the Step Numbers every time and one more thin is User doesnt have Access to Pricing Procedure .Its very risky process .Whoever can take this kind of activities in Business.Finally,consultant need to be handle that User Role also .
If you have any doubts please let me know .
Thanks,
Naren
Dear Naren,
I didn't understand your last statement.
.Whoever can take this kind of activities in Business.Finally,consultant need to be handle that User Role also .
Even if you go for enhancement and tomorrow the base value logic changes, you have to change your routine logic too.So, in both the solutions, user has to reach consultant
As everyone aware, we should minimize the development and coding if there is a standard solution.
BTW, I mentioned playing with step numbers to inform OP to do some trail and error.
Hope you understand now.
Regards, Sai Krishna.
Hi
I have two suggestions for you. You can try any one of them and see which is helpful for you.
Please test and update.
Thank$
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have created two routine by ABAPERs like 901 and 902. In 901 the logic is written like, if plant is A then deactivate the steps in which against the routine is assigned and it working fine calculation are ok in item level Conditions but when I am checking in header level conditions then the steps are not deactivated and calculation is shown as wrong. can anyone suggest.
Regards,
JJ
Dear,
That is depends upon Routine .With what logic ,ABAPer has developed that Routine ? why because you are owner in this case ,how you wanted in Sales Order Level Price .Better than meet once again ABAPer and explain your problems with tested screen shots .
If you have any doubts please let me know .
Thanks,
Naren
Please ask your ABAPER to check the routines. Ask him to do this for both, line item and header level. KOMP and KOMK are the structures for this. A technical person can understand this better because this is AAP area. You just need to tell him the logic in your functional language and he has to convert it in technical language in routine.
Thank$
Hi,
It is not possible in the standard pricing procedure
May be you have to think of Routine and assign this as Alternative calculation type for the sales Tax condition type
your Developer can help in this regard
regards,
santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
You need to create Two Sales Tax Conditions Types as differently and maintain these condition Types in Pricing Procedure as ZCST Condition Type ,it will calculate from Price + Excise + Insurance + Freight and XCST Condition Type ,it will calculate from Price + Excise .
Note : If you want two condition types in Sales Order Level then no problem .If you dont want two Condition Types in Sales Order Level then I dont know ,how much Exclusion Proces would be helpful or not or else go by New Routine in this case .
Thanks,
Naren
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.