Sales order BOM

I have a list of Sales orders. I would like to know whether a particular material (3rd level BOM) is delivered or not in the Sales order. Suggest me how to do it using SE16N table.

I tried using AFKO --> STPO --> RESB . But through this, I could get the result only for orders with Production orders.

I want to get the result for all the orders,

Please suggest me a way friends