Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ALV download to excel problem

Dear Gurus a problem in alv report downloading to excel:

on executing the report works fine but when downloading to excel there last digit of bpvno is getting truncated.

ex: actual bpvno:'4000010' but excel o/p shows as '400001'

I have declared a field in final internal table as:

data: bpvno as bseg-belnr,


(in field catalog)

fieldcatalog-fieldname = 'BPVNO'.

fieldcatalog-seltext_m = 'BPV No.'.

fieldcatalog-seltext_L = 'BPV No.'.

fieldcatalog-col_pos = I1.

fieldcatalog-emphasize = 'X'.

append fieldcatalog .

clear fieldcatalog.

I1 = I1 + 1.

but after specifying the REF_TABLENAME & REF_FIELDNAME the downloaded excel o/p is correct.

My questions is:

1) i want to know what all are mandatory fields to be specified in fieldcatalog & is it compulsory to specify REF_TABLENAME & REF_FIELDNAME .

if not complusory why the downloaded excel value is being truncated ???

plz dont send materilas on alv and answer specific to the question....

Former Member
Not what you were looking for? View more on this topic or Ask a question