cancel
Showing results for 
Search instead for 
Did you mean: 

where used list of a charcteristic in queries

Former Member
0 Kudos

Hi,

I would like to know where used list of a Characteristic in Queries. We can have the information for Keyfiures but for a charcteritic is there any method..i tried with RSD1..not bale to get the info...

thnx.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Reddy,

Try to execute the code given here, it will give you the infoobject name, infocube name, query name and the description.

tables : RSZRANGE, "table

RSZELTXREF,

RSZELTTXT,

RSRREPDIR,

RSZSELECT,

RSZCOMPDIR.

data : begin of IT_RSZSELECT occurs 0,

iobjnm like RSZSELECT-iobjnm,

eltuid like RSZSELECT-eltuid,

end of IT_RSZSELECT,

begin of IT_RESULT occurs 0,

iobj like RSZSELECT-iobjnm,

iobjnm like RSZSELECT-iobjnm,

infocube like rszeltxref-infocube,

compid like rszcompdir-compid,

txtlg like rszelttxt-txtlg,

laytp like rszeltxref-laytp,

end of IT_RESULT.

data : iobj2 like RSZSELECT-iobjnm,

l_count type I.

select-options : IOBJ for RSZSELECT-IOBJNM.

write 😕 'Infoobject : ', IOBJ+3.

write at /20(30) 'Name'.

write at 50(15) 'Infocube'.

write at 65(30) 'Query Tech Name'.

write at 95(50) 'Description'.

loop at IOBJ.

l_count = 0.

concatenate '%' iobj-low into iobj2.

select iobjnm eltuid

from rszselect

into table it_RSZSELECT

where ( iobjnm in IOBJ or

iobjnm like IOBJ2 )

and objvers = 'A'.

loop at it_RSZSELECT.

it_result-iobj = iobj.

it_result-iobjnm = it_RSZSELECT-iobjnm.

select *

from rszeltxref

where teltuid = it_RSZSELECT-eltuid

and objvers = 'A'.

  • Query description

  • field txtlg

select *

from rszelttxt

where eltuid = rszeltxref-seltuid

and objvers = 'A'.

endselect.

  • Query technical name

  • field compid

select *

from rsrrepdir

where compuid = rszeltxref-seltuid

and objvers = 'A'.

endselect.

endselect.

it_result-infocube = rszeltxref-infocube.

if it_result-infocube = ''.

it_result-infocube = rsrrepdir-infocube.

endif.

it_result-compid = rsrrepdir-compid.

it_result-txtlg = rszelttxt-txtlg.

it_result-laytp = rszeltxref-laytp.

append it_result.

endloop.

sort it_result by infocube.

loop at it_result.

l_count = l_count + 1.

write at / l_count.

write at 20(30) it_result-iobjnm.

write at 50(15) it_result-infocube.

write at 65(30) it_result-compid.

write at 95(50) it_result-txtlg.

endloop.

endloop.

  • table that store navigation attribute info : RSDCUBEIOBJ(infocube),

*RSDATRNAV(characteristic)

Hope it helps you!!!!

Do not forget to assign points, if helpful.

Regards,

Amit

0 Kudos

dear Amit,

is it the same program/report from this thread ?

thanks.

Former Member
0 Kudos

Hi A.H.P,

Yes, it is. I was looking for this particular link but couldn't find hence pasted the code.

Also, I was not sure who had posted the code, so didn't mention the name.

Apologize for that!!!!

Regards,

Amit

Answers (2)

Answers (2)

0 Kudos

hi,

try function module (se37)

RSZ_I_BASIC_CHA_WHERE_USED

parameter

I_IOBJNM = your infoobject

I_OBJVERS = A

I_QUERIES_ONLY = X

hope this helps.

Former Member
0 Kudos

Hi,

I tried to execute RSZ_I_BASIC_CHA_WHERE_USED, but its taking long time and getting strucked. SO do we have any other way to get it done.

Amit I cant execute the report you have given because we dont have authorization to do that in SE38.

Thnx.

Former Member
0 Kudos

Hi,

In order to run the program, you need to ask ur Basis people to assign you the authorization to execute SE38 transaction.

Hope it helps.

Amit

0 Kudos

hi,

it seems your characteristic is used in lots of query, try with a rare used characteristic. since you have no authorization to se38, please ask your abaper to create a small program to run this function module RSZ_I_BASIC_CHA_WHERE_USED in background.

let's know if this function module or the program fulfill your requirement, some other codes on queries have been posted.

hope this helps.

  • @Amit, absolutely no problem

Former Member
0 Kudos

Hi Guys,

My problem got solved using RSZ_I_BASIC_CHA_WHERE_USED. Still I need to try with the program. Thanx guys for your fast and effective response.

Thanx.

Former Member
0 Kudos

Hi,

try this -

Go to InfoObject ( double click) -- top menu --edit -- where used list.

It will show you list of every thing including queries this infoobject is used.

hope it helps

regards

VC