ALV

[Former Member]

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

[Former Member]

Hello,

WA_FIELDCAT-no_convext = 'X'.

REward the points and close the thread.

Regards,

Vasanth

[Former Member]

Hi,

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

Regards,

Shashank

[Former Member]

Extend the width of the column in the excel file.

-Kiran

*Please reward useful answers

[Former Member]

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>

[Former Member]

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.

[Former Member]

hi,

increase the breadth of that column, it will work

Regards,

Joginder Saini