Skip to Content
-4

What is the purpose for giving 16 primary keys for a table?

Jul 31, 2017 at 12:12 PM

151

avatar image

What is the purpose of giving maximum 16 unique keys for a table?

I am learning abap and my trainer is asking this question.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Richard Harper Aug 01, 2017 at 12:27 PM
2

There is no purpose in giving 16 unique keys to a database table.

There is however a purpose in giving multiple key fields and that is to generate a unique primary key.

Share
10 |10000 characters needed characters left characters exceeded
Horst Keller
Jul 31, 2017 at 12:24 PM
1

As far as I know a database table or an internal table can have only one primary key.

Share
10 |10000 characters needed characters left characters exceeded
VISHVAM MODI Aug 01, 2017 at 11:24 AM
0

So, Maximum how many key fields we can create???

Thank you for you quick reply.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
2

Also Google -> "maximum key fields in transparent table site:sap.com"

I'd suggest to look for a different ABAP school though. Or tell the instructor to stop horsing around and teach you something you'll be able to use on practice instead of random trivia that you can find in the documentation.

0
VISHVAM MODI Aug 01, 2017 at 09:15 AM
-2

This table does have multiple unique keys. So my question is, what is the purpose and maximum how many unique key combinations we can create??


capture.png (68.6 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Nonsense, this table has one primary key with several key fields.

6