Table to find the transport requests created for a particular project

[Former Member]

Hi All,

I want to know the database table in which the transport requests created for a particular project will be stored.

My requirement is, I want to consolidate all the TR details which are saved for a particular project. Ex: If my Project name is 'ABC'

I want to find out all the TRs created under that ABC project.

Suggest me the ways to find out the details.

Thanks in advance.

Uday Kumar.

[Former Member]

Hi dear ,

for this table SNODETEXT is there that having all records of TR .

and program name is SAPLSTRH.

Thanks

Girish

[Former Member]

hi,

Please check the table - E070,hope you will get the required transport details .

Thanks!

[Manohar2u]

Here is how the link between project and transport number

CTSPROJECT-TRKORR = E070A-REFERENCE

Hope you got it.

[suman_pr]

Hi,

Some of the tables of interest would be

E070 -> Change & Transport System: Header of Requests/Tasks

E070A -> Change & Transport System: Attributes of a Request

E070C -> CTS: Source/Target Client of Requests/Task

E070CREATE -> Change & Transport System: Creation Date of Request

E070DEP -> Change & Transport System: Dependencies of Requests

Regards

[birendra_chatterjee]

Hi Uday,

You need to go to table E071 (Change & Transport System: Object Entries of Requests/Tasks), and enter the name of Your object in field OBJ_NAME (Object Name). This will help You getting all transport requests associated with your object of interest.

Regards,

Birendra

[Former Member]

I got the required answer.

The details can be derived from table E070A.

Thank you people , for your reply.

[Former Member]

Hi Uday,

I am also looking for the same, but in E070A the project name is not diaplayed. Can you let me know if you have teh answer for this?

Anand

[Former Member]

Hello Anand,

Table TLOCKP contains the project and the transport request.

Brenda