Number Ranges

SAP SD Training     SAP CRM Training      SAP Access      SAP Training

 Concept

A number range is a sequence of numbers with a start and an end. It also contains the current number that is being used. For example, when a sales document of type OR is being created, the number range lies between 1 and 199999. Also it is defined as an internal number range. So when a new sales order is being created, the user does not enter the sales order number when saving. Instead SAP automatically generates a sales order number in the system for our reference. Number ranges have two purposes. One is for the System to internally identify the sales order with a number for easy retrieval and management. The other is for the users to visually identify a document type just by looking at the number. For example, if orders of type OR have the number range mentioned above, and Quotes have a different number range – This makes it very easy for the user who is creating them to identify if the number is an order or a quotation.

Configuration

Number ranges vary by area. For example, sales document number ranges are configured in [VN01]. Accounting document number ranges are defined in [FBN1]. However, the concept in same anywhere.

The menu path to define sales document number ranges is [ SPRO -> IMG -> Sales and Distribution -> Sales -> Sales Documents -> Sales Document Header -> Define Number Ranges for Sales Documents ]

Each number range is divided into an interval. You can do the following.

VN01 - Sales document number ranges


For more details, visit us at SAP Training and SAP Access


  • You can view the different number range intervals. For example, 01 stands from 0000000001 to 0000199999 with the current status at 12919. You can also see if the interval has been defined as internal or external.

View Number Range Intervals

  • You can change the status of each of the number ranges – Meaning, change the current running number in the interval so that when the next order is created it will be created with 13000 as opposed to 12920.

Change the status of the number range

  • You can Create New Intervals or delete existing intervals.

Create new number range

Click on the + button on the top to create a new interval. If you enter a number in the current number the newly created order associated with the number range Z9 will start with that number. Otherwise it will start with 0200000001. Also, since we are not marking the number range as External ( in the check box Ext ), the number range is classified as internal and can be only used in situations that demand internal number ranges.

Create new number range interval Z9

23 Responses to “Number Ranges”

  1. Ilana March 2, 2012 at 4:52 pm #

    number range ZI is created

  2. David February 19, 2012 at 10:13 pm #

    Number Range

    ZD created

  3. satya February 8, 2012 at 6:21 pm #

    Created a number range.
    No. 46
    From Number: 0008400000
    To Number: 0008699999
    External Number range

  4. Mahesh February 5, 2012 at 4:16 pm #

    New number ramge created Z1
    Z1 0020000001 0003000000 20000002

  5. Guru January 9, 2012 at 11:03 pm #

    Created Internal Number Range :46

    Also changed the current number.

  6. Murali Kotikalapoodi January 9, 2012 at 1:55 am #

    Created an internal range of numbers with value 96

  7. zaheer January 8, 2012 at 11:13 pm #

    Hi Siva,

    How do we identify which number range is associated with which order type?

  8. Mital Shah December 10, 2011 at 9:10 pm #

    created number range MS and SM

  9. Pooja November 20, 2011 at 8:35 am #

    Siva

    Lets say I have two clients X and Y,the current number in X is 085 and current number in Y is 0345.How do I transport from X to Y as 085 already exists in Y?

    • siva November 20, 2011 at 11:04 am #

      First off, number ranges are not transportable. As soon as you create number ranges you will get the message indicating the same.
      Now, in order to create the number range in production ( either during cut over or in a full productive system ), the changes are done directly in the system. Let’s discuss more on this in the class.

  10. Rajesh October 19, 2011 at 12:26 am #

    Siva,

    New number range created: R1.

    Regards,
    Rajesh

  11. Larry Cabral October 18, 2011 at 7:05 pm #

    3. What occurs when the number range wraps around to start over? Must the implementation design ensure that no historical information (documents) are still in the system when wrapping occurs, or will the system handle multiple documents in the system with the same document number (perhaps by composite key including date)?

    To test this question we could alter the latest value for an order number range to cause a rollover condition when generating the next order.

  12. Larry Cabral October 17, 2011 at 6:26 pm #

    I created numeric internal number ranges “96″ AND “97″. I then deleted range 97. I then created an external number range “95″. I could not created an alpha numeric range because someone had previously created range “99″ as AAAAAAAAA – ZZZZZZZZZ and the system would not allow overlap.

    I saved the table ranges. When I did I received a warning message message indicating that the table ranges will not be transported automaically and that transport must be triggered manually from the initial screen.

    I returned to the initial screen and manually triggered the transport. I presented with a warning screen indicating that ALL number ranges would be transported with their existing values at the time of transport. I did not complete the transport so as to be safe for the test environment. This raises some interesting questions:

    1. The above infers that even if the only desired change is to add a new range for a new custom sales doc (i.e. ZRET), since all ranges will be transported this kind of maint. is best performed during initial system design/setup, and at least only performed when the SD part of the system is entirely quiet?

    2. Will the number range function allow you to delete a range that is attached to a sales document type?

    3. What occurs when the number range wraps around to start over? Must the implementation design ensure that no historical information (documents) are still in the system when wrapping occurs, or will the system handle multiple documents in the system with the same document number (perhaps by composite key including date)?

    • siva October 18, 2011 at 5:13 am #

      1. YES – But the change is instantaneous. So this should not cause a problem big time. But like you said, it’s best to transport it on weekends.
      2. Number range could remain in VN01 but the detachment could happen in sales doc type config as we have seen
      3. Frankly I have not faced this situation yet. But it can definitely happen with clients using SAP over a large period of time. Will test it and let you know.

      Btw, quick question for you – Can you guess how we can test yout Q.3 ?

      • Pooja November 20, 2011 at 10:43 pm #

        Thanks Siva,will remind you in the class then.

  13. Edward Emmory October 11, 2011 at 5:20 pm #

    New number range created: 09

  14. jitesh September 22, 2011 at 11:14 pm #

    new no range created Zj

  15. Nas September 18, 2011 at 9:31 pm #

    Created number range 76.

  16. Mrunal September 18, 2011 at 2:07 am #

    Ans1: In a business scenario, where we want to use different product prices for different customers we can create a new price list and assign it to required customers.
    Ans2: Price list category “ZW” created for agency customers.
    Ans3: Unable to create a new customer currently due to the number range issue.
    Ans4: Assigned price list category to 30005 in sales area view, sales tab.

  17. justin August 24, 2011 at 11:32 pm #

    hi Siva

    what does internal and external means in usage.

    thanks

    Justin

  18. Harsh June 30, 2011 at 4:09 am #

    Hi Siva,

    is it possible to create number range with alpha numeric. can i start number from A1 to A100 for customers

    • siva June 30, 2011 at 7:06 am #

      Harsh
      Yes you can. Number ranges can be alphabetic or numeric. However, when using alphabetic number ranges, SAP does NOT auto increment. So you would have to use external number ranges.

  19. Harsh June 30, 2011 at 1:38 am #

    Hi siva ,

    while creating a number range for customers i am having an error message of : please enter initial status

    please let me know what i should i do about it.

    Thanks
    Harsh

Leave a Reply