topic Re: Adding Zero's before material using Functional Module in Application Development and Automation Discussions

Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 15:27:18 GMT

Dear Friends,

Please suggest me how to add zeros before the material using functional module?

i have mateial of length 18 character

now i have material as "MCV23456" which is 8-digit,my requirement is to add addtional zeros before the

material.

INPUT=MCV23456

OUTPUT=0000000000MCV23456.

Please suggest suitable Functional Module

Thanks in advance

Jai

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 15:33:10 GMT

Hello,

Try FM : CONVERSION_EXIT_ALPHA_INPUT

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 15:34:50 GMT

I already tried this FM is used for only mumeric values

Regards

Jai

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 15:36:09 GMT

There are different ways of doing this.. Call the Function Module "CONVERSION_EXIT_ALPHA_INPUT" or user Overlay like this.

DATA: matnr TYPE matnr.
matnr = '12345'.
SHIFT matnr RIGHT deleting TRAILING space.
overlay matnr WITH '000000000000000000'.

Correct the code

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 15:37:39 GMT

MCV23456 which is 8-digit

I see three characters that are not digits...Are you sure you need to do this? Material is an alpha field!

However, if you look at the domain for MATNR, you'll see that there is a conversion routine MATN1...But it doesn't shift and left zero fill...

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 15:39:14 GMT

Hi,

You can try the same function module "CONVERSION_EXIT_ALPHA_INPUT".

If this is only working for numeric values, then declare a temporary variable with type numeric and pass the value to temporary variable and use that in function module.

Regards,

Venkat

Re: Adding Zero's before material using Functional Module

brad_bohn — Wed, 14 Jul 2010 17:34:12 GMT

Come on guys, really? 3 people suggested CONVERSION_EXIT_ALPHA_INPUT for a mixed alpha-numeric field value? I guess BP is the only one paying attention today.

I just have to ask: why would you zero-fill a mixed field anyway?

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 17:37:41 GMT

BP - Barack Petroleum? LOL.... Thanks, though, Brad....

Re: Adding Zero's before material using Functional Module

agustin_cusse — Wed, 14 Jul 2010 20:16:31 GMT

Hi,

You can use CONVERSION_EXIT_MATN1_INPUT.

Every time you need to see what conversion function a field is using go to SE11->Domain (MATNR in this case)->double click on "Convers. Routine". You will get the list of INPUT/OUTPUT FM's used in the conversion for this domain.

Re: Adding Zero's before material using Functional Module

brad_bohn — Wed, 14 Jul 2010 21:04:01 GMT

No, you can't by default...read the question and look at the value. MATN1 does nothing when the value contains alphas unless you force it by implementing BADI BADI_MATN1 or the old style enhancement provided...Configured material templates don't fire for non-numeric values either as far as I know.

You can implement some wacky code in the BADI to get that result though - don't know why you would want to anyway...

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 21:14:48 GMT

Hi,

If you use CONVERSION_EXIT_ALPHA_INPUT for mixed values then the result is going to be material+spaces, using this external to internal converison f.m it adds leading zeros for numeric material only. if the material is going to be mixed value then you can calculate the length of the material and move 18 - length as leading zeros to new 18 character field followed by material.

Regards,

Manjunath

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 21:50:01 GMT


> There are different ways of doing this.. Call the Function Module "CONVERSION_EXIT_ALPHA_INPUT" or user Overlay like this.
> 
> DATA: matnr TYPE matnr.
> matnr = '12345'.
> SHIFT matnr RIGHT deleting TRAILING space.
> overlay matnr WITH '000000000000000000'.
> 
> Correct the code

Ramesh has the answer, but, like Brad I am wondering why you would ever want to do this. Can you enlighten us?

Re: Adding Zero's before material using Functional Module

Former Member — Wed, 14 Jul 2010 21:57:14 GMT

MCV23456 which is 8-digit


> 
> I see three characters that are not digits...Are you sure you need to do this?  Material is an alpha field!
> 
> However, if you look at the domain for MATNR, you'll see that there is a conversion routine MATN1...But it doesn't shift and left zero fill...

Man! you are just too literal. You probably correct people who use o instead of 0 when saying a number. Like 1"o" 4 5 instead of 1 "zero" 4 5. We all know what is meant even though it is not literally correct