topic Re: Log Table in Application Development and Automation Discussions

Log Table

Former Member — Tue, 23 May 2006 08:45:21 GMT

Hi,

I read somewhere that the changes whatever we will make to the table will be stored in a table called DBTABPRT.

I have one Z table in that i checked the log data changes check box, then i made some changes to the z table. These changes shud be stored in the table DBTABPRT right?? but iam not able to see any records in that table.

Not only my Z table data, I did not find any data in that table.

Can any one clarify this.

Thanks

Radhika.

Re: Log Table

Former Member — Tue, 23 May 2006 08:47:50 GMT

Logging only takes place if parameter rec/client in the system profile

is set correctly. Setting the flag on its own does not cause the table

changes to be logged.

The existing logs can be displayed with Transaction Table history

(SCU3).

Message was edited by: Vijay

Re: Log Table

Former Member — Tue, 23 May 2006 08:49:11 GMT

hi Radhika,

You can find the changes that you have made in SCU3 Transaction

Re: Log Table

Former Member — Tue, 23 May 2006 09:13:38 GMT

Iam able to see the changes in the transaction SCU3.

But i would like to know how it could be in the table DBTABPRT.

Thanks for ur response.

Thanks,

Radhika

Re: Log Table

Former Member — Tue, 23 May 2006 09:20:08 GMT

Check in table 'DBTABLOG'

Re: Log Table

Former Member — Tue, 23 May 2006 09:25:33 GMT

hi,

DBTABLOG Records the changes not DBTABPRT

Re: Log Table

Former Member — Tue, 23 May 2006 09:35:32 GMT

When i tried using the table DBTABLOG.

Iam getting a message saying field is too wide to display even though i have selected only one field LOGDATA and i made the output lenght 9999.

Re: Log Table

Former Member — Tue, 23 May 2006 09:43:53 GMT

In 21 days it is given DBTABPRT only. So only i mentioned it.

For each insert, update, or delete to a table enabled for automatic table history, a record is created in table dbtabprt. Each record is called a change document. Each change document contains the date and time of the change, the userid of the user who made the change, the transaction code and program name used to make the change, and the type of change performed. The type of change will be INS if the record was inserted, UPD if the record was updated, or DEL if the record was deleted.

Thanks for ur response.

Reward points are given.

Re: Log Table

Former Member — Tue, 23 May 2006 09:45:45 GMT

Rather than following 21 days, go for help.sap.com

Re: Log Table

Former Member — Thu, 06 Oct 2011 17:58:09 GMT

solved