topic Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' in Application Development and Automation Discussions

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Fri, 14 Aug 2009 08:11:13 GMT

Hello All,

Is SHIFT v_variable LEFT DELETING LEADING '0' better than CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'.

Please reply with reasons.

Thanks,

Nitu Kumari

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Fri, 14 Aug 2009 11:23:21 GMT

Hi,

There is certainly a significant performance difference - of course that will only be meaningful with mass processing

I ran a test with 1 million iterations using input field '000000012345':

- SHIFT LEFT: 160 ms average

- call function: 1950 ms average

Rgds,

Mark

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

ThomasZloch — Fri, 14 Aug 2009 12:44:27 GMT

It's not better or worse, it's different. Try v_variable = '000ABCDE'.

Thomas

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Fri, 14 Aug 2009 13:23:57 GMT

The important thing is that the logic is different in both, so which to use depends on your specific requirements. If I know the string will only contain numerics, I generally avoid the exit. (But then I have gotten in trouble when the string suddenly contained alphas.)

Rob

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Fri, 14 Aug 2009 14:16:50 GMT

Nitu,

Calling a function module would have a greater cost performance vise, however you are splitting hairs here. The difference will not be tangible unless you are processing a huge number of records. Ideally when you process such a large volume of records (so as to have a tangible difference) you would be doing it in a background processing run not in the foreground because it could time out.

It does not really matter. Take your pick. The function module gives you the convenience of re-using a tried and tested logic. Re-inventing the wheel would cost you more in terms of time.

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Mon, 17 Aug 2009 11:58:04 GMT

Hello Nitu,

Output will be same and code written inside will be similar. The additional thing in calling Function module is time taking. so SHIFT LEFT DELETING is suggestable

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Tue, 18 Aug 2009 09:14:25 GMT

Hi Nitu,

Try executing the below code, you can see the difference,

ATA: V_VAR TYPE CHAR20.

V_VAR = '001234'.

SHIFT v_var LEFT DELETING LEADING '0'.

WRITE:/ 'NUMERIC:SHIFT', V_VAR.

V_VAR = '001234'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = V_VAR

IMPORTING

OUTPUT = V_VAR

WRITE:/ 'NUMERIC:EXIT', V_VAR.

V_VAR = '00ABCD'.

SHIFT v_var LEFT DELETING LEADING '0'.

WRITE:/ 'CHAR:SHIFT', V_VAR.

V_VAR = '00ABCD'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = V_VAR

IMPORTING

OUTPUT = V_VAR

WRITE:/ 'CHAR:EXIT', V_VAR.

I suggest to remove the 0s manually with 'SHIFT' instead of EXIT.

Rgds,

Sripal

Re: CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

Former Member — Mon, 31 Aug 2009 13:44:42 GMT


> Hello Nitu,
> 
>        Output will be same and code written inside will be similar. The additional thing in calling Function module is time taking. so SHIFT LEFT DELETING is suggestable

That's incorrect. Try doing both with '12345678' and '1234ABCD'.

Rob