topic Re: Read table logs in Application Development and Automation Discussions

Read table logs

Former Member — Mon, 15 Mar 2010 07:28:07 GMT

HI All

the table USREXTID has the flag log data changes on and I want to identify if some API which

i can use to read this logs from the table ?

Regards

James

Edited by: James Herb on Mar 15, 2010 8:56 AM

Re: Read table logs

Former Member — Mon, 15 Mar 2010 08:02:40 GMT

Hi James,

You can use t-code SCU3.

Best regards,

Samuel

Re: Read table logs

Former Member — Mon, 15 Mar 2010 08:02:55 GMT

Hi,

The USREXTID table is Assignment of External ID to Users.

You can use select querry on this table and you will get cname,cdate and ctimei.e.Modified by,date and time.

Regards,

Pravin

Re: Read table logs

Former Member — Mon, 15 Mar 2010 08:12:27 GMT

The changes are stored on table DBTABPRT please search Log for details! Please find here the details pertaining to the changes in you table. SCU3 would be the correct t-code

Regards

Tatenda

Re: Read table logs

Former Member — Mon, 15 Mar 2010 10:10:15 GMT

There is APi like bapi or FM method that can give this data ?

Regards

James

Re: Read table logs

ThomasZloch — Mon, 15 Mar 2010 10:19:38 GMT

I don't think there is any. Have a look at SCU3 how it's done there.

The table is DBTABLOG by the way, DBTABPRT is not in use any more since a few releases.

Thomas

Re: Read table logs

Former Member — Mon, 15 Mar 2010 10:21:13 GMT

Hi,

You can use FM ME_CHANGEDOC_READ.

Regards,

Narendra

Re: Read table logs

ThomasZloch — Mon, 15 Mar 2010 10:27:52 GMT

> You can use FM ME_CHANGEDOC_READ.

No, this is for reading change documents for purchasing documents from CDHDR/CDPOS, not what the OP wants.

Thomas

Re: Read table logs

Former Member — Mon, 15 Mar 2010 11:15:01 GMT

HI Tomas,

i do some changing on table USREXTID but the table DBTABLOG remain empty,

there is a place which i need to activate something ?

Regards

James

Re: Read table logs

AlexanderOv — Mon, 15 Mar 2010 11:25:13 GMT

Hi,

did you try to see what transaction SCU3 displays? If SCU3 displays changes then logs for tables stored in different table for your release (maybe DBTABPRT).

Re: Read table logs

ThomasZloch — Mon, 15 Mar 2010 11:52:39 GMT

Table logging must be activated for the client (or all clients) in system parameter "rec/client", check in tx RZ11, this can be set by system administrators (also called "basis people")

Thomas

Re: Read table logs

Former Member — Tue, 16 Mar 2010 06:49:53 GMT

HI Thomas

So what you are saying that we have not FM or class which we can use in order to get the table

data like changes on DB records etc..

Regards

James

Re: Read table logs

ThomasZloch — Tue, 16 Mar 2010 10:20:02 GMT

I don't know any such function or method, in the past I used to code the access to DBTABLOG myself.

Thomas

Re: Read table logs

SuhaSaha — Tue, 16 Mar 2010 10:37:30 GMT


> I don't know any such function or method, in the past I used to code the access to DBTABLOG myself.

Why would you do that ? I mean why cant the business use SCU3 trxn, any specific reason ?

Edited by: Suhas Saha on Mar 16, 2010 4:08 PM

Re: Read table logs

ThomasZloch — Tue, 16 Mar 2010 10:41:48 GMT

Yes, one thing is that business users often don't have access to S* transactions, in another case I wanted to integrate the display of table log entries in an application after pressing a button, and with a little less technical appeal to it, and yet another case was to combine CDHDR/CDPOS and DBTABLOG details into one neato report.

Plus, it's really not that difficult, as you know.

Thomas

Re: Read table logs

SuhaSaha — Tue, 16 Mar 2010 10:45:56 GMT


> another case was to combine CDHDR/CDPOS and DBTABLOG details into one neat report.

I was guessing this might be the potential cause