MRP Pricing

[Former Member]

Dear SD Gurus,

I have scenario where the client has the MRP price requirement, it is a reverse calculation the MRP price and dealer price is declared in the price list based on these two components you we have to arrive at the base price, has any one work on the this type of scenario kindly provide me with config steps.

Regards

Parvez

[Former Member]

Hi Parvez,

You can use calculation type H - 'percentage included' for all those condition types which need to be subtracted from MRP price. But the percentages maintained in condition records will remain the same.

For example, lets say MRP condition type is ZMRP and for a certain article it is $100 including 17.5% tax.

Let ZWST be the tax condition type. You have to make ZWST a negative condition type and with calculation type H (other config as usual)

Condition record for ZWST should still be maintained 17.5% as 'H' tells SAP that this 17.5% needs to be extracted from the base value so that the condition value forms 17.5% of REMAINING amount.

For a quantity 1, the pricing looks like this

ZMPR 100 each 100

ZWST -17.5% -14.89

sub total 85.11

If 85.11 is the base price and 17.5% is the tax then you can see that after tax price becomes 85.11 * 1.175 = 100. You can declare as many condition types as there are components included in the MRP price. Sequence of subtracting these condition types does not matter just as the sequence of adding the components.

Award if helpful.

Cheers,

KC

[former_member550050]

HI

Go through the following:

I will brief your requirement in short

MRP = 1012.5/-

VAT = (1012.5/1.125) = 900/-

so price before discount will be = 900/-

discount given at the rate of 10% = 100/-

Initial Price = 1000/-.

1. Create condition types as below:

ZR00 for price

Condition class = B

Calculation type = C

Plus/minus = A

ZSET for settlement (to knock off the effect of ZR00)

Condition class = A

Calculation type = C

Plus/minus = X

ZWST for tax

Condition class = A

Calculation type = H

Condition category = D

Plus/minus = X

Z007 for discount

Condition class = A

Calculation type = H

Plus/minus = A

ZDUM for net price

Condition class = A

Calculation type = A

Plus/minus = A

YWST for tax (to knock of the previous effect - to be used for posting to G/L)

Condition class = A

Calculation type = A

Plus/minus = X

YOO7 for discount (to knock of the previous effect - to be used for posting to G/L)

Condition class = A

Calculation type = A

Plus/minus = X

2. The following will be the pricing procedure configuration:

Step......No........Cond Type........... From.........to..........Man.........Req........Sta................Acc Key

10........0..............ZR00..................--..........--..........-...........-........---.................ZDU

20........0..............ZWST..................10............19...........----.............X............X...................

30........0.............text.......................10...........29...........---...........----.........X

40........0.............Z007.....................30...........39...........-----.............X............X

50........0..............text.....................30............49...........---...........-----.........X

60........0............ZSET.....................10...........19...........----............X............--.................ZDU

70........0............ZDUM....................50...........59...........----............X............---...............ERL

80........0............Y007.....................40...........49...........----.............X...........---...............ERS

90.......0..............YWST..................20...........29...........-----............X...........---................ZWS

ZDU - dummy account key for posting extra not required items.

ERL - account key for price

ERS - account key for discount

ZWS - account key for tax.

3. Condition records in VK11

Condition type----

---

Condition record.......

ZR00........................................1012.5.....................INR will be positive

ZSET.......................................100%...............................will be negative

ZWST.......................................10%................................will be negative

Z007.........................................12.5%.............................will be positive

ZDUM.......................................100%..............................will be positive

Y007.........................................100%.............................will be negative

YWST.......................................100%.............................will be negative

Condition records for Z007 & ZWST will be decided as per the conversion required. You will first have to manually calculate the amount for the condition type.

4. I create a sales order for single quantity for an item & the pricing will be as under:

ZR00 = 1012.5 (dummy account) - positive

ZSET = 1012.5- (dummy account) - negative will knock off effect of ZR00

ZWST = 112.5- (negative & no posting)

Z007 = 100 (positive & no posting)

ZDUM = 1012.5 (positive & posting)

Y007 = 100-(negative & posting)

YWST = 112.5 (positive & posting)

HOPE THIS SETTINGS WILL HELP YOU

Regards

Raja