Skip to Content

Excel download truncated characters

Hi,

I have a strange problem. I am trying to download an ALV report in a excel format to the work station and the last character of one of the many fields,Vendor Number, gets truncated. Strangely this problem is confined to quality and production environments, and the same excel download works fine in the development environment.

I have searched for replies in the forum that suggest program corrections but I would like to know how the same report download works correctly in development.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 09, 2011 at 03:43 PM

    Hi,

    The issue is due to fieldcatalog not being populated properly and in the Layout - Column width optimize is checked. In this case the contents are display till the heading ( For ex: if the heading is 'Vendor' ) the conents will be displayed with a maximum length of 6 characters instead of 10 with ".." at the end truncating the output.

    The reason why its working in development and not in Quality or production is that the maximum vendor number in development is less than or equal to 6 digits where as in quality or production its more. Please check.

    Solution: If you are populating the field catalog manuallly, populate the ref_field and ref_table ( For ex: wth 'LIFNR' and 'LFA1' respectively ).

    Edited by: Suman Jagu on May 9, 2011 11:48 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Grame Smith

      Yes, We can pass the reference table name and field name when populating the fieldcatalog manually. The ref_table, ref_field are from LVC field catalog. If you are using SLIS fieldcatalog , REF_FIELDNAME, REF_TABNAME are the field names.

      Can you try passing these to test if it works. You can test this in development itself changing the Vendor value of the first row ( or any row ) to ten digit number and from the output try downloading it.

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.