topic Re: List table changes made by specific user? in Application Development and Automation Discussions

List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 08:53:30 GMT

Hi there,

What is the best way to list all table changes made by a user for a specified time-frame?

I know that either the changes will have to be logged by "log changes" indicator in table technical settings, or logged by change documents.

I would like to explore both to get the most "coverage" - Any help would be appreciated.

I also know that "client/rec" must be set in profile parameters for "log changes" to work.

Are there any SAP standard reports that can do this? I know SCU3 lists changes, but NOT BY USERNAME - I need by username please.

Also is there a SAP standard report to list changes for all activated change documents?

Thanks

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 08:58:21 GMT

Hi ,

Check Tcode STAT and STAD

in STAT check the column DB changes for the user .

Regards,

Vijay

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 09:03:41 GMT

Hi,

You can check the Tables CDHDR and CDPOS for the different changes made by users on each table and field.

Regards,

Anji

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 09:53:25 GMT

Thanks Vijay, but I am already doing this - problem is that it does not tell me what table changes were made - only that there were in fact table changes.

Ideally I need to list values before and after changes...

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 10:46:23 GMT

1)In Cdhdr table, if u give username(USERNAME) & date(UDATE) u wil get OBJECTCLAS,OBJECTID,CHANGENR.

2)iN CDPOS table if u pass there values, u wil get

i)TABNAME (tablename)

ii)FNAME(Fieldname)

iii)VALUE_NEW(New Value)

iv)VALUE_OLD(Old Value)

of that particular field.

Hope it solves ur query.

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 10:46:50 GMT

Check RM_97 transaction...

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 11:26:18 GMT

Thanks vijayalakshmi,

That is helpful - Assuming there is not a SAP standard report to show list of changes for change documents with user and date/time restriction, I will have to use this logic to create my own report.

Next question is about any SAP standard reports or function modules to read changes logged by system where the table is marked to "log changes"...?

Re: List table changes made by specific user?

sreeramkumar_madisetty — Wed, 14 Mar 2007 11:28:59 GMT

Hi David

Check Tables CDHDR (Change document header)

and CDPOS(Change document Item) tables

for the different changes made by users on each table and field.

Regards,

Kumar

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 11:46:44 GMT

Hi David

For SAP standard FM,

changes can be found by using fm

1)changedocument_read_headers,-header level (cdhdr table)

2)changedocument_read_positions-item level(cdpos table)

3)changedocument_read

Hope this wil help u,

Regards,

Viji

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 11:51:09 GMT

refer to this blog ..<a href="/people/erwan.lebrun/blog/2007/03/09/documents-how-to-track-changes-through-abap:///people/erwan.lebrun/blog/2007/03/09/documents-how-to-track-changes-through-abap

regards,

vijay

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 12:09:20 GMT

RE: Check RM_97 transaction...

Rama - Unfortunately I do not have this transaction...

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 12:14:58 GMT

Thank you everyone for all your help - It seems that change documents will be easy to track...

Any suggestions for the logs of changes to tables marked to "log changes" in technical settings..? I think it saves to DBTABLOG - Any function modules or programs I should refer to or use?

Thanks

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 12:53:49 GMT

For anyone reading this later, there is a good program to look at in SAP to read change documents - RSSCD1TS.

Very generic and easy to use.

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 13:15:52 GMT

Hi ,

U can use Transactions CDHDR and CDPOS for this but prior u have to check

The Log data changes .In CDHDR u have to input userid objectid or objectname .

In CDPOS u have to input change number and object id.

Hope will be helpfull for u.

Regards,

Ravi Kumar

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 14:01:42 GMT

Ravi,

CDHDR / CDPOS store change document changes, not logged changes.

Please correct me if I am wrong...

I think changes logged because the table has been marked to "log changes" in technical settings are stored in DBTABLOG - I need away to read this data. This table has a RAW field which I need to be able to interpret..

Re: List table changes made by specific user?

Former Member — Wed, 14 Mar 2007 20:40:34 GMT

if you are going to activate logging - be aware that it's goingot log ALL changes for ALL users for all tables which have "log data changes" selected in technical settings.

You can use RSVTPROT to analyze logs, and you'll need to delete (archive) logs when no longer required otherwise they'll grow really fast.

(check RSTBPDEL for log deletion).

I think it was mentioned already that you can use RSSCD1TS as an example of the report to list changes based on change documents (no logging is required here). change documents are saved in CDHDR/CDPOS.

Re: List table changes made by specific user?

Former Member — Thu, 15 Mar 2007 06:27:35 GMT

Thanks Siarhei - We have had change logging on for a while now in the prod system and we do archive etc...

Report RSVTPROT is called by SCU3 - I need to be able to report by username, date and time for all tables that are logged...

Change documents are not a problem any more.

Re: List table changes made by specific user?

Former Member — Thu, 15 Mar 2007 14:59:51 GMT

David,

check the logic in RSVTPROT around FM DBLOG_READ_WITH_STATISTIC, you'll see how SAP reads logs and formats....besides this FM contains table parameter for usernames ;o) you can try to play with it a bit.

I believe the field LOGDATA of DBTABLOG table contains values of all non-key fields of logged table. So, if you want to parse logdata - you'll need to retrieve dictionary info for logged table & then parse field based on field type/length of non-key fields. (like SAP does it in logs_modernise form.