database table for characteristics which used in Bex queries

[Former Member]

Hi, Experts,

Now we need analysis all of characteristics which used in each of Bex queries.

In stead of mannual open the query and check, I believe there are related database table to store those information in BW system.

Does Anybody know those tables ??

Regards

Jie

[edwin_harpino · Accepted solution]

hi Jie,

yes, try function module RSZ_I_BASIC_CHA_WHERE_USED

also check this (try the program)

hope it helps.

[Former Member · Accepted solution]

Hi AHP,

Can you please help me out with my problem.

I am trying to create a generic FM extractor on a table that has creation data and change date. I need to extract all new records and all changed records.

My first doubt is do I need to use RSO2 to set up delta (but I can give only one date field in RSO2) or create a custom delta in my code? or do both??

Can you send me a sample code please if you have any.

I would greatly appreciate your help.

Thanks,

Vinod.

[Former Member · Accepted solution]

Hi, A.H.P

this FM looks get where use list of infoObject which used in which cube, query, ect.

Can I do reverse way, from one query, I can get all of used infoObjects inside it. it's helpful for our analysis

thanks

Jie

[edwin_harpino · Accepted solution]

hi Jie,

try :

- table RSZELTDIR

MAPNAME - query technical name

get ELTUID - query ID

- table RSZELTXREF

SELTUID = RSZELTDIR-ELTUID

get TELTUID

- table RSZRANGE

ELTUID = RSZELTXREF-TELTUID

get IOBJNM

or following code

report zio_query.

tables: RSZELTTXT,

rszeltdir,

rszeltxref,

rszrange,

RSZSELECT.

data : begin of it_result occurs 0,

iobjnm like rszselect-iobjnm,

end of it_result,

lv_iobjnm like rszselect-iobjnm.

select-options:

s_query for rszeltdir-mapname.

start-of-selection.

----

---

select * from rszeltdir where mapname in s_query

and objvers = 'A'.

select single * from RSZELTTXT where eltuid = rszeltdir-eltuid

and objvers = 'A' and langu = 'N'.

write: / rszeltdir-mapname, rszelttxt-txtlg.

refresh it_result.

select * from rszeltxref where seltuid = rszeltdir-eltuid

and objvers = 'A'.

*characteristics

select iobjnm into lv_iobjnm

from RSZSELECT where eltuid = rszeltxref-teltuid and objvers = 'A'

and iobjnm <> '1KYFNM'.

it_result-iobjnm = lv_iobjnm.

append it_result.

endselect.

*keyfigures

select low into lv_iobjnm

from rszrange where eltuid = rszeltxref-teltuid and objvers = 'A'

and iobjnm = '1KYFNM'.

it_result-iobjnm = lv_iobjnm.

append it_result.

endselect.

endselect.

sort it_result by IOBJNM.

• delete adjacent duplicates from it_result comparing mapname IOBJNM.

loop at it_result.

write: / it_result-IOBJNM.

endloop.

uline.

endselect.

[Former Member · Accepted solution]

Hi, A.H.P

I use quick view join the three tables:

RSZELTDIR

RSZELTXREF

RSZRANGE

the results only display the infoobjects which used in Query filter. for other infoObject which used in Column and row and others, which not displayed.

Regards

Jie