Hello,

I've got a request from users to provide a BI query for Warehousing picking history.
My first approach was to start with the whinh270 (Outbound Order Lines History) in order to display the number of pickings in status Staged per user and per date.
A few days ago our users requested in a second tab to display the pickings by Warehouse locations which are not available in the main table.
I'm since then I'm trying to match my Outbound historical date with other tables like whinr100 (Inventory transactions by Stock Point) or whinh225 (Outbound Advice) but its really a pain inte ass as the only key would be the Order number (orno) and the position(pono). I tried with kost = 5, warehouse and a few seconds before or after) but I'm not confident.
Would you perhaps have some other tables or approach that I can use to answer that need?
Thanks in advance.
Stephane