As you may already know SAP keeps track of table content changes if you switch on ‘Log Data Changes’ option in table technical settings. Here you can see how to activate this small but effective checkbox for database tables.

log_data_changes

[su_tooltip style=”dark” content=”standard table”]DBTABLOG [/su_tooltip] is the main object to hold log changes for all logged database tables. However the records are kept in raw format in LOGDATA field. Therefore you have to make some conversion so that you can obtain the tables’ fields. Another very important field in DBTABLOG is OPTYPE which represent operation type applied to the table record. For OPTYPE field domain values are: ‘D’ which means Delete, ‘I’ which means Insert, whereas ‘U’ means Update.
In the light of this information i have written an ABAP program to extract update logs of a selected table in the determined period. You could adjust this program with many variations.

 

[su_divider]

You may also like

  • generate HTML output from SMARTFORM and send it as email body (0)
    There was a standard process in our system which sends a text as the body of a mail, after a certain operation is completed. For this program a change had been done so that the program […]
  • read another ALV report’s output into internal table (0)
    Because nobody wants to change another report but wants to use the reports output in his program , how to get output table of an ABAP report is a frequently asked question for ABAP'ers.
  • monitoring sap work processes (0)
    Monitoring SAP work processes is done by a few transactions which are confused very often. To call the work process overview for the current application server (local work process […]