Skip to Content
avatar image
Former Member

Re: Table Maintenance History

Guys,

We have generated table maintenance view for a custom table.

Say for example a user changes a record, the chaged record is available in existing custom table.

How to get the old record, I mean how to maintain history for this maintenance view.

Is there any standard settings available.

Say if somebody changes a record i want the record to be stored in the custom table with changed by whom and changed on date.

Also if somebody deltes the record i want that record to be stored in the table with flag set to X.

How can we achieve this in table maintenance view.

Also for users when they login using SM30 i have to list them only the recent records, not the old records.

Regards,

Anand

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 01:30 AM

    Guys,

    I have heard something about table history using tcode SUC3.

    I did the settings in table under technical settings, checked the Log data changes.

    I come to know that we also need to maintain system parameter rec/client.

    But can anyone tell me where and how to maintain this parameter? I tried to do it in RZ10, but i could not find any parameter like rec/client.

    Pls help me in maintaining this parameter.

    Regards,

    anand

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 20, 2010 at 07:24 PM

    1) you can add two more fields say UNAME and DATE in table and populate in the table maintenance events

    for details on event check [this|http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=93454609]

    2) SCU3 is standard tcode to log the changes for any table, no need to have maintenance generator here.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2010 at 09:51 PM

    Hi,

    There are two internal table TOTAL and EXTRACT which holds the data.

    You can compare those fields in EVENTS at save. You can validate/check the old plus new data there.

    Hope it helps

    Regards

    Nabheet

    Add comment
    10|10000 characters needed characters exceeded