Reverse Calculation base on MRP Price in Pricing Procedure

[former_member358181]

Hi All,

I want the reverse calculation base on MRP price in pricing Procedure

Scenario is like this -

MRP Price including Tax - 900/- (statistically)

Fright (-ve) - 40/-

Margin (-ve) - 30/-

-

---

Sub Total (MRP-Freight u2013 Margin) - 830/-

Reverse Tax Calculations (-ve) 12.5%- 92.22 (830*12.5%/112.50) statistically

-

---

Base Price - 737.78

Sale Tax 12.5% - 92.22 -

---

Net Price 830.00

-

---

How can to assign the Reverse Tax Calculations (-ve) 12.5% in pricing procedure?

Pl. help

Regards,

Devendra

[former_member188076 · Accepted solution]

Hi

The % can be calculated in two ways :-

1) when the base price is not inclusive of %, for example in your case the base price is 830.00 and tax rate is 12.5%, then the calculation will be as follows :

830*12.5 / 100 = 103.75

2) When the % is included in the base price (as your case is), the same calculation will be like as follws :-

830/112.5 *12.5 = 92.22

Both the situation can be handled in SAP from Calculation type of a Condition type in V/06. If you want to calculate the value of a % as in case 1 then select "A" in calculation type and if you want to calculate the value of % as in case 2 then select "H" in calculation type of the Condition Type.

You may check it by youself and revert if there is any issue.

Regards

Amitesh Anand

[former_member358181 · Accepted solution]

Dear Amitesh,

Thanks for reply, I have selected the second option and created the condition type and selected in Condition class u201CDu201D, Calculation type u201CHu201D, Condition category u201CDu201D.

But It has selected the Positive in Plus/minus, system taken the tax value correctly -92.22 (830/112.5 *12.5 = 92.22) and selected the Negative in plus/minus then system taken the tax value u2013 95.50 too calculated in base value price-830/-

I want the tax value negative, Hence Please suggest how to solve the above issues??

Regards

Devendra

[former_member188076 · Accepted solution]

Hi

You better leave the positive/negative field Blank.

Regards

Amitesh Anand

[former_member358181 · Accepted solution]

Dear Amitesh,

First I have created the condition type u201CZWSTu201D and selected in Condition class u201CDu201D, Calculation type u201CHu201D, Condition category u201CDu201D & Positive in Plus/minus.

Created a step; this is copy of u2018Totalu2019 value.

Created a step; the condition type is u2018ZWSOu2019. This is a copy of Total Value but in negative form. Maintain condition record as 100%.

Problem solved.

Thanks & Regards,

Devendra

[Former Member]

Hi

Kindly maintain the routine in the alt calculation type with the help of abaper

code example as below:

1.xkwert = ( ( Xkomv-kawrt * 100 ) / ( 100 * 100 + lv_kbetr ) ) * ( lv_kbetr / 100 ) .

2. lv_kbetr = lv_kbetr + ( 100 * 100 ).

lv_kawrt = xkomv-kawrt * 100.

lv_prcal = ( lv_kawrt * 100 ) / lv_kbetr .

Regards

Damu