11-21-2005 8:34 PM
Team,
I want to know what table contains MBLNR and VBELN or VGBEL in one table.
Thanks
Rel. 4.7
11-21-2005 9:48 PM
11-21-2005 8:44 PM
I think you looking for MSEG table it contain sales order(VBELN) as KDAUF and reference document(VGBEL) as LFBNR.
11-21-2005 8:56 PM
Thanks for your reply.
These two fields are not populated in MSEG in our system.
Is there any other table.
Thanks
11-21-2005 9:01 PM
I don't think soo. It has to store only MSEG(Document Segment: Material). Try to create a material document and check.
11-21-2005 9:03 PM
They are not directly linked, but they both(invoice and material document) are linked to the sales order in the document flow.
Go to VBFA and enter your document in the VBELN field and you will get all the preceding documents including material document and the sales order.
Srinivas
11-21-2005 9:48 PM