How to get Sales Order number in Opportunity as a custome field after converting Oppertunity into sales Order?

i need to get sales order number in the Opportunity form after converting opportunity into sales order.

You will have to query via the quotation.

Check the fields in Quotation Item and Sales Order Item

solved through custom sql script.

can you share what you did @ananthu ?