How To Fix TR_AUSL621 - Table has object function 'M' (delete and recreate on database)

SAP Error Message - Details

• Message type: E = Error

• Message class: TR_AUSL - Software Delivery Composer Messages

• Message number: 621

• Message text: Table has object function 'M' (delete and recreate on database)

What causes this issue?

The table has the object function 'M' in the delivery request (delete
and recreate in the database). The import behavior may differ from the
required import behavior since there is a risk that data is deleted
unintentionally. When the delivery request is imported, the table is
deleted in the database of the target system and created again. This
deletes all entries that exist in the table.

System Response

The system displays a message with two entries. The first entry contains
the action <LS>Remove from Request </>for the table with the object
function 'M'; the second entry contains the action <LS>Add to Request</>
for the table without an object function assigned.

How to fix this error?

Check whether this is the required import behavior.
If you do not want the table to be deleted and recreated at import, you
can correct the entry by selecting both entries for the table and
choosing <LS>Correct Entries</>. It is important that you perform these
two actions in the right order (first remove, then add). You can
guarantee this by selecting both the entries for the table and choosing
<LS>Correct Entries</>.

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message TR_AUSL621 - Table has object function 'M' (delete and recreate on database) ?

  The SAP error message TR_AUSL621 indicates that there is an issue with a database table that has an object function 'M', which typically means that the table is marked for deletion or has been corrupted in some way. This error often arises during transport operations or when trying to access or modify the table in question.
  Cause:
  
  Corruption: The table may have become corrupted due to an incomplete transport or an error during a database operation.
  Inconsistent State: The table might be in an inconsistent state, possibly due to changes made directly in the database that are not reflected in the SAP data dictionary.
  Transport Issues: If the table was part of a transport request that failed or was not properly imported, it could lead to this error.
  
  Solution:
  To resolve the TR_AUSL621 error, you typically need to delete and recreate the table in the database. Here are the steps to do this:
  
  
  Backup Data: Before making any changes, ensure that you have a backup of the data in the table if it contains important information.
  
  
  Delete the Table:
  
  Use transaction code SE11 (Data Dictionary) to locate the table.
  Check the table structure and ensure that it is safe to delete.
  Use the option to delete the table. This may involve using the database tools or commands to drop the table.
  
  
  
  Recreate the Table:
  
  After deletion, recreate the table using the same structure as before. You can do this by using the Data Dictionary (SE11) to define the table again.
  Ensure that all necessary fields, keys, and indexes are defined correctly.
  
  
  
  Transport the Changes: If this table is part of a transport request, ensure that the changes are included in the transport and that the transport is successfully imported into the target system.
  
  
  Check for Consistency: After recreating the table, check for consistency in the database and ensure that there are no further errors.
  
  
  Test the Functionality: Once the table is recreated, test the functionality that was previously causing the error to ensure that the issue is resolved.
  
  
  Related Information:
  
  Transaction Codes: SE11 (Data Dictionary), SE14 (Database Utility), SE03 (Transport Organizer Tools).
  Database Tools: Depending on your database (e.g., HANA, Oracle, SQL Server), you may need to use specific database commands to drop and recreate tables.
  SAP Notes: Check SAP Notes for any specific guidance or patches related to this error message, as there may be updates or fixes provided by SAP.
  
  If you are unsure about any of these steps or if the table contains critical data, it is advisable to consult with your SAP Basis team or a database administrator before proceeding.