on 03-30-2016 5:47 PM
Hi Friends,
I would like to know the tables where all the details of MMBE report stored, however i find two relavent tables MARD & MCHB but i did not find the Batch filed in the MARD selection table, and in MCHB table i am not find the relevant unrestricted stock.
could you please tell me how to get the unrestricted, Quality , blocked stock by giving Material, Plant, Batch in the selection screen of which table.
Regards,
Sunil.K
Table MCHB is the answer to your Query. Because your requirement is Batch-wise stocks the fields
CHARG - Batch number
CLABS - Unrestricted Stock
LGORT - Storage Location
Give you the details you want. I do not think you need to look towards MARD table.
I developed one similar report perfectly matching with the stocks of MMBE, where I used two tables one MCHB and other MSKA, the Sales Order stock which is also a part of MMBE. Sales Order stock is that where a Material is purchased from outside and also In-house manufactured. If you do not have such requirement MCHB table alone will fulfill your requirement.
So, a very brief answer to your Query can be: You need to use field CLABS for knowing Unrestricted use Stock from MCHB perhaps which you were missing.
Good luck
KJogeswaraRao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.