SQL Report Field Size

Not planned

Comments

9 comments

  • Avatar
    SSP Automation
    Thank you for your request.
    The development team have now added it to our internal planning-system for evaluation.
    [Internal Id: 29359]
    Comment actions Permalink
  • Avatar
    Rasmus Jensen

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

    Comment actions Permalink
  • Avatar
    Duke Martin

    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?

     

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    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

    Comment actions Permalink
  • Avatar
    Duke Martin

    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

    Comment actions Permalink
  • Avatar
    Duke Martin

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

     

    Comment actions Permalink
  • Avatar
    Rasmus Jensen (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

    Comment actions Permalink
  • Avatar
    Duke Martin

    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.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    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

    Comment actions Permalink

Please sign in to leave a comment.