cancel
Showing results for 
Search instead for 
Did you mean: 

Queries built on ODS

Former Member
0 Kudos

I have a number of ODS which have the BEx flag checked. How can I check which ODS have existing queries built on them? Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

One of the ways could be,Use this -

in SE 16 table V_COMPDIR_COMPIC then get all data targets & query ids, download in Excel & get the list of your ODS.

hope it helps

regards

Vikash

Former Member
0 Kudos

Thanks for that if I go to the table V_COMPDIR_COMPIC there are about 15,000 entries of which only 2,000 are active. I am only interested in the active is that correct?

Former Member
0 Kudos

HI

yes u r right

OBJVERS 'A' and 'D' give the infos you needed

u can select only active one

shreya

Answers (1)

Answers (1)

Former Member
0 Kudos