09-11-2008 10:16 AM
Hello,
I am trying to get stock history of materials based on batch #. To achieve this I first used table MCHB but it does seem to be enough because for a certain period there may be figures of batches that were moved to inventory in the previous months. How can I find the relevant batches that make up the stock for a certain period?
Example: For the month of August the opening stock is 1000Kg and closing stock is 1500Kg. I have to find the batches or material movements that make up the 500Kg difference and also the batches that make up the opening figure of 1000Kg. Which tables should I check? Is reading MSEG a solution?
Thx in advance,
Ali
Edited by: Ali Abbasgil on Sep 11, 2008 11:22 AM
09-11-2008 10:30 AM
09-11-2008 11:07 AM
Hi ,
by using MSEGMKPF u will get all in/out aganist the matbatch+etc , but it creates performace issue.
try to get the logic of MMBE(tcode) , then implete that logic in ur program .
regards
Prabhu