topic Re: Sales margin in Application Development and Automation Discussions

Sales margin

Former Member — Wed, 28 Mar 2007 06:42:56 GMT

Hello,

I have to write a sales report for a SAP Retail system. After a debug on the standard transaction MCHP I have identified the table S083 as the source of sales for material.

I still don't know how to calculate the following:

- sales margin for a transaction

- montly stock rotation

Any idea?

Thanks!

Re: Sales margin

Former Member — Wed, 28 Mar 2007 06:53:26 GMT

Hi,

Use the Table S085 instead of S083 for this purpose.

Use the following fields and calculate the Margin as per the requirement:

UMSGEO

UMSGVO

UMSGVP

PRSNLS

WESMNG

WESGEO

WESGVO

WESGVP

WESANZ

KMEMNG

KMEGEO

and use other cost related fields for the profit caculation

reward if useful

regards,

Anji

Re: Sales margin

Former Member — Wed, 28 Mar 2007 07:01:51 GMT

Can you please explain me the relation between tables S083, S084 and S085 ? I see that in MCHP, the search is made first in table S083, then in S084 , and after that, if search is unsuccesfull in the previous selects, the table S085 is queried also. So, what is the logic here?

Re: Sales margin

Former Member — Wed, 28 Mar 2007 07:09:16 GMT

Hi,

S085 is the combination of both S083 (material Movements) and S084(Material STOCKS), so you can use this S085 alone for this calculations.

You can link them using the Key fields(if you wants).

reward if useful

regards,

ANJI

Re: Sales margin

Former Member — Wed, 28 Mar 2007 07:17:42 GMT

Thank you for your answers!

Can anyone tell me how stock rotation speed can be calculated?