topic Re: Convert material number in Application Development and Automation Discussions

Convert material number

Former Member — Tue, 17 Mar 2009 13:01:02 GMT

Hi,

Is there any SAP pre-defined function module to convert material number,

example: from 000000000000000085 to 85

example: from 000000000000000087 to 87

Thanks.

Tee

Re: Convert material number

Former Member — Tue, 17 Mar 2009 13:25:12 GMT

Hi Lee,

Use Conversion_exit_alpha_output to remove the zeros from the number.

Please search your query before posting the question..as there are lot of posts on the same

Thanks & Regards

Syed

Re: Convert material number

marcelo_ramos1 — Tue, 17 Mar 2009 13:34:06 GMT

Hi Tee,

Welcome to SDN Forums !

You must use the correct or most appropriate forum, so this thread will be moved from ABAP Objects to ABAP, General.

Please see the Forum Rules of Engagement before posting.

Also read this thread Welcome and Rules of Engagement.

Greetings,

Marcelo Ramos

Re: Convert material number

former_member156446 — Tue, 17 Mar 2009 13:37:53 GMT

CONVERSION_EXIT_MATN1_INPUT    Function Module for Material Number Conversion (INPUT)
CONVERSION_EXIT_MATN1_OUTPUT   Function Module for Material Number Conversion (OUTPUT)

Re: Convert material number

faisalatsap — Tue, 17 Mar 2009 13:39:08 GMT

Hi,

Welcome to SDN

Please Search Before posting.

Test the following Sample code it will solve out your problem,

DATA: m(10) VALUE '0000000012'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input  = m
  IMPORTING
    output = m.

WRITE: m.

Best Regards,

Faisal

Re: Convert material number

Former Member — Tue, 17 Mar 2009 13:40:33 GMT

Hi,

You can use the function module CONVERSION_EXIT_MATN1_OUTPUT of the function group OMCV.

Pass the material number in 00000085 format to the exporting parameter INPUT, and receive the output in format 85 in the Importing parameter OUTPUT.

DATA: f_matnr type matnr value '0000085'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

input = f_matnr

IMPORTING

output = f_matnr.

Best Regards,

Suresh

Edited by: Suresh S on Mar 17, 2009 2:41 PM

Re: Convert material number

Former Member — Tue, 17 Mar 2009 13:41:15 GMT

if you want SAP to store them as 85 instead of 000000000000085, you can set it in cutomizing under

lexographic settings.

where you can do a setting which will not add leading zero's while creating material itself.

Re: Convert material number

Former Member — Tue, 17 Mar 2009 14:43:12 GMT

Thanks guys for the solution.