cancel
Showing results for 
Search instead for 
Did you mean: 

List of Variables for a Char ?

Former Member
0 Kudos

Hello BW Experts,

Could you please tell me a place where I can find the list of variables for the given char with out the need of going to the Bex and creating a test query or search for a existing query on the give cube.

Thanks,

BWer

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi,

can go to metadata repository ? >> infoobject, there is list of variables used ?

Former Member
0 Kudos

metadata repository is not working. is there any other way of doing this. is there any table where i can find this info?

former_member188975
Active Contributor
0 Kudos

Hi BWer,

Look up table RSZGLOBV. You can put in the InfoObject name and search for the different variables.

Hope this helps...

Answers (2)

Answers (2)

0 Kudos

hi BWer,

sorry, wrong posting

0 Kudos

hi BWer,

try following code, you may need to do some modification.

REPORT ZZZ_QUERY_ELEM.

Tables: rszeltdir, "query element table

rszelttxt, "query element texts

rszcompdir, "global query elements

rszeltxref.

*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.

clear: i_query_desc,

rszeltdir,

rszelttxt,

rszcompdir,

rszeltxref,

xlocal.

select-options:

  • query technical name.

s_qtn for rszeltdir-mapname.

select * from rszeltdir where mapname in s_qtn

and objvers = 'A'.

select * from rszeltxref where seltuid = rszeltdir-eltuid

and objvers = 'A'.

if sy-subrc <> 0.

write: / rszeltdir-eltuid, ' Query element not found.'.

write: / .

else.

select single * from rszelttxt where eltuid = rszeltxref-teltuid and

objvers = 'A'.

endif.

select single * from rszcompdir where compuid = rszeltxref-teltuid 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 = rszeltxref-teltuid. "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.

endselect.

endselect.

  • 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