export problem from alv output to excel sheet

[Former Member]

Hi,

we have sales doument no with length 10 characters in alv output but after exporting into excel sheet some digits are missing.

for example in alve output contains: 0010100326 after exporting into excel it shows 1010032 , if you observe that lase digit(from left to right) 6 was missed. plz give sol regarding this.

Regads

Ganesh

Moderator message: duplicate post locked.

Edited by: Thomas Zloch on Apr 8, 2011 10:35 AM

[Former Member]

Hi,

we have sales doument no with length 10 characters in alv output but after exporting into excel sheet some digits are missing.

for example in alve output contains: 0010100326 after exporting into excel it shows 1010032 , if you observe that lase digit(from left to right) 6 was missed. plz give sol regarding this.

Regads

Ganesh

Moderator message: duplicate post locked.

Edited by: Thomas Zloch on Apr 8, 2011 10:35 AM

[Former Member]

It is a common problem. Suppose fieldname = 'VENDOR' , vendor no exceeds 6 characters ( VENDOR is a 6 letter word ). Export it to excel it will display only 6 characters, but if you change the name to 'VENDOR_NAME( 11 letter word, more than LIFNR = 10CHAR) and then export to excel, the correct value gets exported. This is a bug in SAP system. Using this technique I have managed to extract correct data to excel.

Regards

DPM

[huseyindereli]

Hi ,

Fill your FCAT fields below for your columns and try again.

For example;

gs_fcat-DATATYPE = 'CHAR'.
gs_fcat-INTTYPE = 'C'.
gs_fcat-INTLEN = 10.