Conversion function module

[Former Member]

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.

[Former Member]

concatenate that field before down load to excell file

.

example 0768.

conacatenate ' into 0768

ans '0768

[Former Member]

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

[Former Member]

Hello Vasudha,

Infact i solved the problem by concatinating '0' to the '780'. But your solution is also helpful.

Thanks and Regards

Siva Kumar.

[former_member188829]

CONVERSION_EXIT_ALPHA_INPUT

AND

CONVERSION_EXIT_ALPHA_OUTPUT

[Former Member]

hi,

check the FM:

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

Regards,

Navneeth K.

[Former Member]

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