How To Fix MQ858 - Table &1 is converted using a special program; selection not possible

SAP Error Message - Details

• Message type: E = Error

• Message class: MQ - Messages for Euro Changeover Package

• Message number: 858

• Message text: Table &1 is converted using a special program; selection not possible

What causes this issue?

You have modified a standard SAP table which is converted during the
local currency changeover using a special program. This table is not
allowed to be transferred to the "selection of user-defined
developments".

System Response

This table cannot be flagged as "relevant to conversion".

How to fix this error?

Contact SAP to adapt the special program or to have it adapted.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MQ858 - Table &1 is converted using a special program; selection not possible ?

  The SAP error message MQ858 indicates that a specific table (denoted as &1 in the message) is being converted using a special program, which prevents selection operations on that table. This typically occurs during database migrations, upgrades, or when a table is undergoing structural changes.
  Cause:
  
  Table Conversion: The table is in the process of being converted to a new format or structure, which is often part of a system upgrade or data migration.
  Locking Mechanism: During the conversion process, the table is locked to prevent any read or write operations that could lead to data inconsistencies.
  Special Program Execution: A specific program or transaction is running that is responsible for the conversion, and it has exclusive access to the table.
  
  Solution:
  
  Wait for Completion: The simplest solution is to wait until the conversion process is completed. Once the program finishes, the table will be available for selection again.
  Check Background Jobs: Use transaction codes like SM37 to check for any background jobs that might be running the conversion program. If you have access, you can monitor the job status.
  Consult with Basis Team: If the conversion process seems to be taking an unusually long time, consult with your SAP Basis team. They can provide insights into the status of the conversion and whether any issues have arisen.
  Review Logs: Check the system logs for any errors or warnings related to the conversion process. This can help identify if there are underlying issues that need to be addressed.
  Avoid Manual Interventions: Do not attempt to manually intervene or modify the table while it is being converted, as this can lead to data corruption or further errors.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as SE11 (Data Dictionary), SM37 (Job Monitoring), and SM21 (System Log).
  SAP Notes: Check SAP Notes for any known issues or additional guidance related to the specific table or conversion process.
  Documentation: Review SAP documentation regarding table conversions and upgrades for best practices and troubleshooting steps.
  
  If the issue persists after the conversion is expected to be complete, further investigation may be necessary to identify any underlying problems with the database or the specific table in question.