Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Table containing the released transport request

Former Member

‎2006 Dec 12 2:13 PM

0 Likes
9,581

Hi Developers,

I have a transport request that is released in the Quality Server, but not yet transported to the PRD server. I want to fire a select query in the PRD server, using this request to check if it is valid. Now since the request has not yet been transported or rather imported to PRD server, it will not show up in SE09 transaction nor will it show up in the tables E07T, E071, E070.

I need to know a table that will conatin all the requests including the one that have been released and not transported/imported. So that I can fire a select querry to this table which will not fail in the PRD server also.

If the question is not clear, please ask again. Best answers will be rewarded....

Thanks and regards

Anirban

Hi Developers,

I have a transport request that is released in the Quality Server, but not yet transported to the PRD server. I want to fire a select query in the PRD server, using this request to check if it is valid. Now since the request has not yet been transported or rather imported to PRD server, it will not show up in SE09 transaction nor will it show up in the tables E07T, E071, E070.

I need to know a table that will conatin all the requests including the one that have been released and not transported/imported. So that I can fire a select querry to this table which will not fail in the PRD server also.

If the question is not clear, please ask again. Best answers will be rewarded....

Thanks and regards

Anirban

Reply
7 REPLIES 7
Read only

Former Member

‎2006 Dec 12 2:20 PM

0 Likes
4,254

The table E070 will have all the requests.

YOu have to check the field: TRSTATUS for the following values:

D Modifiable

L Modifiable, Protected

O Release Started

R Released

N Released (with Import Protection for Repaired Objects)

Regards,

Ravi

Read only

Former Member
In response to Former Member

‎2006 Dec 12 2:45 PM

0 Likes
4,254

Hi Ravi,

That is what I said the E070 table does not conatin the request. I have the request number showing in my Quality server with status in the TRSTATUS field as released. But it has not been imported into PRD server as yet, or in other words it has not been transported from QA2 server to PRD. So at this point this request is available in QA2 server in the E070 tables but is missing in PRD server. Will also not show up in SE09 transaction in PRD.

Now I want to know of the SAP repository table that stores all the requests which can be referred from any server, or to put it simply, how can I read and validate this request in my select querry from the PRD server??

Please help, helpfull answers will be rewarded....

Anirban

Read only

Former Member

‎2006 Dec 13 2:36 AM

0 Likes
4,254

Hi Anirban

If you can make use of Table: <b>TMSBUFREQ</b> & FM: <b>RFC_READ_TABLE</b>, i guess you can meet the requirement. Please check.

Kind Regards

Eswar

Read only

Former Member
In response to Former Member

‎2006 Dec 13 10:34 AM

0 Likes
4,254

Hi Eswar,

Thanks for the answer. It was helpful, but this table and the table TMSBUFTXT will contain the request only if the request is released (not transported). Lets say I have a request in DV2 server (development). This request is not released, but just created. At this point if we log into the PRD (production server) and check tables TMSBUFTXT and TMSBUFREQ, they will not contain the request. For this I found the Function Module "TMS_MGR_READ_TRANSPORT_REQUEST". Please check it. Its a superb FM. It returns all data for the request even in PRD server.

But your answer was very helpful, it showed me the right direction. Awarded points.

Thanks

Anirban

Read only

Former Member
In response to Former Member

‎2006 Dec 14 9:10 AM

0 Likes
4,254

HI Anirban

That was really a good FM. Thanks for sharing...

It would have been better, if i can reward you on this...:)

Kind Regards

Eswar

Read only

Former Member

‎2006 Dec 13 4:55 AM

0 Likes
4,254

hi...

jus try using this table table <b> TMSBUFREQ</b>

this mite give the requirements u hav mentioned.

reward if useful.

Read only

Former Member

‎2007 Jan 02 4:15 PM

0 Likes
4,254

Hi developers,

It had helped me a lot.

Could u tell is there any FM,program that will automatically reads the request that are released in one client and that will import and release the request in another client.

or is there any other way to do it automatically.

We are trying to make it automatic releasing of request by scheduling.

Thanks & regards

Obli