SQL Report Field Size

Not planned

Duke Martin

• September 06, 2019 15:24

When using the SQL report function in B1UP, I have noticed that each field is limited to 255 characters.  This is a problem for some of my customers who want to see fields with larger data sizes.  Could you please increase the field size?  Possibly make them varchar(max)?

Vote

1

• 

  SSP Automation

  • September 06, 2019 15:29

  Thank you for your request.
  The development team have now added it to our internal planning-system for evaluation.
  [Internal Id: 29359]
• 

  Rasmus Jensen

  • September 06, 2019 18:39

  Can you explain this is a bit more details because as far as I am aware we do not set such a limit anywhere
• 

  Duke Martin

  • September 09, 2019 14:49

  I believe the long fields, such as the one shown below in the image, that contain more than 255 characters are being truncated.  If I copy/paste the field below into Notepad, it stops at 255 characters.  When I copy/paste into Notepad from the query results from SQL server management studio, the data is not truncated.

  The data from the SQL report shown below is being sent back to a Goods Issue document in SAP.  I tested the GI fields and they allow me to key in more than 255 characters, therefore, it appears that somehow the SQL report function is somehow limiting the field length.

  Am I missing something?

   

  
• 

  Rasmus Jensen

  • September 10, 2019 09:15

  This is unfortunatly a visual limitation of the SAP SDK and not a limitation we have added.

  If you put on System information and inspect the column you can see it is the right length (It is just not showing all the data)

  

  We normally see that SAP right-click Copy give all data back (at least in SAP 9.3)

  

   

  So This is unfortunately not something we can change
• 

  Duke Martin

  • September 11, 2019 13:26

  So is it also a limitation of the SDK when the data in the sql report is transferred back to a goods issue document?  When I transfer the data from the report, the truncated data is sent back to the sap document and not the full string.

   

  Thanks

  Duke
• 

  Duke Martin

  • September 11, 2019 14:37

  I'm ok with a visual limitation as long as the data can be transferred back to the goods issue document

   
• 

  Rasmus Jensen

  • September 11, 2019 15:01
  • Edited

  I've just tried in my SAP 9.3 PL11 with below sample of a 971 char longs string... That was transferred over without any issues (notice the _abc at the end of the text is still there despite visually it can't be seen)

  

   

  Also did a test with a 6773 char long string... Also worked as expected
• 

  Duke Martin

  • September 11, 2019 15:05

  Thanks Rasmus!  Are you able to test this on SAP 9.2?  This is the customer's version and possibly why it does not work for them.

   

  Thanks again for looking into this.
• 

  Rasmus Jensen

  • September 12, 2019 06:06

  I do not have a 9.2 environment at hand so that is a test you will try on your own. In any case how this work is not controlled by us. We just display and read the value of the screen

Please sign in to leave a comment.