Update of Statistic table RSBKDTPSTAT?

[Former Member]

Hello all

I´d like to built a query, which will show me in the first step all inactive DTPs and in the next step all inactive IPs, too.

I found a table named RSBKDTPSTAT. There is a field named OBJSTAT, that will give me the needed information for DTPs.

Does anybody know, how often the table will be updated? How can I change the time interval?

Thanks for your help!

Kind Regards

Joerg Stompe

[Former Member · Accepted solution]

Hi,

not sure whether it's still relevant for you but as it is an system table it should be updated at each change of a DTP. Even a change to an infoprovider or an transformation might update the table as a DTP might become inactive. So this information sould always be up to date.

But take care: it might be that some DTPs are listed in RSBKDTPSTAT but are not in the RSBKDTP at all. So for a complete list of inactive DTPs join both tables.

Best regards,

Florian

P.S.: assing points if this answer was useful for you