cancel
Showing results for 
Search instead for 
Did you mean: 

Add R3TR element to the Transport Request

Former Member
0 Kudos
1,855

Hello BW Experts,

I am transporting a query and get the below error message.

-


Element 40WVM5KB0OENRCAWG7PN2GHM3 is missing in version M

Message no. R9132

Diagnosis

Element &1 in version &2 is referenced but is not available.

System response

The action had to be terminated.

Procedure

Please supply the missing elements to the system by transport.

-


if i go to rsa1 > transport connection > query elements > query > select the query (options dataflow before / only necessary objects )

i do not see the element 40WVM5KB0OENRCAWG7PN2GHM3 in that list given.

I think there is a alternate way of adding particular elements to the request. Wondering if anyone remembers the transaction code / table for add a element to the request.

Thanks,

BWer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

a simple suggestion...

Open the query in Change mode...make some changes and Re save the query and then collect it...

try your luck...

Former Member
0 Kudos

BWer,

Can also try this one. In Tcode SE09, double click on the request/task and switch to Edit mode.

Add R3TR/ELEM/<Element Name> and save it.

Hope this helps...

Former Member
0 Kudos

BWer,

Can also try this one.

In TCode SE09, double click on the request/task and enter in Change Mode.

Add the entry R3TR/ELEM/<Element Name> and save.

Hope this helps...

former_member188975
Active Contributor
0 Kudos

Hi BWer,

It would help to find out what that element is...you can try in table RSZELTTXT or V_ELTDIR_TXT. You can add this manually to the request by double clicking the request and then click to get into Change mode on tab that lists the objects. Here at the end of the list add R3TR ELEM and your element.

Hope this helps...

Former Member
0 Kudos

Bhanu,

You are correct, it is the text element. How did you identify the text element? becuase it is starting with 4* ?

Suggestions appreciated.

Thanks,

BWer

former_member188975
Active Contributor
0 Kudos

Hi,

Not sure if I understood what you are saying...I did not guess anything with it starting with 4*. The tables that I mentioned can help you look at what this element actually is...

edwin_harpino
Active Contributor
0 Kudos

dear BWer,

use following program (create first) to locate the query element

REPORT ZQUERY_DEF_TEST .

Tables: rszeltdir, "query element table

rszelttxt, "query element texts

rszcompdir, "global query elements

e071. "objects in transport requests

*parameters

parameters: Req_id like e071-trkorr.

  • selection screen to input long ID 25 char generated name

select-options: long_ID for rszeltdir-eltuid.

*itab to hold related info

data: begin of i_query_desc occurs 0,

local, "Local to Query

eltuid like rszeltdir-eltuid, "25 char generated ID

compid like rszcompdir-compid, "technical name

deftp like rszeltdir-deftp, "element type

el_txt(16), "element type text

  • txtsh like rszelttxt-txtsh, "short text

txtlg like rszelttxt-txtlg, "long text

owner like rszcompdir-owner, "owner

end of i_query_desc.

data: xlocal.

sy-tvar0 = Req_id.

*find all query objects for transport request entered

select * from e071 where trkorr = req_id and

object = 'ELEM'.

  • add them to the select-options list

long_ID-low = e071-obj_name.

append long_ID.

clear long_ID.

endselect.

*loop through select option table and find details of Query element

Loop at long_ID.

clear: i_query_desc,

rszeltdir,

rszelttxt,

rszcompdir,

xlocal.

select single * from rszeltdir where eltuid = long_ID-low and

objvers = 'A'.

if sy-subrc <> 0.

write: / long_ID-low, ' Query element not found.'.

write: / .

else.

select single * from rszelttxt where eltuid = long_ID-low and

objvers = 'A'.

  • if sy-subrc <> 0.

  • write: / long_ID-low, ' not found in table RSZELTTXT.'.

endif.

select single * from rszcompdir where compuid = long_ID-low and

objvers = 'A'.

if sy-subrc <> 0.

  • write: / long_ID-low, ' not found in table RSZCOMPDIR.'.

xlocal = 'X'.

endif.

  • fill itab for list

i_query_desc-local = xlocal.

i_query_desc-eltuid = rszeltdir-eltuid. "25 char generated ID

i_query_desc-compid = rszcompdir-compid. "technical name

i_query_desc-deftp = rszeltdir-deftp. "element type

case i_query_desc-deftp.

when 'SEL'.

if xlocal = 'X'.

i_query_desc-el_txt = 'Selection'.

else.

i_query_desc-el_txt = 'Restricted K/Fig'.

endif.

when 'REP'.

i_query_desc-el_txt = 'Query'.

when 'VAR'.

i_query_desc-el_txt = 'Variable'.

when 'STR'.

i_query_desc-el_txt = 'Structure'.

when 'CKF'.

i_query_desc-el_txt = 'Calculated K/Fig'.

when 'FML'.

i_query_desc-el_txt = 'Formula'.

endcase.

  • i_query_desc-txtsh = rszelttxt-txtsh. "short text

i_query_desc-txtlg = rszelttxt-txtlg. "long text

i_query_desc-owner = rszcompdir-owner. "owner

append i_query_desc.

clear i_query_desc.

endloop. "@ long_ID

  • list results

sort i_query_desc by local deftp owner.

loop at i_query_desc.

write: / sy-vline,

i_query_desc-eltuid, sy-vline, "25 char generated ID

i_query_desc-compid , sy-vline, "technical name

i_query_desc-deftp , sy-vline, "element type

i_query_desc-el_txt, sy-vline, "element text

*write: / i_query_desc-txtsh , "short text

i_query_desc-txtlg(40) , sy-vline, "long text

i_query_desc-owner , sy-vline.

write: sy-uline .

endloop. "@ i_query_desc

hope this helps.