Skip to Content
avatar image
Former Member

how to increase the number of columns in the database table

hi guys,

i want my database table to have 120 columns

but the system is allowing only 80 if my length of each column is 50,

if i decrease the length of each column to 40 its allowing 100 columns but i want the length to be 50 .

how can i have 120 columns of length 50.

thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • avatar image
    Former Member
    Sep 02, 2008 at 08:51 AM

    Hi

    U can create a new table with the rest of fields.

    So 80 fields will be in the old table and 40 fields in the new one

    Max

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:51 AM

    Hi,

    If possible, create 2 tables using, samilar or same key fields....

    Check if you can do the same....

    Regards,

    Kunjal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:52 AM

    talk to your basis guys, thats no ABAP belonging. ABAP is capable of this just the databse seems to have some problems.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:53 AM

    Hi,

    you better make two table with same key field and let each of the table contain logicaly related non-key fields.

    This will reduce complexity but the data integrety will remain same.

    Regards,

    Anirban

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2008 at 08:56 AM

    Hi Nishant,

    Create the 80 fields with the 50 lenth, and remaining try to use an include and check.

    Let me know if had resolved your issue, this is for my further reference.

    Thanks & Regards,

    M.Ramana Murthy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 10:07 AM

    hi nishant,

    its better if u can make 2 tables , using similar or same key fields....

    regards

    Rahul Sharma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 10:08 AM

    hi nishant,

    its better if u can make 2 tables , using similar or same key fields....

    regards

    Rahul Sharma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 10:17 AM

    Use include to include more columns and you can append any length for 120 columns ... It wil solve your problem. You can use as many includes as possible.

    vinod

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 10:47 AM

    Use include to add columns and you can extend the length for 120 columns. You can use as many includes as possible.

    If its not possible then u create 2 tables with same key fields.

    Add comment
    10|10000 characters needed characters exceeded