Want to learn about Number Ranges?
Note:13/05/2016
After recent upgrade of my system to EHP7, I realized that the Number range screens shown in this post have undergone changes. The post below was on the basis of screens at EHP0 level.
Still all the functions and procedures remain same and the post below can teach a user of EHP7 environment also about Number ranges, when he identifies the icons and correlates the to the corresponding activity..
Let’s start
A Number range is a Group of numbers to which the unique-Id created for an SAP Object belongs. In each module we have masterdata having SAP objects such as Equipment, Notification, Order, Measuring Point, Maintenance Plans etc in PM, Material number, Material Document, Purchase Requisition, Purchase Order in MM, Sales Order, Sold-to-party etc in SD, Production Order in PP, Inspection lots in QM and the list is long. This document is intended to give basic concepts of Number Ranges we need to create during the Configuration of various modules in the implementation time and after. In this document we try to understand these things through a Plant Maintenance object , namely Equipment .
Before starting our job related to Equipment, let’s understand few generic things about Number Ranges.
Types of Number Ranges
There are 2 categories of number ranges:
Internal numbers: These are purely numbers. System generates the number (within the range you’ve specified) next to the immediate previous allotted number.
External numbers: This is where the person creating the SAP object (e.g., Equipment) is required to enter his choice of number. This will be as per the alpha-numeric pattern he has already declared while creating the number range.
T-Codes
There are configuration paths in each module for respective objects to Define respective number ranges. Also many objects have Tcodes. Here we see the Tcodes for Defining number ranges in PM module.
SAP-PM Object | Tcode |
---|---|
Equipments |
OIEN |
Notification |
IW20 |
PM Order |
OION |
Maintenance Tasklists |
OIL0, OIL4, OIL5 |
Maintenance Plans |
IP20 |
Maintenance Items |
IP21 |
Measuring Points |
IK09 |
Measuring Documents | IK19 |
Revision | DIWPS_REVNRS |
Let’s first see the Internal Number Range
We know that there are different categories for each SAP object.
Few examples:
SAP Object | Category |
---|---|
Equipment | Equipment Category |
Notification | Notification Type |
Maintenance Order | Order Type |
Measuring Point | Measuring Point Category |
In the number ranges configuration-screen you get these Categories, where you need to assign this category/type to a particular number range group. Where from these Groups come? These Groups are nothing but the Number ranges we need to create. One Number range group for one or more Categories of SAP Object, (i.e., Equipment in present case). See this picture:
Here Groups are Test, Standard Number range, Mechanical Equipment, Electrical Equipment, Instrumentation. Under each group different categories of Equipments are seen.
Now let’s start how to create a new internal number range for an Equipment and assign few categories to it .
Tcode OIEN
Click on the Groups icon. to arrive at the picture referred in the beginning. Here you use the menu GoTo –> Insert OR
hit F6 function key to get this pop-up.
Now, Give a title to the Group (Say Demo), give some number range say 000000000010000000 to 000000000019999999 to the Group and upon clicking the Add icon, system might give you the following error messages, telling that this range is interfering with some other Group already existing. i.e., some overlap between.
(In case no such overlap is there, then the Group will be created)
Assuming that overlapping is there, identify the overlapping Group, tick-in the checkbox and go to the maintain screen like below .
See here upper range 000000000019999999 has been modified as 000000000014999999.
Means we have freed numbers from 000000000015000000 to 000000000019999999. Now again GoTo –> Insert and repeat the New Group (Demo) creation. Now it will be accepted.
Thus,we have created a Group named Demo. See this is visible in the list of Groups.
Now we will try to assign one Equipment category to our new Group.Let’s suppose, we want to shift Category G Equipments to this new Number Range. For this follow this procedure.
1.Mouse click on the Category G in the present position where it is .
2.Tick the check box of the target Group, here it is Demo like this
3. Then click on these icons in these sequence (first 1 and then 2)
Now your Category G is there in the Group Demo.
Everything has been done. Now the Category G Equipments when created through IE01 will be given the numbers specified here.
Let’s learn about Few clicking sequences for Assigning and Not Assigning the Categories to Groups.
Case1: Unassigning a Category from any Group.
Let’s suppose I want to unassign Category H . Means I want to bring it to the Not assigned list at the bottom. Follow this mouse click sequence.
Means
1.Click on letter H (Remember the checkbox of this Group should not be ticked-in)
2.Then click on the icon at the top.
3. Then on Not Assigned at the bottom
You’ll find the letter H is in the Not Assigned list like this.
Case2: Assigning a Category from ‘Not Assigned’ to any Group.
Let’s suppose we want to assign Category T to Group Demo .
Follow this Mouse click sequence shown here.
Means
1.Click on the letter T in the Not Assigned list
3.Then Tick the Checkbox of group Demo
You’ll find the Category T has been assigned to group Demo.
Now let see the External number Range.
The process is almost same except for you’ll be providing Character format for number range. A typical External number range format can be AAAAAAAAAAAA – ZZZZZZZZZZZZ. Here even you use numbers they are treated as characters. In case you need have Alpha Numeric then you can have ranges like 01AAAAAAAAAA – 99ZZZZZZZZZZ. Here first 2 places will be having numeric features. You can make use of characters like / also.
Important:
For alphanumeric external number ranges in Equipments you need to have the following setting in the SPRO of Equipment Categorisation.
Path:
Setting
See, for Alpha numeric number Ranges the Checkbox under column a should not be ticked-in.
Note:
- Though concepts were explained with Equipment number as example, there is an identical dealing with all other number ranges, irrespective of which module does it belong to.
- And most importantly Number ranges are not recommended to be transported from Dev client to PRD. They should be locally created in PRD client.
Few words about SNRO and Buffer value
- Number ranges for all standard objects can be seen in SNRO tcode. You can see this by inputting the Object value. In the present post the Object is EQUIP_NR .
- For many standard number range objects (like QMEL_NR for Notification and AUFTRAG for Order) a Buffer value is maintained. This is ’10’ for Notification and ’20’ for Order. For present case of EQUIP_NR there is no buffer is maintained.
- Very often you notice skipping of numbers while creating Notifications or Orders in PRD client. This is due to the buffer value.
- The buffer is important in multiple server scenario where one client has several like in PRD client.
- This Buffer value helps in quicken the process of allotting a number to the Object by the system.
- Had this Buffer not been there, system takes too long to Save an Object while creating due to contacting all servers and deciding the next consecutive number in the series.
- We can create our own Number range object in SNRO and use it in developments in combination with a function module ‘NUMBER_GET_NEXT’ , during the situations where we need to have an auto-number generation for custom objects..
So friends, that’s about the Number Ranges from my side. Hope members find this post too useful .
Thank you
KJogeswaraRao
Very Helpful and Classic Document.It really help alot.
thanks a lot Jogeswara.. 🙂
Thank you Rakesh 🙂
Jogeswara Rao Kavala,
Good One!
Thanks for sharing your knowledge & experiance.
Ritesh
Thank you Ritesh 🙂
Thanks you, 🙂
Nice recap
Thank you Hatem ABIDI
Good one as always. 🙂
🙂
Helpful document..thanks for sharing
Thank you Bhargav
Nice Document Sir.Simple and understandable explanation.
Thank you Sunil 🙂
Very useful and detailed doc. Thanks for sharing 🙂
Thank you Krishna Chaitanya 🙂
Very useful document Sir 🙂
Thank you Kamlesh 🙂
Clear & Excellent document sir.
Thank you Arjunan 🙂
Regards
Very fantastic doocument regarding Number range.
Thanks Jogeshwara...!!! 😎
Thank you Akhilesh. 🙂
Regards
Nice & Very helpful document.
Thank you 🙂
nice document
Thank you sam payton !
Very useful document Joges Sir
Thanks Vignesh 🙂
thanks
Excellent step by step document on Number Ranges 🙂
Thank you very much Gary 🙂
Regards
Hello,
Clear and excellent document.
Thank you very much.
all the best Erwin
Thank you Erwin, These are excellent words for me. 🙂
This is very usefull and Nice Document
Also clears the daught .
regards
Chandan
Thank you Chandan ! 🙂
Good and very informative document. Maybe you can add a note on buffering.
Thanks and regards.
Satish Patankar.
Thank you Satish !
Hi Jogeswara,
thanks again for your efforts to outline this basic topic (..by not forgetting the tricky features like overlapping).
Bye,
Patrick
Hi Patrick,
Very glad as felt always, to have your review and appreciation, .
Regards
KJogeswaraRao
hi... jogeswara sir .....,
really awesome document about number range....
thanks a lot ....
Thank you 🙂
You have done an excellent work, nicely crafted.
Thank you Avirat.
Hi Jogeswara Rao Garu, good Blog, Thank u Sir. keep posting such Blogs. Regards Kumar
Thank you Kumar 🙂
Thank you sir for your Exclusive Contributions to scn.sap.com
My pleasure Siva !
Wonderful explanations Sir... I've maintained number ranges many times, however this information is a step by step encyclopedia for Number Range... Thanks a lot for sharing this... 🙂 🙂 🙂
Thank you V T,
That's a great compliment 🙂
Dear Mr Jogeswara,
Once again thanks a lot for sharing the documents.Its is really very important to understand the number range and its object concept.
Regards.
Swapnil
Thank you swapnil,
🙂 Your review is motivating.
Self explanatory & fairly linear we can expect only from you Mr.Rao
Thank you for sharing knowledge & keep posted.
Thank you Ravi for such good words 🙂
Sir,Thanks you for sharing all your expertise to us,really its good doc to understand Number range for PM Objects.
Thank you Subhash for your time to communicate and your good words 🙂
Hi Mr.Jogeshwar rao,
Good one, Many of us know , still systematic documentation / ready reference for many its very usefull.
Thank you 🙂 .
Thank you so much for your clear documentation on number range. I appreciate your nice effort.
Please also add the How to change the existing number ranges by removing the NR Status and then changing the sequence. For example. Current number range is From 20140000 to 20149999. Current NR Status is 20144329. Now explain how to change the number ranges to 20150000 to 20159999.
This will be useful for Users while really.
Regards,
Ramakrishnan.A
Thank you
Regards
KJogeswaraRao
Nice document sharing... Thanks Jogeswara.....
Thank you karunanithi,
Regards
KJogeswaraRao
Nice Article
Thank you master
Regards
Saifudin Hajar
Thank you siafudin,
Regards
KJogeswaraRao
Good one Sir. Was knowing about SNRO, but got to know about this today.
Cheers,
Nikhil Kulkarni
Thank you Nikhil 🙂
Nice one .
Regards,
Shareeq
Thank you Sahreeq 🙂
Thank you so much sir. It is really useful doc.
Lavanya
🙂
Glad Lavanya, You found this post is useful to you.
Welcome to SCN (You've just joined). Go through this link if not already did.
The SCN Rules of Engagement
KJogeswaraRao