transport request no. of a query

[Former Member]

I have modified a query and saved it. It is saved in some request. I wanted to know to which request is saved. Please help

[Former Member · Accepted solution]

Hi Pooja,

Check the UID number in the advanced tab by opening the report properties in the Query designer. Copy that number.

go to SE03 -> Search for Objects in Requests/Tasks -> in second box of object selection, give ELEM. In thye next box give the UID of the query.

check the row. Below there are options for modified and released-> give appropriate one among them then execute--> it will display the request in which the query is locked.

Regards

Sunil

[Former Member · Accepted solution]

Following are the fields in se03

PROG Program

FUGR Function Grou - ELEM was given here

CLAS Class - uid entered here

TABL Table/Structu

VIEW View

TTYP Table Type

DTEL Data Element

The message is no request selected. Please let me know where the above inputs are correct

Hi Pooja,

Check the UID number in the advanced tab by opening the report properties in the Query designer. Copy that number.

go to SE03 -> Search for Objects in Requests/Tasks -> in second box of object selection, give ELEM. In thye next box give the UID of the query.

check the row. Below there are options for modified and released-> give appropriate one among them then execute--> it will display the request in which the query is locked.

Regards

Sunil

[former_member202718 · Accepted solution]

hi Pooja,

Try this.....

1)Goto RSA1

2)Transport Connection>Query Elements>Query-->Select Objects

3)Now select the Query for which u want to view.

4)Double click on that and now the Query will open in the Right hand side on the Window or Drag and Drop on Right hand side.

5)Expand the Query---There u can fine Collected objects.... in the same row last Changed by,Transport Request,Package is Avaliable.

6)based on that request ,u can release it and Recollect it in some other request.

OR

1)Goto SE03

2)In the 8 Row Give ELEM , Select the Check Box and Give the element name of the Query which is collected in the SE10.

3)F8 will give u the results

Rgds

SVU

Edited by: svu123 on Jul 22, 2009 9:24 AM

[Former Member · Accepted solution]

Hi Pooja,

Just follow the steps given by me.. you will get it very easily. Go to SE03 -> click on Search for Objects in Requests/Tasks.

Once you enter this screen, you will find the ones mentioned by you.

PROG Program

FUGR Function Group

CLAS Class - uid entered here

TABL Table/Structu

VIEW View

TTYP Table Type

DTEL Data Element

After DTEL, the next row is the one where u need to specify ELEM. From PROG to DTEL(which are appearing default) don't bother about them, You need not check or mention anything in those first 7 row. (i.e from PROG to DTEL)

In the next row specify ELEM and the UID of your query and press Return key(Enter Key). Make sure you check( the first option in the row) this ELEM row.

Next go to status option (the last one on the page). Check Modifiable and uncheck Released in case you request is not released. Then execute by pressing F8.

Let me know in case if you want anything more.

R3TR PROG Program

R3TR FUGR Function Group

R3TR CLAS Class

R3TR TABL Table/Structure

R3TR VIEW View

R3TR TTYP Table Type

R3TR DTEL Data Element

R3TR ELEM Elements of the Que "49T715VQD0T2M96ZVELF2Z264"

Your screen will look as above. 49T715VQD0T2M96ZVELF2Z264 is the UID of the query

Regards

Sunil

Edited by: Sunny84 on Jul 22, 2009 10:36 AM

[Former Member · Accepted solution]

Thanks Sunil for your timely help.

[Former Member]

Hi Pooja,

Go to SE03, and select Search for objects in requests/tasks.

Then, in the object selection empty box select the appropriate type, provide the query technical name, and select Request/Task selection as Modifiable.

Then execute. You will get your transport request no.

Cheers...

Puneesh

[Former Member]

Hi,

You can always see the Transport Request (Globally defined for all Queries) at RSA1 -> Transport Connection -> BEx -> Standard BEx Transport Request.

In case if you dont see any request over there, you can collect the Query in Transport Connection and see the Transport Request in the Column next to it.

Regards,

Chathia.

Edited by: Chathia_P on Jul 21, 2009 9:09 AM

[Former Member]

Hi Pooja,

Go to RSA1 >Transport Connection>On the right pane u will see one button named "Bex"-->click on this

U will be able to see the Bex Request

Hope it helps

Mann