Tables or Logical database to create standard report for Equipment BOM?

Dear All

My client has requirement for the report with fields like to see the status of Equipment BOM(input of Equipment number in selection screen) or for Particular set of Materials(input of component number in selection screen) available stock quantity,storage location of stock,description of component,price of component,Pending PR of component(if any),Pending PO of component(if any) etc

I want to develop the report with standard infoset query instead of going for abap development.is there any logical database to map the report or what tables can i use for table joins??

Required sample report with fields as below

BOM Component

Stock available/Not available indicator

Description of Components

BOMQty/ UOM

Price

Part Number

Plnt

Sloc

Stock Qty

Bin

Pending PR

Pending PO

1000001121

YES

BEARING

NO

2000

ERS22

1000

MECH

4

A1

300012431

-

Regards

M.Manojkumar