Understanding IMG Change Logs and Deleting ACCT* Tables in SAP

SAP users often face issues related to tracking configuration changes and managing space or data within ACCT* tables. This article addresses two common challenges: identifying who made configuration changes and whether ACCT* tables can be deleted, especially when there's a sudden surge in usage.

Problem 1: How Can You Track Configuration Changes in SAP?

In large SAP environments, it's crucial to know who changed what in system configurations. If you're wondering how to find this information, here's the solution:

Use IMG Change Logs

You can track configuration changes via the IMG change log feature. Here’s how:
  1. Navigate to SPRO – Go to the SAP Reference IMG screen.
  2. Select Any Configuration Transaction Code – Choose the area you're interested in.
  3. Follow This Path: Menu > Utilities > Change Log
Important Note:
For this to work, your system must have the change log functionality enabled by the Basis team. If it's disabled (which is the default in many systems), you can enable it via:

Path: IMG > Basis Components > System Administration > Tables Changes Recording

Once this is activated, all changes made within the configuration settings will be logged, making it easier to audit or troubleshoot system issues.

Problem 2: Can Data Be Deleted from ACCT* Tables in SAP?

Understanding the Concern

Recently, there’s been concern over a significant increase in the usage of ACCT* tables, especially in Phase 2 of a multi-phase implementation. The question is whether these tables can be deleted, and what exactly they store.

What Are ACCT* Tables?

The ACCT* tables, including ACCTHD, ACCTIT, and ACCTCR, are integral to SAP's FI/CO interface. These tables store documentation for:
  • Goods Movements
  • Invoice Receipts
  • Financial Transactions related to materials management (MM)

Can You Delete Data from ACCT* Tables?

Generally, you should not delete data from ACCT* tables manually. These tables are automatically populated by the system during certain transactions and serve as a historical record for audit and accounting purposes.

To fully understand these tables and their behavior, SAP recommends referring to:

SAP OSS Note 48009 – "Tables ACCTHD, ACCTIT, ACCTCR: Questions and Answers"
This note offers an in-depth explanation about these tables, their role in posting goods movements and invoice receipts, and best practices for handling them.

Why the Sudden Increase in Phase 2?

The spike in usage could be due to new configuration settings introduced by consultants during Phase 2. These settings might be generating additional financial documents or logging more detailed entries than Phase 1. It's advised to:
  • Recheck new configuration settings.
  • Compare document types and volume in both phases.
  • Consult with the project team or Basis experts to optimize logging levels.

Summary

Issue Solution
Track configuration changes Use SPRO > Utilities > Change Log (Ensure change log recording is enabled)
High usage of ACCT* tables Refer to SAP Note 48009 for table explanations; data should not be manually deleted

FAQs: IMG Change Logs & ACCT* Tables in SAP

1. How do I enable change logs in SAP IMG?

Navigate to: IMG > Basis Components > System Administration > Tables Changes Recording and enable the setting.

2. Are ACCT* tables safe to delete?

No, these tables are critical for financial and audit purposes. Manual deletion is not recommended.

3. What causes increased usage of ACCT* tables?

New configuration settings, especially during implementation phases, can lead to increased logging and document creation.

4. What do ACCTHD, ACCTIT, and ACCTCR tables store?

They record details of FI/CO integration for transactions like goods movement and invoice receipts.

5. Can we reduce the size of ACCT* tables?

You can explore SAP archiving options and consult your Basis team for safe space management practices.

6. Where can I find more information on ACCT* tables?

Check SAP OSS Note 48009 for comprehensive details and guidance.

Defining Storage Location 
One Storage Location for Two Different Plant

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management, Certification and Interview Questions Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.