topic Re: Create unique constraint on table in Application Development and Automation Discussions

Create unique constraint on table

Former Member — Wed, 18 Jan 2012 19:14:05 GMT

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.

Re: Create unique constraint on table

Former Member — Wed, 18 Jan 2012 19:17:37 GMT

Yes.

Rob

Re: Create unique constraint on table

Former Member — Wed, 18 Jan 2012 19:21:57 GMT

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.

Re: Create unique constraint on table

Former Member — Wed, 18 Jan 2012 19:23:19 GMT

Create a unique index on the table.

Rob

Re: Create unique constraint on table

Former Member — Thu, 19 Jan 2012 07:05:13 GMT

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

Re: Create unique constraint on table

Former Member — Thu, 19 Jan 2012 09:45:53 GMT

Problem solved! Thank you