Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

problem with alv to spread sheat ( EXCEL )

Former Member

‎08-28-2007 5:20 AM

0 Kudos

Hello all ,

I am getting the correct out in ALV out put but when i down load to spread sheat using ( cntrl + shift + F9 ) i am getting out put like this for the below two fields

The field catelog is like this ..

lfl_fieldcat-col_pos = l_pos.

lfl_fieldcat-fieldname = 'MEINS'.

lfl_fieldcat-seltext_l = 'UOM BOM component materai '.

lfl_fieldcat-outputlen = '3'.

APPEND lfl_fieldcat TO lit_fieldcat.

CLEAR lfl_fieldcat.

l_pos = l_pos + 1.

lfl_fieldcat-col_pos = l_pos.

lfl_fieldcat-fieldname = 'MEINSCOM'.

lfl_fieldcat-seltext_l = 'UOM of Bom qantity '.

lfl_fieldcat-outputlen = '3'.

APPEND lfl_fieldcat TO lit_fieldcat.

CLEAR lfl_fieldcat.

l_pos = l_pos + 1.

OUT PUT IN ALV :

UOM BOM component materai | UOM of Bom qantity

ST | PU

ST | PU

KG | KG

KG | KG

OUT PUT IN SPREAD SHEET ( EXCEL )

UOM BOM component materai | UOM of Bom qantity

PU | ******

PU |******

KG |KG

KG |KG

Can any one please let me know why i am getting ***** in excel sheet . ?

Thank and regards

Prem

2 REPLIES 2

Former Member

‎05-05-2011 12:56 PM

0 Kudos

Got the solution

former_member184119
Active Contributor
In response to Former Member

‎05-05-2011 1:24 PM

0 Kudos

Kindly post what solution you got. Might be excel you havenot expanded much it seems.

sas