topic Re: Add leading zero to matnr in a conversion program in Application Development and Automation Discussions

Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 18:32:26 GMT

Hi All,

When uploading matnr from a text legacy file , should i add leading zeroes to the sku value. For ex the data from the lagacy is 1000123456 (10 digits length). The values are always numbers. The matnr in SAP is 18 chars. Should my program transform it into 000000001000123456 before saving it into mara-matnr?

Regards, Oli

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 18:34:27 GMT

Hi,

You can use this FM CONVERSION_EXIT_ALPHA_INPUT to add leading zeros.


...

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    INPUT  = WA_MATNR
  IMPORTING
    OUTPUT = WA_MATNR.

...

Regards,

Ferry Lianto

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 18:35:29 GMT

Hi Oli,

Yes, it will implicitly use conversion exits for your values but prior to this you need to these values to the exact table field.

Otherwise, Use conversion exits before passing these values to a conversion program

<b>CONVERSION_EXIT_ALPHA_INPUT</b> is used to convert from external to internal format.

Thanks,

Vinay

Re: Add leading zero to matnr in a conversion program

RichHeilman — Fri, 26 Jan 2007 18:36:25 GMT

Yes, you should convert it, you can use the function module CONVERSION_EXIT_MATN1_INPUT.

Regards,

Rich Heilman

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 18:50:54 GMT

Thanks a lot to all of you for your prompt answer.

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 18:59:13 GMT

There's another, admittedly dirty(!) way of doing it -

SHIFT MATNR RIGHT DELETING TRAILING SPACE.

OVERLAY MATNR WITH '000000000000000000' ONLY SPACE.

Re: Add leading zero to matnr in a conversion program

RichHeilman — Fri, 26 Jan 2007 19:01:24 GMT

Lets keep going, how many DIFFERENT ways to accomplish this.

Here's another....

data: c(18) type c value '12345'.
data: n(18) type n.

n = c.
c = n.

Regards,

Rich Heilman

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 19:19:08 GMT

HI Oli bumchi...

as simply u can use UNPACK statement...

data matnr like mara-matnr.

matnr = '12345'.

Unpack matnr to matnr.

Regards

SAB

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 20:02:07 GMT

Are you sure that in configuration, the Indicator for lexicographical material numbers is unchecked? If it checked, then SAP will not then the all numeric material numbers will not get leading zeros by default. =====>

Indicator for lexicographical material numbers

Defines the way numeric material numbers are stored in the database.

Use

Caution

It is only possible to set or reset (cancel) this indicator if no numeric material numbers have been used yet in the system since they would no longer be interpretable after setting or resetting this indicator.

If this indicator is not set, numeric material numbers are padded with leading zeros and stored right-justified

Re: Add leading zero to matnr in a conversion program

Former Member — Fri, 26 Jan 2007 20:21:10 GMT

Hi Oli,

use Funciton Module 'CONVERSION_EXIT_ALPHA_INPUT'


CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    INPUT  = input_value
  IMPORTING
    OUTPUT = output_value.

Re: Add leading zero to matnr in a conversion program

Former Member — Tue, 06 May 2014 13:32:48 GMT

i am facing similar issue... my matnr is not getting printed in alv... i appended extra zeros in front then it came... my question is matnr has implicit conversion right? so what is the need of expicit conversion function module...