How To Fix AC109 - Maximum of 8 columns allowed

SAP Error Message - Details

• Message type: E = Error

• Message class: AC - Error messages from Asset Customizing

• Message number: 109

• Message text: Maximum of 8 columns allowed

What causes this issue?

You want to create an asset history sheet version with more than 8
columns. This is not possible for technical reasons.

System Response

It is not possible to create an additional column.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message AC109 - Maximum of 8 columns allowed ?

  The SAP error message AC109, which states "Maximum of 8 columns allowed," typically occurs in the context of Asset Accounting (FI-AA) when you are trying to create or modify a report or layout that exceeds the allowed number of columns.
  Cause:
  The error is triggered when a user attempts to create a report or layout in Asset Accounting that includes more than 8 columns. This limitation is set by the system to ensure performance and usability, as having too many columns can make reports difficult to read and manage.
  Solution:
  To resolve the AC109 error, you can take the following steps:
  
  
  Reduce the Number of Columns: Review the report or layout you are trying to create and reduce the number of columns to 8 or fewer. This may involve removing less critical data or combining information into fewer columns.
  
  
  Use Sub-reports: If you need to display more information, consider breaking the report into multiple sub-reports or sections, each with its own set of up to 8 columns.
  
  
  Customize the Layout: If you are using a standard layout, you may need to customize it to fit within the column limit. This can often be done through the layout configuration options in SAP.
  
  
  Consult Documentation: Check SAP documentation or help resources for specific guidelines on creating reports in Asset Accounting, as they may provide additional insights or best practices.
  
  
  Seek Help from SAP Support: If you are unable to resolve the issue on your own, consider reaching out to your SAP support team or consulting SAP Notes for any updates or patches that may address this limitation.
  
  
  Related Information:
  
  Transaction Codes: The error may occur in various transaction codes related to Asset Accounting, such as AS01 (Create Asset), AS02 (Change Asset), or when generating reports like S_ALR_87011990 (Asset History Sheet).
  SAP Notes: Check for any relevant SAP Notes that may provide additional context or solutions for this error.
  User Training: Ensure that users creating reports are trained on the limitations and best practices for report design in SAP.
  
  By following these steps, you should be able to address the AC109 error and successfully create or modify your report in SAP Asset Accounting.