cancel
Showing results for 
Search instead for 
Did you mean: 

Material Master External Number Range problem

Former Member
0 Kudos

Material Master External Number Range that allows numerics only and combo of numerics, Alpha and Characters

I have the following issue. My client wants to use a purely External Numbering System in SAP

- They only use one Material Type (HALB).

The range must be able to manage material numbers that:

1. Are up to 18 CHAR

2. Have Leading Zero's(Numeric Only) - example 0123, 0000223, etc

3. Purely numeric (no zeros) - ex 56788, 1235456

4. Have Leading Zero's with (Alpha Numeric) - ex 00A456

5. Alpha numeric (No Zeros) ex T123542

6. Leading Zero's with a '.' in the Mat Number

Four examples

005.009.23

0000A.123.5544 M1

000.593.33234

0.1234

I have the Lexiographical Setting Checked

Leading Zero's Checked

Range is - 000000000000000000 to ZZZZZZZZZZZZZZZZZZ

The issue I have is with the last two examples in 6 above 'Leading zero's with a '.' in the Mat Number.

It seems the system has an issue with zero's then a decimal point without having another number of letter in between. It will allow 00000002.1223 but not 000000.1223. The only way I can get the system to take the leading zero then '.' entries is to check 'X' the 'External Number Assignment w/o Check in the Material Type HALB. When I do that I am no longer allowed to create purely numeric numbers. Any help?

Creating another material type is not an option. Also the '.' can be in any position in the layout.

Thanks in Advance!

--Chris

Accepted Solutions (1)

Accepted Solutions (1)

sjeevan
Active Contributor
0 Kudos

ASCII and UNICODE values of period (.) are lower that 0.

Solution: Change your number range like this

From


Range is - 000000000000000000 to ZZZZZZZZZZZZZZZZZZ

To

Range is - - - - - - - - - - - - - - - - - - to ZZZZZZZZZZZZZZZZZZ

(replace zeroes with hyphen, because the value of hyphen is lower than period)

[ASCII table|http://www.asciitable.com/] for reference.

Edited by: Jeevan Sagar on Nov 29, 2011 1:04 PM

Former Member
0 Kudos

Jeevan,

This took care of the problem! And, since the numbering also includes underscores, I will set the range as "----


" to "__________________". I can't believe it was so simple. Thanks!

--Chris

a_ahmed
Explorer
0 Kudos

This message was moderated.

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Chris,

Please go thru the thread [ Output orientation of the material |]

Hope you find this useful.

Reetesh

eduardo_hinojosa
Active Contributor
0 Kudos

Hi Chris

Wellcome to SCN. I think that Note 72286 - Lexicographical <-> non-lexicographical material no. answers your question. In the other hand, see Note 78093 - Display of alternative material identifiers, perhaps it gives the solution for your client's requirement.

I hope this helps you

Regards

Eduardo