Request System Status Table

[former_member184342]

Which table holds the information of the status of the request when comes to which system it is released (DEV, QA , PRD)?

[PeterJonker]

TPSTAT ,but if you are using Solution Manager you will only be able to find the generated test transport request

[former_member184342]

Hello, Peter

I´m not using Solman and haven´t got many results, just 14 entries in all table.

[roberto_vacca2]

Hi.

E070-TRSTATUS

Hope to help

Bye

[former_member184342]

I´m using SAP ECC 6.0 and i haven´t found this table.

[RaymondGiuseppi]

You didn't try to analyze FM TR_READ_GLOBAL_INFO_OF_REQUEST?

Regards,

Raymond

[former_member184342]

I tried it now, but I have a list of requests (850) and need to know which ones was transported to Production

[oliver_wurm]

Hi Ramires,

if you run this Analysis on the Development Box you need to use something like function module TR_READ_GLOBAL_INFO_OF_REQUEST simply because there is no update of the development box when the Transport is imported in production. So the COFILEs of the transports need to be analyzed. That is what the Function Module does ...

Regards

Oliver

[RaymondGiuseppi]

So use the FM in a LOOP, in the resulting deep structure look for existence/status of the production system.

DATA: es_cofile TYPE ctslg_cofile,
      system TYPE ctslg_system.
CALL FUNCTION 'TR_READ_GLOBAL_INFO_OF_REQUEST'
  EXPORTING
    iv_trkorr = iv_trkorr
  IMPORTING
    es_cofile = es_cofile.
LOOP AT es_cofile-systems INTO system.
* for systemid = 'PRD' look at rc - if found imported,
* if rc 0 okay, 4 warning is okay too (e.g. deletion of object)
ENDLOOP.

Regards,

Raymond