RFCSUPPORT for queries

[Former Member]

Dear Experts,

I have figured out that

to get a list of all the BI queries having "Allow External Access" checked, I need to look in to the field

RFCSUPPORT in table RSRREPDIR. I checked the VERSION field in this table and it contains the following

values - D,A,M and B.

D - Delivery

A - Active

M - Modified

B - ???

What is this B?

also, there is another field "Stat" which gives object status

If I need to get a list of all the current queries in the system with extrenal access, how should I restrict the VERSION field and the "Stat" field?

Thanks,

Kris

[former_member182470]

Hi,

Check this:----

---

Regards,

Suman

[Former Member]

Now Iam confused .. Which method should I follow to find queries with external access??

or

HELP!!

[former_member182470]

Hi,

Easiest way is through RSRREPDIR table with RSCSUPPORT field.

The other way is RSZELTDIR table with MAPNAME. Refer my earlier given thread.

Regards,

Suman

[Former Member]

Ok.But when I checked with both methods .. the numbers are varying..with one method (RSRREPDIR) I got 64 and with the RSZELTDIR method I got 397...??

[former_member182470]

Hi,

Even I checked in my system, both counts are different. So I feel RSRREPDIR table is the appropriate one.

Regards,

Suman

[Former Member]

is the value difference very large?

[former_member182470]

Hi,

Yes, it was very large. So it's better to go with RSRREPDIR table.

Regards,

Suman

[Former Member]

Hi,

When you see RSZ.... table that shows all the elements of the query (Active as well as Inactive,variables.formulaeetc) not only the query. Hence go for the teble RSRREPDIR.

Navesh

[Former Member]

I found some problems with the RSRREPDIR method-

I found many queries with Version = "A" and ObjStat = "INA" with RFCSUPPORT = "X". But when I checked these queries in query designer they were not having the "allow external access" enabled...

And I found 1 query with Version = "A" and ObjStat = "ACT" with RFCSUPPORT = "X", But when I checked this query in query designer it was not having the "allow external access" enabled...

Is this method reliable?

[Former Member]

Hi,

For getting your desired result the Version field should be 'A' and STATUS should be 'ACT' (it is for Active status and 'INA' is for Inactive status.)

Also only following 4 values are possible for Version field :-

Object version

BI objects are maintained in versions to enable you to edit, execute and deliver different characteristics for an object in parallel.

In particular, the following versions exist:

Revised: This version only exists for the duration of the dialog. By using the function Save or Activate, the revised version is written as an M or A version on the database.

The M version is the last revised and saved version of an object. This can never be executed or used, it is only used to separate editing and the use of an object.

The A version is the active version. Only this version can be executed or used by other objects.

The D version is the version delivered by SAP. With a D version (that in practice has the character of a suggestion or template), SAP can deliver objects independently of the version that is active at the customer site.

And we have following values for Status :-

Object Status

For each object, the Business Information Warehouse has a status that indicates whether the object is currently executable or useable.

In particular, the following 4 statuses exist, from which ACT' and 'PRO' are the ones that indicate that the object is executable/useable:

'ACT' = active, executable. An object with this status can be executed or used.

'PRO' = productive. This status is a one step futher from 'active', but is currently not yet in use.

'INA' = inactive. The object is not executable/useable. This is the case , for example, if

the object has been created and saved for the first time, but has not yet been activated,

the object firstly has to be revised after changing one of the others.

'OFF' = switched off. The object is not useable. It was deliberately switched off so as not to appear, for example, in the list of useable objects.

Hope it clarifies all your doubts.

Navesh