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

This article shows you how to view the content of the SAP ABAP database table field of type LRAW, which is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

It is mentioned in the SAP help document that when a buffered database table is modified, its buffer is automatically updated, including the buffer for that table on other application server instances is also automatically updated asynchronously.

Records that have been modified in the Buffer table are written to a central log table, DDLOG. The asynchronous update of Buffer is implemented by the application server periodically checking to see if there are new records in the table.

Out of curiosity, I wanted to see what the DDLOG record looked like in SE16, and found that the type of notebook field was LRAW:

To do the test, I chose a buffer table, CRMC_PROC_TYPE, and wrote some data into it:

Then SE16, unable to find the record I just inserted, recorded it somewhere in this table:

Of course I can use SELECT * to read all the data, including notebook fields, into the table in ABAP, but I don't know how to parse fields of type LRAW, so it's useless to read them.

There is an old saying in our country: where poisonous snakes are infested, there must be an antidote within seven steps. Similarly, the data stored in the DDLOG table is of no value if there is no corresponding read API.

So if you where used list the DDLOG, you must find the API that reads the table.

Sure enough, I found some useful functions and classes:

Some operations and tools related to this DDLOG database table:

ABAP database table buffer synchronization monitoring tool RSDBBUF3

Function for parsing DDLOG-NOTEBOOK field: SBUF_SEL_DDLOG_RECS

The usage is as follows:

DATA: lt_sync_tab TYPE sync_tab_t, lv_tstamp_from TYPE ddlog-timestamp Lv_tstamp_to TYPE ddlog-timestamp.lv_tstamp_from = '20160621061955'.lv_tstamp_to =' 20160623000000'.CALL FUNCTION 'SBUF_SEL_DDLOG_RECS' EXPORTING from_time = lv_tstamp_from to_time = lv_tstamp_to max_cnt = 10000 keep_db2_tstmp =' X' CHANGING sync_tab = lt_sync_tab.SORT lt_sync_tab BY tabname.

Using this function, you can find the records that were automatically written to the table DDLOG after I modified the database table CRMC_PROC_TYPE.

The above content is how to view the contents of the SAP ABAP database table field of type LRAW. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to 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.