while exporting report output to excel few field last digit value getting truncated ?pls help

[Former Member]

iam using export to local file option from output of the report(spreadsheet),download done successful but few fields last digit getting truncated

eg: my pono actual value is 0123456789 it displayed as this in report but after downloading into excel ,excel contains only 012345678

pls help

note : defaultly i have given its type as in table

[jogeswararao_kavala]

Hi Suriya,

Confirm that you've increased the cell width (in excel) and confirmed that the last digit was not hiding.

IF it is, you need to remove any custom specifications given to that cell in excel.

Jogeswara Rao K

[Former Member]

i have increased cell width also still value truncated

[former_member188827]

Is your output in ALV grid format? If yes, check the outputlen defined in fieldcatalog and try increasing it.

Regards

[Former Member]

i have increased output length and in excel still it is truncated

[former_member188827]

Try passing refernece table and reference field in fieldcatalog as well.

Regards

[Former Member]

truncated fields are sale order number(vbelv),customer(kunnr)

[former_member188827]

Please pass

ref_tablename = 'VBAK'.

ref_fieldname = 'VBELN'.

ref_tablename = 'KNA1'.

ref_fieldname = 'KUNNR'.

in fieldcatalog and check if this works.

Regards

[Former Member]

Hi Venkatesan,

Please let us know if your problem has rectified.

If rectified what is the solution.

Regards,

Sudheer Kumar Chunduru.

[praveenboss]

Hy Suriya,

Please Check  the value in debuging time.

If value come exact as u need then problem is on excel sheet.

then check that data type  and make sure  no  formula or function assign on that particular location of excel.

Tell Me What you got .

Thanks 

[Former Member]

my problem solved....

actually in output fields header text is so.no i changed it to sale order number

now values exported correctly as i expected same i did for customer

[former_member188827]

Great!!

[Former Member]

Change  S.no to Sales Order Number