topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Thu, 06 Jul 2006 10:47:27 GMT

hi Friends,

i had defined the below way for one field in fieldcatalog

WA_FIELDCAT-REF_FIELDNAME = 'STCD1'.

WA_FIELDCAT-FIELDNAME = 'STCD1'.

WA_FIELDCAT-REF_TABNAME = 'LFA1'.

WA_FIELDCAT-COL_POS = '6'.

WA_FIELDCAT-OUTPUTLEN = '16'.

WA_FIELDCAT-SELTEXT_L = TEXT-009.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

its value in output is showing correct as 91437466646 , but when downloaded to excel its showing like 9.14E10

any suggestions

Re: ALV

Former Member — Thu, 06 Jul 2006 10:49:53 GMT

Hello,

WA_FIELDCAT-no_convext = 'X'.

REward the points and close the thread.

Regards,

Vasanth

Re: ALV

Former Member — Thu, 06 Jul 2006 10:50:34 GMT

Hi,

Try changing the datatype of the field to charecter and then download.

Regards,

Shashank

Re: ALV

Former Member — Thu, 06 Jul 2006 10:51:28 GMT

Extend the width of the column in the excel file.

-Kiran

*Please reward useful answers

Re: ALV

Former Member — Thu, 06 Jul 2006 10:54:35 GMT

Hi <b>Chandrasekher</b>,

I donno whether this would be helpful to u or not...

But, I think the SAP converts the integer to packed nos and which are displayed as <n>E<x>.

So may be u can convert them to text, but then they wont be available for calculation in excel...

Else fix the no of integer using <variable>(I10)..

Regards,

<b>Abhishek</b>

Re: ALV

Former Member — Thu, 06 Jul 2006 11:24:47 GMT

1.In SAP the text u are dispalying sd be of Text type.

If it is integer then it will automatically change into packed mode.

In excell u can double click the column to see the number.

Re: ALV

Former Member — Thu, 06 Jul 2006 11:54:29 GMT

hi,

increase the breadth of that column, it will work

Regards,

Joginder Saini