How To Fix ACM056 - Keyfield &1 of entity &2 is of DCL-forbidden type: String/XString

SAP Error Message - Details

• Message type: E = Error

• Message class: ACM - Message-Class for all ACM functions/exceptions

• Message number: 056

• Message text: Keyfield &1 of entity &2 is of DCL-forbidden type: String/XString

What causes this issue?

A field of type "String" or "XString" was marked as KEY.
No DCL roles/rules can be created for entities which have key fields of
LOB types "String" or "XString".

System Response

The DCL cannot be activated/generated

How to fix this error?

Change the structure of the CDS entity, so that no key field has a LOB
type ("String" or "XString"), otherwise this CDS entity cannot be access
protected via a DCL role.

Procedure for System Administrators

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 ACM056 - Keyfield &1 of entity &2 is of DCL-forbidden type: String/XString ?

  The SAP error message ACM056 indicates that there is an issue with a key field in a data model entity that is of a type that is not allowed for Data Control Language (DCL) operations. Specifically, it mentions that the key field is of type String or XString, which are types that are forbidden for DCL operations in certain contexts.
  Cause:
  
  Key Field Type: The key field in the entity is defined as a String or XString. In SAP, certain operations, especially those related to authorization and data access control, require key fields to be of a type that can be used in DCL statements. String and XString types are not suitable for this purpose.
  Entity Definition: The entity might have been defined incorrectly in the data model, leading to the use of an unsupported key field type.
  
  Solution:
  
  Change Key Field Type: Modify the key field in the entity definition to use a supported type, such as Integer, UUID, or other types that are allowed for DCL operations. This may involve changing the data model and ensuring that the data integrity is maintained.
  Review Entity Design: Review the overall design of the entity to ensure that it adheres to best practices and guidelines for key field definitions in SAP.
  Update DCL Configuration: If the entity is already in use, you may need to update any associated DCL configurations to reflect the changes made to the key field type.
  
  Related Information:
  
  DCL (Data Control Language): DCL is used in SAP to manage access control and authorization for data models. It is important to ensure that key fields are of the correct type to avoid issues with DCL operations.
  SAP Documentation: Refer to the official SAP documentation for guidelines on defining entities and key fields, as well as best practices for DCL usage.
  Testing: After making changes, thoroughly test the entity and any associated DCL configurations to ensure that the changes have resolved the issue and that the system behaves as expected.
  
  If you continue to experience issues after making these changes, consider reaching out to SAP support or consulting with a technical expert familiar with your specific SAP environment.