How to find all the Relevant Customizing Request related to a Specific Config Object Value?

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

How to Find the exact Transport that is moving a Particular Configuration?

SAP Expert Transport tool SE03 for every consultant