Query for GRPO and Inventory Transfer

[sara-feg]

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.

[former_member27]

Hi sara_feg,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi