How to get all production orders for a workcenter

Hello ...

I have a requirement to create a report of all production orders for a given workcenter. The user enters the workcenter (CRHD-ARBPL), plant (CRHD-WERKS) and a date range, and wants to see a list of orders (AUFNR) that fall within that date range along with some other data from AFKO and AFPO.

I can't figure out a good, consistent way to get from workcenter to production orders.

Any ideas?

Thanks!

Sharon