Query - Goods receipt PO with serial no and bin location

Dear experts,

i need a query to get some additional information to the goods receipt PO:

Fields:

- DocNum (goods receipt PO)

- item code (from item lines)

- manufacturer serial no (from SN transaction protocol)

- bin location (from SN transaction protocol)

Can somebody help me with this query over the virtual tables?

Thanks and kind regards,

Sebastian