topic Re: Conversion function module in Application Development and Automation Discussions

Conversion function module

Former Member — Mon, 19 Nov 2007 08:32:47 GMT

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.

Re: Conversion function module

Former Member — Mon, 19 Nov 2007 08:36:47 GMT

concatenate that field before down load to excell file

example 0768.

conacatenate ' into 0768

ans '0768

Re: Conversion function module

Former Member — Mon, 19 Nov 2007 08:38:45 GMT

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

Re: Conversion function module

former_member188829 — Mon, 19 Nov 2007 08:39:02 GMT

CONVERSION_EXIT_ALPHA_INPUT

AND

CONVERSION_EXIT_ALPHA_OUTPUT

Re: Conversion function module

Former Member — Mon, 19 Nov 2007 08:39:10 GMT

hi,

check the FM:

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

Regards,

Navneeth K.

Re: Conversion function module

Former Member — Mon, 19 Nov 2007 08:46:22 GMT

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

Re: Conversion function module

Former Member — Tue, 20 Nov 2007 04:37:16 GMT

Hello Vasudha,

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

Thanks and Regards

Siva Kumar.