How to find Infoobject is in Free Characteristic or in Row in Bex using SAP tables

[Former Member]

Hi,

I have a list of 2000 queries wanted to know particular infoobject is present in Free characteristic or in row of query ,pls provide me some tips how i can find it.

I have tried using table

RSZSELECT

RSZELTDIR

RSZELTXREF

RSRREPDIR

With smart use of above table i can find out whether infoobject is used in query or not, but still no success in finding whether infoobject is present in Free Characteristic or in Row , i don't want to sit and open one query at a time in query designer or in metadata to find these details.

Regards,

Ajit Mishra.

[RafkeMagic · Accepted solution]

you can check the code behind transaction RSRTQ...

[Former Member]

Hi Ajit,

I also have an similar requirement & found the following way.

Table RSZSELECT will provide the required information.

Filter on the field IOBJNM for the list of infoobjects & SOTP will specify the corresponding information of free-characteristic or Default Filter.

0	Default from Releases < Apollo (Corres. Selection Area)
1	Selection Area (Filter)
2	Start Value
3	Both (1 and 2, Only in RSZSELECT)

[former_member667783]

what to put in the table for selection > ?

[Former Member]

Hi Ajit

Please check below links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/800e7e04-d969-2e10-10bf-98182a012...

http://sapbi7bo.blogspot.in/2012/12/how-to-find-in-which-queries-infoobject.html

Hopes, it may help you.

Thanks,

Avadhoot

[KamalMehta]

Hi Ajit ,

Please check RSRTQ once . You may get what you need here.

Please check http://scn.sap.com/community/business-explorer/blog/2013/06/17/rsrtq-query-definition-multipurpose-t...

Thanks

[Former Member]

RSRTQ T-code is using Query defination Program, it takes one input at a time, give multiple input at same time i need to debug it, which i am doing.

kinldy let me know if you already know which all tables are getting hit to find out Infoobject in free char and rows.

Thanks for your help kamal and Raf, my issue is not resolved yet so not closing this discussion.

[RafkeMagic]

you already have the base tables figured out... now it's just about which "filters" to place on which column (if I recall correctly... worked with this a couple of years ago... the logic is a bit different between 3.x and 7.x, but the tables are the same)