Skip to Content

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

how to download alv to excel but translate char to number ?

i have alv report that the user want to download the

result to excel , ok you have two ways :

1) excel inplace , its work good but in big amount of

data the option is working slow and the user

dont want to use it .

2) download it as local file , the problem is that

the fields that contain the amount is char format

due to using dynamic columnes,

so how can i convert the field that it will be download

to excel as number ?

i tried to change the fieldcatalog to :

LS_FCAT-DATATYPE = 'QUAN'.

LS_FCAT-INTTYPE = 'P' .

but its not help .

thanks .

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