Skip to Content
author's profile photo
Former Member

problem with alv to spread sheat ( EXCEL )

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 11:56 AM

    Got the solution

    Add comment
    10|10000 characters needed characters exceeded