Where-used list of a resource

Dear Gurus,

We are currently creating a Cuztomized report based on Capacity. One of the selection parameters is the resource. We need to get the Products which uses the resource something like the where used list function in the transaction /SAPAPO/RES01.

Are there tables I can connect or BAPI or function modules which have the above function?

Please help.

Thanks,

Raymond