JOIN WITH EQUIPMENT AND DELIVERY NUMBER

[hilalseker]

Hi All,

I need a join with equipment and delivery number. Equipment has material and serial number. When I use LIPS table, give matnr field but serial number field is empty. So when I executed, I get multiple data. In this table key field VBELN and POSNR but I couldn't find how can get these fields.

Thanks for your support.

[burag_kalayciyan]

Hi Hilal,

Check this topic.

https://answers.sap.com/questions/6272066/table-containing-link-between-material-document-an.html

VBELN_IM field at MSEG table contain delivery number.

Regards,

Burag