How To Fix SD_CDS_ENTITY117 - Entitäten m. Zugriffskontrolle müssen Schlüssel deklarieren (s. Langtext)

SAP Error Message - Details

• Message type: E = Error

• Message class: SD_CDS_ENTITY - Messages for STOBS/entities

• Message number: 117

• Message text: Entitäten m. Zugriffskontrolle müssen Schlüssel deklarieren (s. Langtext)

Was verursacht dieses Problem?

CDS entity may be subject to access control but does not declare a key.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Systemantwort

This situation is reported as warning.
The declared key columns may be utilized by CDS access control to
construct an extension to database statements for this entity to
enforce the access control conditions.
When there are no declared key columns, this enforcement is still
possible, but it must then consider all columns of the entity as
necessary to formulate this integration. For entities with many
columns, this might result in large join conditions.
Furthermore, for some types of integration, it requires the usage
of temporary database objects with a DISTINCT property, which is
also an expensive operation.

Wie behebe ich diesen Fehler?

Unless there are comprehensive business reasons which make the
declaration of a key not feasible, specify which columns of the entity
represent a key property of the entity, that is, there are not two
records with the same set of values in those columns. When doing so, you
must ensure that this condition is fulfilled. Specification of a key
column set which does not have the uniqueness property may result in
duplicate records being returned once access control becomes active.
When you use aggregation functions, those duplications might produce
wrong results.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE