Log Table

[Former Member]

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.

[Former Member]

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

[Former Member]

hi Radhika,

You can find the changes that you have made in <b>SCU3</b> Transaction

[Former Member]

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

[Former Member]

Check in table 'DBTABLOG'

[Former Member]

hi,

DBTAB<b>LOG</b> Records the changes not DBTABPRT

[Former Member]

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.

[Former Member]

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 <u>dbtabprt</u>. 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.

[Former Member]

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

[Former Member]

solved