How To Fix GH072 - Check your table extensions for effects on performance

GH072 - Overview

• Message type: E = Error

• Message class: GH - Help functions and tools in FI-SL

• Message number: 072

• Message text: Check your table extensions for effects on performance

What causes this issue?

You have added &V1& &V2& new fields to the customer include.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Every field that you add as a customer add-on can can worsen your
system performance. This is especially true of fields that normally
have a high number of different versions in the system (e.g. orders,
WBS elements and so on). The volume of data in your database tables is
significantly increased through the inclusion of such fields. Longer
program run times and poorer performance in general are the result.
Check whether you really require all the fields that you have included
in the Flexible General Ledger. For performance reasons you should not
use any more fields than you absolutely require.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message GH072 - Check your table extensions for effects on performance ?

  The SAP error message GH072, which states "Check your table extensions for effects on performance," typically indicates that there may be performance issues related to the way table extensions are implemented in your SAP system. This message is often encountered during the execution of certain transactions or reports that involve database operations.
  
  Cause:
  
  Table Extensions: The error is usually triggered when there are custom extensions or modifications to standard SAP tables. These extensions can lead to performance degradation if not implemented correctly.
  Database Design: Poorly designed database structures, such as excessive joins or poorly indexed tables, can also contribute to performance issues.
  Data Volume: Large volumes of data in extended tables can slow down query performance, especially if the queries are not optimized.
  Inefficient Queries: If the queries accessing the extended tables are not optimized, they can lead to longer execution times.
  
  
  Solution:
  
  Review Table Extensions: Analyze the custom extensions made to the tables. Ensure that they