topic Re: Leading Zeros Problem in Application Development and Automation Discussions

Leading Zeros Problem

Former Member — Wed, 09 Apr 2008 07:25:39 GMT

Hi all,

I'm using this statement:

CONCATENATE matdescr pa_matnr 'from' vendorname pa_lifnr

INTO v_head SEPARATED BY space.

TRANSLATE v_head TO UPPER CASE.

but the problem is that I'm getting the matnr with zeros '000000000000055501' and the lifnr as ' 0000300205'.

Is there a way I can show the material no. and vendor without leading zeros. I tried to use NO-ZEROS but did not work.

Re: Leading Zeros Problem

Former Member — Wed, 09 Apr 2008 07:28:02 GMT

HI,

see this code.


data:abc(10) value '0000123'.
WRITE:/ abc.
SHIFT abc LEFT DELETING LEADING '0'.
write:/ abc.

rgds,

bharat.

Re: Leading Zeros Problem

Former Member — Wed, 09 Apr 2008 07:30:18 GMT

Hi Shaheen

Use FM 'CONVERSION_EXIT_ALPHA_OUTPUT'

This FM will remove leading zeroes,

Rewards if useful

Regards,

Talwinder

Re: Leading Zeros Problem

Former Member — Wed, 09 Apr 2008 07:33:14 GMT

Hi Shaheen,

You can use the FM " Conversion_exit_alpha_output".

This will truncate the leading zeros.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

input = pa_matnr

IMPORTING

output = pa_matnr.

Use this for concatenation.

Regards,

Chitra

Re: Leading Zeros Problem

Sm1tje — Wed, 09 Apr 2008 07:33:18 GMT

For these kind of problems use the conversion exit routines. You can find them by going to the data type of the material (or whatever for that matter), than double click on domain. In one of the tabs of the domain you will find at the bottom the field EXIT (or conversion, not sure). Double click this field and you will be navigated to the conversion FM (input and output conversion routines). Use these for deleting and adding zeros.

Re: Leading Zeros Problem

Former Member — Wed, 09 Apr 2008 07:38:43 GMT

Hi,

Use this FM,

CONVERSION_EXIT_CCMAT_INPUT Function Module for Material Number Conversion (INPUT)

CONVERSION_EXIT_CCMAT_OUTPUT Function Module for Material Number Conversion (OUTPUT)

Regards,

sathish