profit margin

[Former Member]

My client requirement is he needs to caliculate profit margin at sales order level, whenever the profit margin margin less than the standard the order should be blocked until unless the authorised person release.

Gurus Pl respond as soon as possible as you can

[Former Member]

Hi,

You can use a user exit for this requirement.In this case if the net value of the item is less than the expected price(which you can maintain as a statistical condition type and maintain condition record for same) then you can block the sales order.

You can use user exit SAVE_DOCUMENT in program MV45AFZZ.

Reward points if useful

Regards,

Amrish Purohit

[Former Member]

Hi Purohin,

Thanks for ur immidiate reply...

I am agreeing your soulution.

But i can explain my demand indetailed.

Suppose the material price is 500.

but the distributar asking huge discount

if the company gives that discount that material

price comes down to 450. so it is 50 rs loss to

company. So at order level it should be blocked and

coresponding ZSM should approve that order, if he approves

the price is 450 otherwise company has to send the message

to distributar that 'We unable to process your Order'

To caliculate profit Margin am i take the fields from billing

(VF01) i.e., from cost and net value?

And also can u help me out how i can i write the

functional spec?

Its very Urgent

Thanks in advance

[Former Member]

Hi Protan,

Yes that's what i mean so your company wants to sell at 500 Rs is their minimum value so if the net value is going down then it will be less than the statistical condition type value so you can block the order depending on the difference is - ve.

You can do it the other way round as I hope you will be using VPRS condition type in pricing procedure.This VPRS cost is calulated by your net value of the order minus MAP.So you can calculate in the code the % of profit earned based on VRRS and NET value from the order.

Also there will be predefined minimum profit margin % which your company expects to generate from orders based on some sorting criterai as say group of materials.Then this % you can hard code in exit and if the calculated % from order is less than hardcoded one then you can set order block.

Reward points if useful

Regards,

Amrish Purohit

[Former Member]

Hi Purohit,

Thanks for ur responce. I think for this i have to

use the userexit_ document_save_prepare in that

coding should be writeen in SAP45AFZZ

Is it right??? for that what the fields i have to give the

Abaper???

Thanks in Advance

Protan

[Former Member]

Hi Protan,

Yes you are very right.It is the same exit you can use.

But sorry coz of work pressure i will not be able to give you the field details as of now.I will try to give you if possible.

Regards,

Amrish Purohit

[Former Member]

Hi Amrish,

ThanQ very much for ur responce. Any way i am moving out from office

i expect the rel fields by monday if is possible.

Once again thanQ very much Amrish.

Protan