topic Re: Request System Status Table in Application Development and Automation Discussions

Request System Status Table

former_member184342 — Wed, 23 Sep 2015 12:27:33 GMT

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

Re: Request System Status Table

PeterJonker — Wed, 23 Sep 2015 12:33:59 GMT

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

Re: Request System Status Table

roberto_vacca2 — Wed, 23 Sep 2015 12:34:49 GMT

Hi.

E070-TRSTATUS

Hope to help

Bye

Re: Request System Status Table

RaymondGiuseppi — Wed, 23 Sep 2015 12:37:50 GMT

You didn't try to analyze FM TR_READ_GLOBAL_INFO_OF_REQUEST?

Regards,

Raymond

Re: Request System Status Table

former_member184342 — Wed, 23 Sep 2015 13:39:18 GMT

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

Re: Request System Status Table

former_member184342 — Wed, 23 Sep 2015 13:41:00 GMT

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

Re: Request System Status Table

former_member184342 — Wed, 23 Sep 2015 13:44:00 GMT

Hello, Peter

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

Re: Request System Status Table

oliver_wurm — Wed, 23 Sep 2015 13:49:45 GMT

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

Re: Request System Status Table

RaymondGiuseppi — Wed, 23 Sep 2015 15:05:02 GMT

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