Skip to Content
author's profile photo Former Member
Former Member

Maximum number of columns in IT

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!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 09, 2009 at 07:14 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2009 at 07:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2009 at 07:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.