how to increase the number of columns in the database table

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

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

Check if you can do the same....

Regards,

Kunjal

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi nishant,

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

regards

Rahul Sharma

[Former Member]

hi nishant,

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

regards

Rahul Sharma

[Former Member]

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

[Former Member]

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.