Create unique constraint on table

[Former Member]

Hello experts,

Is it possible to define a unique constraint on table fields that aren't part of the primary key?

Thank you in advance.

[Former Member]

Yes.

Rob

[Former Member]

Thank you Rob, how can i achieve this?

I'm trying to create an aditional constraint that doesn't allow the insertion of a record that fails this constraint.

[Former Member]

Create a unique index on the table.

Rob

[Former Member]

One way is to create an index on the field and make it unique (SE11->GOTO->Indexes). Then in your programs Inserts, Appends and Updates would fail giving you a non zero SY-SUBRC when a program tries to enter a value that already exists.

Don't forget to include MANDT in the index otherwise you'll end up with uniqueness across all clients

[Former Member]

Problem solved! Thank you