BOM details required

Hi,

I need to know the sub part no for a specific part no.

I request you to also tell me how will I know which is the mail part no and the sub part related to it.

I need to get the details for the subpart whoses quantity is less for production purpose.

Need the fields which I need to work on.

Regards,

Kamlesh