Shulou(Shulou.com)06/01 Report--

This article is about the ABAP work process on the database table reading operation detection is how, the editor feels very practical, so share with you to learn, I hope you can get something after reading this article, say no more, follow the editor to have a look.

What the editor wants to introduce is a trick to use SM50 to detect the behavior of a worker process reading a database table for a long time. The SM50 interface has a column called "Current Action Info" that displays the name of the database table if the current worker process is continuously reading a database table when SM50 is started.

For example, the figure above shows the work process numbered 9743, the current status is Running, client 00000 as the system user SAPSYS, execute the ABAP system program SAPMSSY2, read the database table TBTCO.

I once used this little skill to complete a task in practical work.

While I was still working on SAP CRM standard development, I needed to find all the ABAP classes that listened for NEW_FOCUS events thrown by the class CL_BSP_WD_COLLECTION_WRAPPER.

So I used the Where-Used List function in ABAP workbench and waited for 5 minutes and still got the result. I performed the Where-Used List operation as a background job again, perhaps because the total number of ABAP classes to be retrieved was so large that ten minutes later there was still no result.

So I changed my way, opened SE80's Repository Information System, and searched according to the following criteria:

However, this filter only shows which classes are published, not listening for NEW_FOCUS events.

So I opened SM50 and saw at a glance that the current process was stuck in the quagmire of reading VSEOCOMPDF.

This is a database view:

The association between the ABAP class and its publication events is maintained in the database table SEOCOMPODF. I searched in SE16 according to the following filter criteria:

I got the list I wanted in less than a second:

If this example uses the seven weapons of SAP error message debugging in my previous article: to enable all error messages to be located by one of the tools mentioned in, that is, to use ST05 to track which tables are accessed during Where-Used List execution, the result will be a long list. The Current Action Info of SM50 can avoid all the interference information and quickly and accurately find out the storage table that stores the relationship between the ABAP class and its listening events.

ABAP developers have a lot of tools available, how to flexibly choose the most appropriate tools to solve problems in different situations, we need to continue to practice and improve.

This is how the ABAP process detects the read operation of the database table. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.