Skip to Content
avatar image
Former Member

Creation of key field in a database table

Hi All,

As per my requirement, i have to add few new key fields in an existing table.

Now total number of key fields are 17, but while saving this is giving me an syntax error stating 'According to SAA standard key fields cannot be more that 16'.

I s there any other go? i can not reduce the number of key fields.

Regards,

Pankaj.

Edited by: Pankaj Bist on Sep 5, 2008 3:24 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 05, 2008 at 10:29 AM

    Hi,

    In the se11 transaction,In the menu bar o like this.

    Utilites-->Database Utility and the Press the button Activate and Adjust Database.

    Note:

    Make sure that you total data in the table to be downloaded into ur system.

    As ctivate and Adjust Database makes data to be deleted.

    Regards,

    Rama.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 12:10 PM

    hi,

    use tcode se14 for alter the database table.

    regards,

    Sanket

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 12:17 PM

    In a table max key fields is 16 so you can have key fields more than 16 that's why its erroring out . Best possible way combine two fields and make it in one.

    Add comment
    10|10000 characters needed characters exceeded