Read table logs

[Former Member]

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

[Former Member]

Hi James,

You can use t-code SCU3.

Best regards,

Samuel

[Former Member]

Hi

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

Regards

James

[ThomasZloch]

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

[Former Member]

Hi,

You can use FM ME_CHANGEDOC_READ.

Regards,

Narendra

[ThomasZloch]

> 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

[Former Member]

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

[AlexanderOv]

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).

[ThomasZloch]

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

[Former Member]

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

[ThomasZloch]

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

Thomas

[SuhaSaha]

>

> 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

[ThomasZloch]

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

[SuhaSaha]

>

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

I was guessing this might be the potential cause

[Former Member]

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

[Former Member]

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