topic Re: Table properties host in Application Development and Automation Discussions

Table properties host

Former Member — Wed, 13 Sep 2006 22:31:58 GMT

Hey people,

Is there any table which hosts all the table properties ? I need to know when a particular table is created/modified and by whom, etc. (In particular I need to know the modifications to the Virsa rule set table - /virsa/functobj)

Thanks

Prashanth

Re: Table properties host

Frank_Buchholz — Mon, 18 Sep 2006 08:02:34 GMT

Hi Prashanth,

1. How to track changes to table definitions?

Repository Infosystem

Transaction SE84 -> ABAP Dictionary -> Data base tables

Enter selection for table name (e.g. /virsa/*) and a date range for "last changed" )

Then you can double-click and use the menu function Utilities -> Versions to view the changes.

(I do not recommend to develop own programs reading the table definitions directly.)

2. How to track changes to table content?

SAP uses different options to track changes of table content (e.g. change documents or table logs).

I do not know which opion Virsa is using. However, to check the settings of table logging you can use transaction SE13 for table /virsa/functobj and view the setting "Log data changes". If set (customers are allowed to set this flag, too), you can use transaction SCU3 (=report RSTBHIST) to view the log.

Kind regards

Frank Buchholz

Re: Table properties host

Former Member — Thu, 21 Sep 2006 21:24:42 GMT

Thank you so much Frank, We were wondering how do we effectively track all our Virsa CC Rule set & FF table changes.This should be it. Thanks again