Skip to Content
Former Member
Sep 13, 2017 at 08:55 PM

Query Reservations x Purchase Requisitions


Hello PM an MM Experts.

I'm trying to create a query to report the Purchase Requisition number base on the Reservation and Reservation Item.

To do that I'm using RESB and EBAN tables. When I execute the query, the answer is always "No data found to show"

When I run the tables separately, I see that in the RESB table, the fields BANFN and BNFPO are empty, and in the EBAN table, the fields RSNUM and RSPOS are empty as well.

Is this the reason why the query doesn't execute correctly? Does anyone know why does it happen? Does anyone knows other tables or T codes that could do the job?