BEx Query

[phil_moh]

Hi,

I am trying to get the list of BEx Query (all of them) in  the system.

I tried table RSRREPDIR, COMPTYPE = REP and OBJVERS = A. I have total of 1597.

I tried table RSZELTDIR, DEFTP =REP and OBJVERS = A. I have total of 1443.

Please confirm which table I can use to get a list of all the BEx Query in the system.

Thank you.

[phil_moh]

Hi,

I am trying to get the list of BEx Query (all of them) in  the system.

I tried table RSRREPDIR, COMPTYPE = REP and OBJVERS = A. I have total of 1597.

I tried table RSZELTDIR, DEFTP =REP and OBJVERS = A. I have total of 1443.

Please confirm which table I can use to get a list of all the BEx Query in the system.

Thank you.

[FrankRiesner]

Hi Phil,

I think, in RSRREPDIR you need to filter on OBJSTAT = ACT as well.
In addition, all COMPIDs starting '!' are referring to generic, system generated "Queries", so if you fildered those out as well, then the number should be the same as in RSZELTDIR.
KR Frank