cancel
Showing results for 
Search instead for 
Did you mean: 

Index column limit of 16

Former Member
0 Kudos

Hello,

We are running SAP R/3 Enterprise 4.7 on an Oracle 9.2.0.7.0 database and have an issue with a limit on a table index of 16 fields. The Oracle version has a limit of 32 but the SAP application doesn't allow more than 16.

Has anyone else encountered this problem and, if so, have you found a way around it or just lived with the restriction?

Thanks,

Paul.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Lars,

Thanks for your suggestion, I'll put it to our developers and see what they think. What we have found is that some of the table/index fields are not actually used and were incorporated some time ago so we have removed an unused field and added the new field that we need. This has resolved our issue for now.....

Regards,

Paul.

lbreddemann
Active Contributor
0 Kudos

Hi Paul,

it's always important for index design to follow the priciple of having as few columns in the index as absolutely necessary.

Every additional column more will increase dataload and data handling times.

KR Lars

lbreddemann
Active Contributor
0 Kudos

Hi Paul,

since the ABAP/4 Dictionary is designed to db independend, there are several occurences where you cannot use up the options of the underlying db to the fullest.

Leaving aside for a moment that a 16 field secondary index is rather big you might use a workaround here.

Define a smaller index in SE11 but do create the index as you like it on the DB via sqlplus. That way you cannot transport the index but the DB02 DB check will find the index from the ABAP/4 DDIC on the DB.

Before you create that kind of index you really should doublecheck if this index is what your application really needs. Keep in mind that there is a considerable amount of work to be done to maintain such a big index and that it will allocate much space as well.

KR Lars

former_member204746
Active Contributor
0 Kudos

an index with more than 16 fields!

with so many fields, an index might not be helpful...