In SAP_BASIS 7.40 Data Dictionary is now supporting table´s field name up to 30 bytes length. In the past this value was only 16 bytes.

This modifications is being delivered in note 1680583 ( Field names for tables and views with more than 16 char ).

From development perspective this is really nice to have this flexibility to create objects where you can include more details about business meaning as part of field name. For sure this is helpful for new projects once the restriction now is up to 30 bytes per field.

So far this is possible to be used in SAP_BASIS 7.02, 7.31 and 7.40

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Paul Hardy

    This may seem trivial, but it is more useful than one might think. The longer the allowed names in SAP, the more like English the program reads, the so called “literate programming” paradigm.

    The next step is method names and variables that can be longer than 30 characters, as is the case in languages like Java.

    (0) 
  2. Paul Hardy

    Oh well, I just implemented this OSS note into my 7.02 SAP system.

    I was sort of hoping the field in SE11 where you create a custom table would have got longer, but no, it is still 16 characters.

    The note changes a check function module so that if you created a table that was longer than 16 characters long you would not get an error. If you could create a table which was longer than 16 characters. But you can’t.

    So the question I would ask is – what in the world is the point of this OSS note?

    Or does the note behave differently in your system? You must have implemented the note before posting a blog about it.

    (0) 
    1. Carlos Machado Post author

      Hi Paul

      Thank you for your inputs.

      In fact I tested this note in my 7.02 system (SP 07 ) and it worked as expected.

      After implement this note you need to restart SE11 transaction using /nSE11 to force system to reload all static attributes.

      (0) 
  3. Yuvaraj Shanmugam

    Well, I always thought that Data Elements served the purpose of providing the Business Semantics to a table field and Domains convey the Technical Attributes.

    I also think that this change has been brought up to be in sync with the table and column name limits of underlying database. (Oracle and DB2 has column name limit of 30 Bytes).

    (0) 
  4. Jens Knappik

    Hi Carlos,

    thanks for sharing this usefully hint.

    if you will tell me next that the 30 byte restriction of other repository object  will be fixed and that objekts in packages receive a package bound namespace you make my day !!! 🙂

    regards,

    Jens

    (0) 

Leave a Reply