Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Primary key in table exists 2 times - how is that possible?

Floatjitsu
Explorer
0 Kudos

Hi experts,

could you explain me this:

The values of username are exactly the same, and my primary key consits only the 3 columns, this should not work, apparently it does - but why and how? Is there anything I can do to solve this?

Best regards

3 REPLIES 3

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

What kind of table are you talking about?

Show the definition of the table.

For a standard and sorted internal table the primary key can be non-unique, for a hashed internal table and a database table it can't. And that's that (and what you could also learn from the documentation).

0 Kudos

Horst,

" For a standard and sorted internal table the primary key can be non-unique, for a hashed internal table and a database table it can't. "

Read many threads regarding Standard/Sorted/Hashed tables but the above line helped me in understanding the concept much better.Thanks.

K.Kiran.

raymond_giuseppi
Active Contributor
0 Kudos

Also it's not because there is no difference for human eyes that it is internally true: non displayable characters or conversion-exit can fool the eye...