How To Fix DD_MT_SHARING080 - Character-like property for key field &1 changed

DD_MT_SHARING080 - Overview

• Message type: E = Error

• Message class: DD_MT_SHARING - DDIC Multi Tenancy Sharing: Messages

• Message number: 080

• Message text: Character-like property for key field &1 changed

What causes this issue?

Definition of datatype for key field was changed after activation of
normalized where condition. The character-like property of new datatype
differs from the old property value and requires a rebuild of the
where-condition because of different value quote usage.

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?

Please start the report DD_MAINTAIN_TABLE_SHARING for table in edit
mode, save and activate the sharing settings without changes. The
datatype properties will be adjusted automatically.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

DD_MT_SHARING080 - Details

• The SAP error message DD_MT_SHARING080 indicates that there has been a change in the character-like property of a key field in a data dictionary object. This typically occurs when the data type of a key field in a table or structure is modified, which can lead to inconsistencies in how the data is accessed or shared across different components of the system.
  
  Cause:
  
  Data Type Change: The most common cause of this error is changing the data type of a key field from a character-like type (e.g., CHAR, VARCHAR) to a non-character type (e.g., INT, DEC) or vice versa.
  Inconsistent Definitions: If the key field is used in multiple places (like in different tables or views), changing its definition in one place without updating it everywhere else can lead to this error.
  Transport Issues: If changes are transported from one system to another (e.g., from development to production) and the key field definitions are