Which Transports moved determined table entries

[Former Member]

Hello

I need to know which transports were used to move entries from some tables, is there any way to do that?

TIA

[uwe_schieferstein]

Hello Scott

Call transaction <b>SE03</b> (<i>Transport Organizer Tools</i>) and choose <i>"Objects in Request -> Search for Objects in Request/Task".</i>

The selection-screen does not allow to search for table entries directly. However, at least you can narrow the search.

Since you know the table, enter in "Object Selection" <b>R3TR TABU</b> and the <b>table name</b> and mark this selection. If it is a customizing table and you know its corresponding IMG activity you can fill the corresponding parameter.

Transport request data are stored in three tables:

- E070: Request (header)

- E071: Request Objects

- E071K: Key Entries

With the requests found using SE03 you select the key entries in E071K in transaction SE16. Since you know the entries you are looking for you have to fill the select-option for tabkey. The following sample shows an entry of the customizing table T001W (<b>TABKEY</b>=8004100, client=800, plant=4100).

TRKORR        DH3K900319              
PGMID         R3TR                    
OBJECT        TABU                    
OBJNAME       T001W                   
AS4POS        1                       
                                      
MASTERTYPE    VDAT                    
MASTERNAME    V_T001W                 
VIEWNAME      V_T001W                 
OBJFUNC                               
TABKEY        8004100                 
SORTFLAG      2                       
FLAG                                  
LANG                                  
ACTIVITY      SIMG_CFMENUSAPCOX10

If you need this information more frequently then you should define an appropriate DB view for selection.

Regards

Uwe