How to check the status of a transport request no?

[Former Member]

hai

Iam developing a customized report which should show all the transport request no of customized reports (ie. Zreport) which have not been moved to quality or

production server

Iam able to get list of transport requests from E070/E071

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

Can any one help me?

regards

Jayaanand

[kesavadas_thekkillath]

Check transport logs from SE01.

Via function module SAP Community Network Wiki - ABAP Development - Function to get Transport request Logs

[former_member209119]

Hi,

check the below link for your answer.

http://scn.sap.com/thread/1134078

Reward if useful.

[former_member198275]

Try below logic to read remote system records , here you will get all you need:

* read table E070CTV from remote system

   call function 'RFC_READ_TABLE' destination <UR Remote system>

        exporting

             query_table          = 'E070CTV'

*           DELIMITER            = ' '

*           NO_DATA              = ' '

*           ROWSKIPS             = 0

*           ROWCOUNT             = 0

        tables

             options              = itab_options

             fields                 = itab_fields

             data                  = itab_data

[Former Member]

Hai

Thanks for your response

Iam able to get the report.

Jayanand

[GauthamV]

Use below function module.

TR_READ_GLOBAL_INFO_OF_REQUEST

[Sijin_Chandran]

HI Jayalakshmi ,

This thread may help you out :

http://scn.sap.com/thread/1134078

And I think you can't check whether a request has been transported or not from E070 and E071.

You can only check whether the request has been released or not.

Field TRSTATUS in E070 will have value D for Modifiable req and R for released.

For getting transport time details I guess you need to implement the above BADI and capture details in a ZTABLE 

[Former Member]

Hi,

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

Regards

Tejas

[Former Member]

Hi Jayaanand,

In se10, status can be seen whether given transport id has been moved to production or quality systems.

Moreover,try implementing the BADI CTS_IMPORT_FEEDBACK.

This method is triggered at the end of each import and returns a table with following structure:

TRKORR

TARSYSTEM

TARCLIENT

RETCODE

OWNER

PROJECT

Hope it helps!.

Thanks!!!!!

Alora

[Former Member]

Hi,

Please find the details in Table : TMSBUFTXT.

But it shows only those request , which moved to production server.

Development, Quality and Production are three different servers with diff databases. So you can't find the details of all three servers from production servers.

You will have to generate reports for different servers.

Regards,

Ravi Pratap Singh

[Former Member]

Hai

Thanks for everyone who give response.

I used function TR_READ_GLOBAL_INFO_OF_REQUEST

Regards

Jayaanand

[Former Member]

Hi,

If your requirement is fulfilled then please make the discussion Answered..

regards

[Former Member]

Hai

Thanks for your answer.

I used the function 'TR_READ_GLOBAL_INFO_OF_REQUEST  and it is working

[Former Member]

This message was moderated.