cancel
Showing results for 
Search instead for 
Did you mean: 

Table logging

Former Member
0 Kudos

Hi All,

this is regarding table logging. table logging is activated in our system. but the requirement is i have to only stop table logging of long texts and that too for particular business areas like MM, PP, FI etc.

Any help please.

thanks,

Anil

Accepted Solutions (1)

Accepted Solutions (1)

LeonardoAraujo
Active Contributor
0 Kudos

Why do you need that?

table logging is mainly turned on for config tables so there is no advantage doing it.

Are you doing it for performance reasons?

Please explain more.

Leonardo

Former Member
0 Kudos

Hi Leonardo,

you r right. its for performance reasons. the requirement says that the logging of Long texts is not required for all the modules. the logging of long texts should only be done on few modules like MM,FI etc.

please let me know how can i full fill his requirement.

thanks and regards,

Anil

LeonardoAraujo
Active Contributor
0 Kudos

Table logging is a functionality SAP provides to automatically track changes on tables set as "LOG DATA CHANGES".

By default SAP delivers mainly config tables set like that since the main reason was to enable automatic logging of config changes.

The functionality could indeed harm your system performance but , as per OSS note 608835, you should not have problems since only config tables are set to be logged...

"Generally, you can activate logging in your system without any problems because SAP only delivers Customizing tables with activated logging. Customizing tables usually contain a relatively small amount of data which is only changed occasionally.

To be more precise: Basically all Customizing tables are delivered with activated logging because the requirements of external auditors are inconsistent as regards the logging of tables.

Tables for master and transaction data, on the other hand, are delivered by SAP without logging indicators. A large number of these tables are subject to mass changes which would cause performance problems if they were logged. You should use great caution if you want to log any of these tables.

Practice has shown that, bearing the above restrictions in mind, logging does not cause any problems in the production, Customizing and development environments.

If performance or memory problems occur unexpectedly, you can easily determine which table causes the problems:

Select the "Administration --> Number of logs (selective)" menu option (Shift+F8) in transaction scu3. Enter a time interval in the selection screen displayed and leave the table selection empty. If you now start the report, it returns a list of all logged tables with the number of recorded logs. You can then deactivate the logging of the tables most frequently logged in transaction SE13.

As described above, SAP delivers all Customizing tables with activated logging. Due to the relatively low number of changes in Customizing, it is not useful to remove the logging indicator from all tables except a selected few, especially since the requirements for the logging of pages may be changed by your external auditor from time to time."

If you want to monitor changes in application tables, you need to rely on aplication change objects. Ex: for table MARA, we don't have it set to auto changes, yet, we have the log of changes through standard change objects, programmed within the standard MM02, MM01... transactions.

Leonardo De Araujo

Answers (0)