title: STRING type or SSTRING element for a text field in table? Pros and cons
body: <p>I need to create a Z table to store reasons for modifications of a certain custom object.</p>
  
  <p>In the UI, the user will pick a reason ID and then optionally fill a text box. The table will have more or less the fields below:</p>
  
  <pre><code>key objectID
  key changeReasonID
      changedOn
      changedBy
      comments
  </code></pre>
  
  <p>My doubt is with the comments field. I read the <a href="https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-us/abenddic_character_byte_types.htm" rel="nofollow noreferrer">documentation</a> about the limitations of STRING and SSTRING, but it's not clear to me if a STRING type field used in a transparent table has a limited length or not.</p>
  
  <p>Even if the length is not limited (at least by the DB), I'm not sure if it's a good idea to use this approach or would you recommend CHAR/SSTRING types with a fix length instead?</p>
  
  <p>**My system is running MSSQL database.</p>