Hello,
I'm trying to create a query where I can list the items that have been transfered from one warehouse to another, along with the GRPO receipt date.
Reason is when items ship from the offshore warehouse, they're received into a transit warehouse. When they arrive, they're transferred from the transit warehouse to finished goods. Need to query how long from receipt date to transfer date. Items are also lot controlled.
Tried joining OPOR, OWRT, and OIBT tables, but cannot find names to join.