Table Maintenance History

[Former Member]

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

[Former Member]

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.

[nabheetscn]

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

[Former Member]

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

[Former Member]

RZ11 - Basis Team -