RSZCOMPDIR-LASTUSED not matching BW Statistics

[axel_]

Hi Folks,

I build an ABAP report to identify not used WAD templates by looking at the RSZCOMPDIR-LASTUSED field of underlying queries.

During spot check I noticed that LASTUSED and query statistics are not matching.

I got a query that shows statistics only 10 years ago but nothing recently.

But when looking at RSZCOMPDIR-LASTUSED it show a timestamp of last year.

So what is now correct?

Personally I trust statistics... especially in this case as the query is very old and I am pretty sure no longer used.

Anybody any insights on that situation?

Best regards,

Axel

[FCI]

Hi Axel,

When the query is transported, the LASTUSED field value comes with the query. It is the last used timestamp of the query on the origin system.

Thus you can have a unused query on the production with a last used timestamp filled (coming from the dev system).

Regards,

Frederic