Need help

[Former Member]

Hi,

I want to get the TOTAL Stock from MMBE Transaction when i enterd the material. When I am taking the Total Stock , it is coming at Sto loc level, but i want the Stock at plant level.

select matnr

werks

labst

from mard

into table it_mard

for all entries in lit_ipgbau

where matnr = lit_ipgbau-nrmit "Material no.

and werks = lit_ipgbau-wemit. "Plant

• Reading data

clear it_mard.

read table it_mard with key matnr = it_ipgbau-nrmit

werks = it_ipgbau-wemit

binary search.

IF sy-subrc = 0.

it_alv_data-labst = it_mard-labst.

endif.

regards,

Ajay Ram

[Former Member]

Hello Ajay,

Plant level stock

just check with MARD Table field name called LABST ( There is no stock at plant level),everything should come Storage location level.

[Former Member]

Hello Seshu,

How can we calculatethe all Stock in Storage Locations.I want display that stock in report. Need logic for this.

regards,Ajay Ram

[MohanChauhan]

Hi,

Stocks are at the Storage location only.

But from MARD you can get all the storage location for a plant ( along with material ) and

then total all the material quantity where plant = <selected plant> irrespective of storage location.

Regards,

Mohan

[Former Member]

you can get the value from MARD Table - Field name is LABST

based on plant = ur value -> check with MD04 Transaction.

Thanks

Seshu

[Former Member]

Hi.

LABST for "Valuated Unrestricted-Use Stock",then only its taking with total stock.

if you want plant level please check your filed for plant level.

Regards.

Jay