Introduction
Every Project you go you will have to Manage Transports as you are constantly moving Objects. It would be wonderful to pin point the Transports related to a particular Config Object Value like a Plant/ Company Code/ Sky is the Limit. We have a lot in SAP. Configuration request contains all the changes that does Magic and the Magicians are the SAP Functional Consultant.
Solution
This can be used in both SAP ECC and SAP S/4HANA
Go to SQVI. You can also use SE16H in SAP S/4HANA
Create the Below Query with Table Join
Now Create the following Join of the Table
Here is the Report Layout
Here is the Selection Screen
Suppose I wish to see all the Entries for Plant 1710. Since it is Plant I will use table T001W. If it was Company code we will use T001
Wala below is the output
Conclusion
This will save you a lot of time in Investigating what Transports have moved and what is missing and also helps in investigation of issues.
Below is the video version
https://youtu.be/Paa60_jtv8k
How to Find the exact Transport that is moving a Particular Configuration?
https://youtu.be/l-b0aaOqk1Y
SAP Expert Transport tool SE03 for every consultant
https://youtu.be/5ylSesQTBpw