topic Re: 'conversion_exit_alpha_input' in Application Development and Automation Discussions

'conversion_exit_alpha_input'

Former Member — Tue, 24 Oct 2006 10:26:57 GMT

Hi All,

What is the function of 'conversion_exit_alpha_input'

FM? How it will be used?

Thanks,

GovindarajanUmadevi.

Re: 'conversion_exit_alpha_input'

roberto_tagliento — Tue, 24 Oct 2006 10:28:48 GMT

CONVERSION_EXIT_ALPHA_INPUT - converts any number into a string fill with zeroes-right

example:

input = 123

output = 0000000000000...000000000000123

CONVERSION_EXIT_ALPHA_OUTPUT - converts any number with zeroes-right into a simple integer

example:

input = 00000000000123

output = 123

Re: 'conversion_exit_alpha_input'

Former Member — Tue, 24 Oct 2006 10:29:17 GMT

Hi Uma,

It si well documented.

Check this:

Conversion exit ALPHA, external->internal

ALPHA conversion is used especially with account numbers. During conversion from the external to the internal format, the system checks to see if input in the INPUT field is purely numeric, that is, if this input consists only of numbers, possibly with spaces before and after them. If this is the case, then the number string is inserted right- justified in the display field OUTPUT and all spaces to the left of the value are filled with zeroes ('0'). If the input is not purely numeric, it is inserted in the display field from left to right and all extra spaces are filled with blanks.

Example:

(Input field and output field are both eight characters in length)

1. '1234 ' --> '00001234'

2. 'ABCD ' --> 'ABCD '

3. ' 1234 ' --> '00001234'

Conversion from the internal to the external format (function module CONVERSION_EXIT_ALPHA_OUTPUT) is undertaken in exactly the opposite manner.

Usage:

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = v_input

importing

output = v_output

exceptions

others = 1.

Regards,

ravi

Message was edited by: Ravi Kanth Talagana

Re: 'conversion_exit_alpha_input'

FredericGirod — Tue, 24 Oct 2006 10:29:52 GMT

This is used for field conversion to allow user to enter a number without preceding 0. This function will put 0 at the begining of the field to set in numeric format.

Fred

Re: 'conversion_exit_alpha_input'

Former Member — Tue, 24 Oct 2006 10:29:59 GMT

This is an conversion FM. Used mainly when dealing with select queries.

Because what appears on screen is not the way it is stored in databases. There will be a conversion routine.

So if we are reading directly from tables, we have to use the conversion exits.

Generally these are provided with the data element defintion you are dealing with.

regards,

Sandeep Josyula

*Mark Helpful answers

Re: 'conversion_exit_alpha_input'

venkata_ramisetti — Tue, 24 Oct 2006 10:32:37 GMT

Hi,

For some data in SAP, there is an internal format and external format.

If you check MATERIAL number, if you display value it shoows in external format(that is removing leading zeros).

For converting internal to external/external to internal we use conversion_exit_alpha_input/conversion_exit_alpha_output

Eg:

Assume before function call v_matnr = 1000.

call function 'conversion_exit_alpha_input'

exporting

input = v_matnr

importing

outout = v_matnr.

after function call v_matnr = 000000000000001000

Re: 'conversion_exit_alpha_input'

roberto_tagliento — Tue, 24 Oct 2006 10:33:56 GMT

Govindarajan Umadevi

By the way:

help yourself.

use trn 'se37'. or doubel-click on this fm.

you can find a document.

*************

FU CONVERSION_EXIT_ALPHA_INPUT

____________________________________________________

Short Text

Conversion exit ALPHA, external->internal

Example:

(Input field and output field are both eight characters in length)

1. '1234 ' --> '00001234'

2. 'ABCD ' --> 'ABCD '

3. ' 1234 ' --> '00001234'

Conversion from the internal to the external format (function module CONVERSION_EXIT_ALPHA_OUTPUT) is undertaken in exactly the opposite manner.

Parameters

INPUT

OUTPUT

Re: 'conversion_exit_alpha_input'

Former Member — Tue, 24 Oct 2006 10:37:26 GMT

Hi,

Here the Docu of the FM:

FU CONVERSION_EXIT_ALPHA_INPUT

____________________________________________________

Short text

Conversion exit ALPHA, external->internal

Example:

(Input field and output field are both eight characters in length)

1. '1234 ' --> '00001234'

2. 'ABCD ' --> 'ABCD '

3. ' 1234 ' --> '00001234'

Conversion from the internal to the external format (function module CONVERSION_EXIT_ALPHA_OUTPUT) is undertaken in exactly the opposite manner.

Parameter

INPUT

OUTPUT

Exceptions

Function group

ALFA

short example:

<b>REPORT ZGRO_TEST. .

DATA: c1(18) value '123'.

DATA: c2(18).

write: / c1.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = C1

IMPORTING

OUTPUT = C2.

write: / c2.</b>

Hope it helps.

regards, Dieter

Re: 'conversion_exit_alpha_input'

Former Member — Fri, 03 Nov 2006 09:38:31 GMT

Hi all,

We will upload data from ascii files to BW system.

In the txt files we have amount field .Amount field length is 17 in the BW system.To upload data in the ascii format we have to use fixed lenght data in the txt files.But in the txt file amount field is not fixed,stable ,also containd decimal places, for example 4500,58.

How can we fix its size to 17.

We know there is a function CONVERSION_EXIT_ALPHA_INPUT but we can not be able to use it for amount key figure.

Does anyone solve such a problem like this?

Thanks for your help.

Re: 'conversion_exit_alpha_input'

Former Member — Fri, 03 Nov 2006 10:18:43 GMT

USE OF CONVERSION_EXIT_ALPHA_INPUT IS TO CONVERT EXTERNAL FORMAT OF FIELD VALUE TO INTERNAL FORMAT i.e. HOW IT STORES IN DATABASE.

EX : WHEN WE GENERATE ON REPORT ON SALES ORDERS,

SYSTEM DISPLAYS 'SO' NUMBERS WITH SUPPRESSING ZEROS.

LIKE 2345 OR 45632 ETC

BUT ACTUALLY 'SO' NUMBER LENGTH IS 10 CHARACTER.

TO CONVERT 2345 TO 0000002345 WE USE CONVERSION_EXIT_ALPHA_INPUT.