This blog provides detailed explanation on disabling of table logging for all tables in Sap system with standard procedure as below.
This procedure is applicable as of SAP_BASIS 740and following releases for SAP Products based on NetWeaver and S4Hana .
If we decide to deactivate logging of all tables, it takes too much effort to handle the task manually.
First need to implement note 2341818, so that the reports ZSLA_CREATE_DATAFILE_LOGGING_1, ZSLA_SE13_06_AS_OF_740 are in place.
After implementation of above note, need to proceed with below procedure.
1.Run report ZSLA_CREATE_DATAFILE_LOGGING_1 in transaction SE38
If you want to process all rows at once, do not change the default value 60.000.
In case you want to split the processing into several parts, enter PACKSIZE 10.000 or 5.000 for example.
Reducing the PACKSIZE can be necessary, if time frame for batch input processing is too small. Batch Input Processing of all rows at once, takes about 3 hours.
2. Run report ZSLA_SE13_06_AS_OF_740 in transaction SE38
Tick radio-button Generate Session
Enter any session name in field Session name, here for example I gave as name- Disable Log
Enter TABLES_WITH_PROTOKOL_x in field DATASET (x represents the sequential number of the file: 1,2,n) Execute the report with icon Execute
If the list of transactions is displayed proceed with next step.
3. Start transaction SM35 Select the session with the Session name you entered above.
Press button Process In screen Process Session choose radio-button Background in frame Processing Mode Press button Process Now you can monitor the process in transaction SM37.
Once the job has status Finished, this task is done.
Repeat step 1 and 2 one after the other for all files TABLES_WITH_PROTOKOL_1, TABLES_WITH_PROTOKOL_2, TABLES_WITH_PROTOKOL_n,
Select session and Click process
Click Process button and you can monitor the process in transaction SM37
Now go back to tcode - SM35 and check the session log
From above screenshot, it shows 11,562 table entries disabled, 146 entries need to be updated either manually or by repeating above procedure of step 1 and 2 .
If we want to perform changes manually , follow below procedure
Start transaction SE13
Enter the object within field Table/view name
Press button Change
Confirm the information Make repairs in foreign namespaces only if they are urgent
Untag flag Log data changes
Press icon Activate
In order to find the list of these 146 tables, go to SE38 and give program name – RSTBHIST and click List Of Logged Tables button as shown below.
While changing the table manually ,sometimes you may face issues like it gives a popup -Objects are locked in particular transport , in that case need to release the transport and again try to change it manually it works.
Note: Always make sure for the table T000, table logging should not be disabled.
(T000 is fundamental table and maintain SAP system clients in SAP system, so it should always be protected in productive system)