topic Re: Need help in Application Development and Automation Discussions

Need help

Former Member — Fri, 22 Jun 2007 12:12:53 GMT

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

Re: Need help

Former Member — Fri, 22 Jun 2007 12:19:09 GMT

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.

Re: Need help

Former Member — Fri, 22 Jun 2007 12:23:29 GMT

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

Re: Need help

Former Member — Fri, 22 Jun 2007 12:25:17 GMT

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

Re: Need help

MohanChauhan — Fri, 22 Jun 2007 12:26:44 GMT

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

Re: Need help

Former Member — Fri, 22 Jun 2007 15:13:10 GMT

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

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

Thanks

Seshu