Table logging for only one table

[Former Member]

Hi all,

We are on ECC 6.0 and auditors want to on table logging onT000 table only... in all clients in Production..

As i came across snotes # 1916 we cannot enable log for one table...

I have found from DD09l there nearly 28,000 sap defined tables having table logging on if we check the rec/client = on SAP will start logging all tables .

Please suggest is there any approach to do that....

Thanks,

Subhash.G

[Former Member]

Thanks

[Former Member]

Dear Subhash,

I am in same situation as you are now. By default, in my ECC6 I have 28,568 tables with "Log data changes" checked. Turning on the rec/client parameter will start logging on all these tables. I also worried about the performance of my system.

Then someone in SDN mentioned about this note 608835 which explains that those tables checked by default are customizing tables which usually contain a relatively small amount of data which is only changed occasionally, therefore logging should not cause any problems in the production, Customizing and development environments.

I have not activated yet but plan to do so.

Regards,

Kent

[Former Member]

Hi Subash

In your case assigning particular authorization object will solve the problem, the authorization S_ADMI_FCD

u2022 Provides system administration functions including the following:

u2022 TRAC - ABAP/4 trace authorization

u2022 STOP - ABAP/4 program debugging mode

u2022 REPL - Altering values in debugging mode

u2022 KERN - Examine the system kernel from within the ABAP/4 debugger

u2022 CUAD - SE41 GUI Interface maintenance

u2022 DDIC - Data Dictionary maintenance

u2022 TCOD - Transaction code maintenance

u2022 SE01 - Transport system transaction SE01

u2022 FONT - SAPscripts font maintenance

u2022 STOM - Changing system TRACE switches

u2022 STOR - Evaluating traces

u2022 SM21 - Evaluating system logs

u2022 NADM - Network Administration

u2022 Transactions:

u2022 SM54

u2022 SM55

u2022 SM59

u2022 UADM - Update Administration

u2022 Transactions:

u2022 SM13

u2022 T000 - Create a new client

u2022 TLCK - Lock/Unlock Transactions

u2022 SPAD - Authorization for spool administration in all clients

u2022 SPAR - Authorization for client-dependent spool administration

u2022 SP01 - Authorization for administration of spool requests in spool output control (all users and clients)

u2022 SP0R - Authorization for administration of spool requests (all users) in spool output control. Access is limited to spool requests in the current client of the user.

u2022 BTCH - Test environment, batch

u2022 UNIX - Execute UNIX commands from the SAP system with program SAPMSOS0

u2022 RSET - Reset/Delete data without archiving

u2022 SYNC - Reset buffers

Might the above infomation is helpful to u.

Regards

Bhaskar

[Former Member]

Hiu Bhaskar,

Thanks for th reply... but i have not found anything related to my query...

I need to "ON Table Logging " on T000 on in all clinets... not the Authorization level at the ABAP level or the just blocking user from accessing...

Table logging will log all the changes made to that tables if the Logging is On.

Thanks,

Subhash