Search ABAP Objects in SAP Transport Requests and Tasks

How to check whether a particular transport request number is transported to a SAP quality server or production server?

SAP TMS Manager Table TMSBUFREQ

Field name: UMODES
Data element: TRTPUMODES
Field description: tp Unconditional Modes
Possible values:
I Imported

Field name: IMPFLG
Data element: TRTPIMPFLG
Field description: tp Import Flag
Possible values:
0 No request (control information)
1 Request waiting to be imported
2 Request already imported
3 Requests in this source system are excluded from the import
4 Only for internal use by tp
5 Requests not selected are excluded from the import
6 Selected requests are excluded from the import
7 Target client is not imported
8 Transport request is already in the system
9 Transport request belongs to another project
C Requests of transport type C excluded from import
E Requests of transport type E excluded from import
K Requests of transport type K excluded from import
M Client transports only imported as single imports
O Requests of transport type O excluded from import
T Requests of transport type T excluded from import
W Requests of transport type W excluded from import
c C request waiting for import
d D request waiting for import
e E request waiting for import
k K request waiting for import
m Client transports waiting for import
o O request waiting for import
t T request waiting for import
w W request waiting for import

Field name: ACTFLG
Data element: TRTPACTFLG
Field description: tp Active Flag
Possible values:
I ...
X ...

Field name: TRFUNC
Data element: TRFUNCTION
Field description: Type of request/task
Possible values:
K Workbench Request
W Customizing Request
C Relocation of Objects Without Package Change
O Relocation of Objects with Package Change
E Relocation of Complete Package
T Transport of Copies
S Development/Correction
R Repair
X Unclassified Task
Q Customizing Task
G Piece List for CTS Project
M Client Transport Request
P Piece List for Upgrade
D Piece List for Support Package
F Piece List
L Deletion transport

ABAP Table TMSBUFREQ-Transport Requests in Transport Buffer

Please use FM 'TR_READ_GLOBAL_INFO_OF_REQUEST'. It will return system in the variable es_cofile-systemid. Check the variable es_cofile-rc If rc = 0 then present in system if rc = 4 then warnings are generated if rc= 8 not transported