how to calculate opening stock month wise

[Former Member]

Hi experts...

I m using mseg and mkpf tables .

I want to calculate opening stock month wise.

can anybody tell me the logic for calculate opening stock.

[Former Member · Accepted solution]

Dear Ankita,

If you want the stock monthwise, then I suggest you get ur data from the:

-> S031

-> S032 tables

Since it stores the statistical data about goods movement, It would be faster and would serve the purpose better.

The stock would be = opening + receipts - issue.

Regards:

Ravi Carpenter

• Plz rate if useful

[Former Member]

This message was moderated.

[former_member187748]

Hi Roslin,

please see how old this thread is, and is has been answered too.

Please do not respond such old threads.

[Former Member]

This message was moderated.

[Former Member]

hi,

take records from mseg where mkpf < s_budat-low.

In first part of records ignore movement bwart not in ('641','642').

plus stock for shkzg = 'S' and minus stock for shkzg = 'H'.

In second part of records take mvement bwart in ('641','642').

plus stock for shkzg = 'S' with bwart = '642'

and minus stock for shkzg = 'H' with bwart = '641'.

try it...

thanks...

raj