Hi all! Is there any MM database table which gives the document number for a batch. I have to show the stock with vendor in batch level.Please help .I am getting the batches for a vendor within specified period from MCHB table. I should show the document no. of that batch also.Please help.It'll be helpful if any table gives the purchase order no of a batch so that I can get the document no. from EKBE even.
ISEG doesn't have any values in that table. Yes,we have MBLB .But my requirement is, I have to show the relevant GR document of that particular batch.I got batches for that vendor from MSLB . Then I went to CHVW table.But here in this table,541 movement type data is not saved.Please suggest me the correct table which links batch and document no.
We have sent material to vendor with 541 movement.When I am giving this batch in MB51 and executing , that batch is showing 541 document also.But it's not showing 541 document in CHVW. Not only for a specific batch, it seems CHVW does n't store data for 541 movement type. You just check in CHVW table giving mov.type 541 executing once.
Material document & material number & batch & movement type are stored in table MSEG as mentioned before. If you want to extract data from purchasing document you can also use EKBE.
MB51 is showing all transactions between vendor and our store for a batch. What my users are asking is , they need the vendor, material,document,quantity, Purchase order no, item no, posting date , user in a same screen. So, I have to combine the data from MSLB and CHVW tables.
Please make your question clear, what is your purpose? Do you want to get a report on materials that were sent as subcontracting componets to your vendor?
In this case MB51 is enough, use MVT 541 as filter criteria.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.