System table to identify BEx Query?

[Former Member]

We have request to provide report on Query Change info, for example. This data is available when manually going into each query, however we need to see this in a single view, rather than opening every query via BEx Query Designer.

We need the following:

Query Name

Last Changed Date

Time

User

Need to know system tables to browse or other way to provide this info. Have found <u>some</u> data in RSZ tables, however date/time is unreadable.

[Former Member]

Try table RSRREPDIR.

[Former Member]

I tried this table, however the user id's shown are ens users and do not have query developer/change rights. This table must have last user who executed it and not the developer who made change.

[Former Member]

Hi Mike,

I think you might have used table RSZCOMPDIR where

field COMPID for query technical name,

and field LASTUSED is the last "timestamp" query executed.

So you have to convert this timestamp(YYYYMMDDhhmmss) to time and date.

For that Use a FM ADDR_CONVERT_TIMESTAMP_TO_DATE.

Or

Another option is a little bit of code:

data: l_tmstp(30) type c,

l_date type sydatum,

l_time type syuzeit.

write <timestamp field> to l_tmstp left-justified decimals 0 no grouping.

l_date = l_tmstp(8).

l_time = l_tmstp+8(6).

Regards,

San!