Skip to Content
0
Former Member
Dec 01, 2011 at 07:11 AM

Stock Overview : basic list

276 Views

Hi,

I would like to create a stock overview report in crystal report which create a similar info see in mmbe for stock overview : basic list

So far i know i can get unrestricted stock (MARD - LABST ), stock in transfer (MARD - UMLME) ,(MARD - INSME) quality inspection etc from MARD. You need to enter plant and storage location.

To get stock for batch managed materials , you have to use table MCHB. Here you need to enter material, plant, storage loaction and batch number and you will get different stocks according to batches.

MCHA - CLABS ( Valuated Unrestricted-Use Stock ),

MCHA - CUMLM ( Stock in transfer (from one storage location to another)

MCHA - CINSM ( Stock in Quality Inspection )

MCHA - CSPEM ( Blocked Stock ) .

but i not sure of the table linking and how i can get the on-order stock as well (as in mmbe - stock overview show). This field is quite important for me

Thank you