Skip to Content

Automated Table Audit

1            Purpose

This document will give the step of configuring customs table maintenance screen to have automated Created Date, Created By, Changed Date, Changed By.

Created Date, Created By, Changed Date, Changed By will be automatically entered when a new record is done through the maintenance screen.

Changed Date, Changed By will be automatically changed when a record has been changed.


2      Step by step guide

  1. Create the table with following fields included: ERNAM, ERDAT, AENAM, AEDAT and the data element should have the same name as the field name.
  2. In SE11 Table dictionary, go to Utilities > Table Maintenance Generator
  3. If you have not already generated the maintenance dialog for the table, generate one before next step.
  4. Go to Environment > Modification > Maintenance Screens
  5. Select the screen number you have generated
  6. Click on the Element List tab and uncheck inputs for ERNAM,ERDAT,AENAM,AEDAT. Be sure to Activate
  7. Go back to the maintenance generator screen. Now go to Environment > Modification > Maintenance Screens
  8. Add new entry to the table with
    Event : 18
    Form name : set_changeauditdate
  9. Hit Enter once, then click on the editor button beside the routine we have just added
  10. They will prompt you to create a subroutine.  Hit yes to proceed.

  1. Put in this code. In the newly created include.
    INCLUDE /pstech/bce_tablechangeaudit.

3     Result

Field Created by, Created On, Changed by, Changed on will be greyed out.

  1. Creating data: after hitting save & back:
  2. After saving on a different day, it will not change the data on screen instantly, but the back end will change it automatically. The result will be this when we refresh the view.
1 Comment
You must be Logged on to comment or reply to a post.
  • Hi,

    I’ve been trying to find the include below, but no such luck…
    Would you please be so kind to make this include available, or the provide the code for this include?

    INCLUDE /pstech/bce_tablechangeaudit.

    Thanks in advance!