All Material Details for a Sales Order

Dear All,

We are using MTO scenario. I want to print a report where my input would be a sales order. The output would be a report which lists all the materials required for that sales order (from multi level BOM explosion), the indicator whether the material is purchased or produced, the Low Level Code for all the materials, the quantity required for all the materials. If the material is purchased then I need to print the required availability date.

Please help me and give me the logic (table fetching logic, or a FM etc.) for getting the same.

Regards.