Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to remove Leading zeros from MATNR "at Database Level"


When we create a material in MM01 , we can either create material as Internal Material No. or External Material No. (By Explicitly entering a material No.)

Our requirement is that: When we create an Internal Material , there should NOT be any Leading Zeros in MATNR.

and for External Material No. , Leading Zeros Should be there. (In Database)

1) Now , we can create the No. Range for material in such a way that it will allow only AlphaNumeric entries for Internal Material , and Only Numeric Entries for External Material No.

This should slove the Purpose.

But According to the Client's requirement , Material No can be Numeric OR Alphanumeric for Internal As well as External Material No.

2) We can Add or Remove leading zeros from MATNR at application level. i.e. we can find some BADI / Enhancement where we will Use the Conversion FM (CONVERSION_EXIT_MATN1_OUTPUT or CONVERSION_EXIT_ALPHA_OUTPUT) and remove Leading Zeros from MATNR. But these changes will NOT reflect at Database Level , Because in MATNR Domain , there is a conversion Routine , That will Add Leading Zeros in MATNR While saving in the Database.

3) While Displaying the Material In SE11 , we can also set the "Display Format" as With leading Zeros OR Without Leading Zeros.

But we dont want to Just "Display" material with OR Without Leading Zeros. we want to actually create materials in that way.

What can we do , so that at Database Level our changes are Reflected.

Thanks and Regards,

Anand Gore

Edited by: anandgore on May 18, 2011 3:47 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question