The easiest way to find objects is to use transaction SE03, also called Transport Organizer Tools. Within this transaction, there is a menu item “Find Objects in Transport Requests / Tasks”.
SAP Transaction SE03- Transport Organizer Tools
Execute it to get to another screen, in which you can search for specific objects and their properties, e.g. by the name of the SAP object you need to find in a transport request.
SAP – Finding objects in a transport request
Execute this report to get a list of all transport requests that contain the specific object you’re looking for.
To use a more direct approach, you can also have a look in the tables E070 and, more importantly, E071. Run transaction SE16 or SE16N and enter E071 as table, press F8 or click “Execute”. In the generated report, you can search for your object in the table fields OBJECT (type of object, such as PROG for a program) and OBJ_NAME (name of the SAP object you want to find). Run the report to generate a result and get a list of all transport requests that contain the specific object you are looking for.