Thank you i did the same

To connect the sale_order table and product_product, product_template table use sale_order_line table as intermediate table.

By using the following fields which is present in sale_order_line,

• order_id -> sale_order
• product_id -> product_product