Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Maximum number of columns in IT

Former Member

‎09-09-2009 8:10 AM

0 Kudos

Hi, i'm working with an infotype table with 340 cols and i need to add a lot more of them (about 200) so i was wondering about the maximum number of columns that an infotype (or a simple) table can support...

Thank you in advance.

Best regards

Filippo

ps. i'm sorry if i put this thread in the wrong subforum, i never posted here before...my apologizes!

3 REPLIES 3

former_member188827
Active Contributor

‎09-09-2009 8:14 AM

0 Kudos

just one constraint:

be aware that SAP gives a total space of 2000 characters for all fields in an infotype. In other words, we can't increase the fields in an infotype if the sum of length of all fields in the infotype increases 2000 characters.

Former Member

‎09-09-2009 8:16 AM

0 Kudos

Hi,

The maximum number of columns a SAP DB table can hold is 1024. Not sure if thats the same for a infotype though. I think it must be the same for infotype too.

Regards,

Vikranth

Former Member

‎09-09-2009 8:23 AM

0 Kudos

Thank you so much for your answers, i was surfing the net searching for answers like these! Thanks!

So, for a DB table i can reach 1024 cols, but for an IT Table i need to 'count' the lenghts of all field ?

21fields of 100 chars each would go over the limit and the system will not let me add another field to the PS table ?

Edited by: Filippo Piazza on Sep 9, 2009 9:23 AM