Variables - User Entry

[Former Member]

How can I check in what queries a variable is used? Thanks

[edwin_harpino · Accepted solution]

hi Niten,

in bex analyzer, right click the variable, and 'where used list'.

hope this helps.

[Former Member · Accepted solution]

Thanks for that at the moment I just have the variable name and no details of any queries which I can open and carry out a where used

[Former Member · Accepted solution]

Hello Niten,

Please look at RSZGLOBV table. check if it helps..

thanks,

[Former Member · Accepted solution]

Hello Niten,

Variables are infoobject specific.

You need to track the queries in which these infoObject is used.

thanks,

[edwin_harpino · Accepted solution]

hi Niten,

try table RSZCOMPDIR, type in variable name for field COMPID, and get COMPUID,

then table RSZELTXREF pass COMPUID to field TELTUID and fill LAYTP = VAR and OBJVERS = A, get all SELTUID,

and go to table RSZELTDIR, pass these values to field ELTUID, you will get all query name in field MAPNAME

(also INFOCUBE is the infocube name)

or if you go with infoobject approach, use function module

RSZ_DB_VARIABLE_GET variable get infoobject

RSZ_I_BASIC_CHA_WHERE_USED infoobject query where used list

• RSZ_DB_VARIABLE_LIST_GET infoobject get variable name

hope this helps.

[Former Member]

Hi niten

go through this previous posting on similar query

Regards

kiran