Identify which transport an object is located in
If you're trying to find out in which transport a particular object was changed, you can go to SE03 and use the standard search transport request function. To do that, though, you need to know not only the object name but also the program type etc. - essentially, you need to specify what the entry looks like in the transport request, which may be a bit bothersome.
An easier solution is to look up the corresponding database tables correctly: