how to restrict selling price in Sales order ?

[Former Member]

Dear Experts,

I want to restrict the selling price entered in the Sales order for all scrap material codes in our company.

The restriction should be in a way that the selling price entered must greater or equal than the standard price of the scrap material in material master.

e.g 7101 material code is taken. the standard price of if in Material master is Rs. 100.

     Now when 7101 is used in any sales order then the selling price of it entered must be greater than or equal to 100.

So if its possible to achieve this then kindly suggest the procedure.

Thanks,

Vishal.

[mahendra_jani3]

Hi Vishal,

Please refer below document created by MozzaM about minimum price scenario it will give you some insights.

http://scn.sap.com/docs/DOC-32943

Also, you can apply below logic with the help of ABAPer.

• Add VPRS condition type with Condition category S (Standard Cost) in your Pricing Procedure.
• Assign Sub Total B field to VPRS condition type

Above settings will bring Standard Cost of Material in Pricing Procedure and will store in KOMP-WAVWR field.

• Now, create routine with Logic to read this field of KOMP-WAVWR and compare it with your Base Price condition type. (Store value in Sub Total field D (XWORKD)).

Now, you have 2 options to decide:

1) If your base price is lesser then Standard Cost, you can add the difference value with Surcharge condition by Calculation formula based on logic below:

If KOMP-WAVWR minus XWORKD is > Zero then XKWERT = (KOMP-WAVWR minus XWORKD)

2) Another option is you can just store the value and check in User Exit MV45AFZZ pass the Delivery Block value.

Regards,

MJ.

[amit_tunara]

Hi Vishal,

Recently we have done this. Our purpose was restricting any discount which makes our Selling price less than the cost price.

You can achieve this by writing a requirement module and attach it to your condition type in Pricing procedure.

You can also put validation in Sales order user exit and if there are violation, you can generate an error.

Regards,

Amit