11-19-2007 8:32 AM
Hello Friends,
When ever i down load into excel file the filed 'WERKS' is becoming from '0780' to 780 and when i try to upload i am getting as 780 which is creating some problems. Is there any conversion function module to convert the the field WERKS from 780 to 0780.
Thanks in advance.
Siva Kumar.
11-19-2007 8:38 AM
Hi
U can set the property for the cells in Excel by going to format calls,in that select custom and in type give '0000'.Then ur number ll be displayed as 0780.
Thanks
Vasudha
11-19-2007 8:36 AM
concatenate that field before down load to excell file
.
example 0768.
conacatenate ' into 0768
ans '0768
11-19-2007 8:38 AM
Hi
U can set the property for the cells in Excel by going to format calls,in that select custom and in type give '0000'.Then ur number ll be displayed as 0780.
Thanks
Vasudha
11-20-2007 4:37 AM
Hello Vasudha,
Infact i solved the problem by concatinating '0' to the '780'. But your solution is also helpful.
Thanks and Regards
Siva Kumar.
11-19-2007 8:39 AM
11-19-2007 8:39 AM
hi,
check the FM:
CONVERSION_EXIT_ALPHA_INPUT
CONVERSION_EXIT_ALPHA_OUTPUT
Regards,
Navneeth K.
11-19-2007 8:46 AM
Hi
When you are using FM 'GUI_DOWNLOAD' to download to excel file, you need to populate the parameter FILE TYPE with DBF.
call function 'GUI_DOWNLOAD'
exporting
filename = p_file
<b>filetype = 'DBF'</b>
Thanks
Vijay
PLZ reward points if helpful