topic Number ranges in Application Development and Automation Discussions

Number ranges

Former Member — Thu, 15 May 2008 03:55:07 GMT

what are number ranges and what are they used for??

thanks and regards

uday

Re: Number ranges

Former Member — Thu, 15 May 2008 03:58:59 GMT

Go to T Code FBN1

A range of numbers that are laid down per file for the assignment of document numbers. It can be internal (carried out automatically by the system) or external (carried out manually by the user).

You can override the sap standerd invoice number ranges with your custom table invoice number ranges

RV60AFZZ -->USEREXIT_NUMBER_RANGE Here you can override programatically

In a distributed system landscape, you have to ensure for many application areas that numbers are assigned for objects across the systems without overlaps. You do so by defining disjunctive number range intervals.

You can carry out the following steps centrally from a given system (usually the central system of your system landscape):

· Check whether conflicts exist between the number range intervals in the systems of your system landscape

· Use reservations to plan cross-system number range intervals without overlaps

· Navigate from the central system to the other systems and define the required number range intervals on the basis of the reservations

Reward points..

Re: Number ranges

former_member156446 — Thu, 15 May 2008 03:59:18 GMT

http://help.sap.com/saphelp_nw04/helpdata/en/b4/185f28179c4f3cb8d00988cd139500/frameset.htm

Re: Number ranges

Former Member — Thu, 15 May 2008 04:02:12 GMT

Hope it will help you.

Reward pts if help.

Overview:-

It is often necessary to directly access individual records in a data structure. This is done using unique keys. Number ranges are used to assign numbers to individual database records for a commercial object, to complete the key. Such numbers are e.g. order numbers or material master numbers.

These numbers provide, apart from unique identification of a data record, the possibility of encoding differentiating information for an object. One could tell from the number e.g., to which material type a material belongs.

The R/3 number range management also monitors the number status, so that numbers which have already been issued are not re-issued.

All dialogs, database accesses or other activities which are necessary for the maintenance of number range objects and number ranges and number allocation in user developments, can be performed using SAP function modules.

A commercial object, for which part of the key is to be generated via number ranges, is defined as a number range object in the SAP system. If this commercial object contains sub-objects, e.g. company codes or controlling areas, this differentiation can also be made in the number ranges. This happens by specifying a field for the sub-object when defining the number range objects. (Example: company code as sub-object of documents)

The number range interval within a commercial object and sub-object never overlap. The number range intervals in various sub-objects of a commercial object can overlap.

A number range interval is assigned to a commercial object via the number range number. This assignment is usually saved in a table belonging to the commercial object, the group table. The field Element must be all or part of this table’s key. Elements which refer to the same number range interval form a group. You can decide whether you want to make this assignment possible for the user during the number range object maintenance (via the assignment of elements to groups) or whether you want to program it yourself.

When a new material master is created, the material type should determine from which number range interval a number to complete the material master key should be assigned. The commercial object is the material master, the group table the material type table, with the element field material type as key field. The number range numbers for the various element values (material types) are saved in this table. Material types are e.g. semi-finished or finished products.

A number range contains a number range interval with a defined character set. The number range interval consists of numeric or alpha-numeric characters (only for external number ranges) and is delimited by the fields From number and To number. Either one interval, or several if financial years are to be distinguished, is assigned to a number range.

The number range number identifies a number range for the system and makes system-internal access to the number range interval possible. It can be numerical or alpha-numeric. This number is generally assigned system-internally. If you do not need grouping or if you want to program the group table maintenance for the grouping yourself, you must enter the number range number during interval maintenance yourself.

If financial years are to be distinguished in the number assignment, there can be several intervals. Separate intervals are then specified for each financial year. Number ranges can be external (number to be assigned manually by the user) or internal (number assigned automatically by the system).

A commercial object can either have only one number range (external or internal) or two number ranges (external and internal).

The various distinctions between commercial objects gives rise to eight Number range object types.

Element and group

Element is the field in the group table according to whose value a commercial object can be grouped. The grouping is done by number range assignment.

Element values to which the same number ranges are assigned constitute a group. For the material master, for example, the groups are managed in the material type table. The groups can be maintained via the standard maintenance dialog for number range intervals. If you do not want to do this, you must program it yourself.

Groups can be either dependent or independent of sub-objects. This depends on whether the sub-object is a group table field.

The following table shows as an example the grouping of material types and the associated number range assignment.

Grouping material types

Group

Material type

Internal no. range

External no.range

Group 1

Finished

Group 1

Semi-finished

Group 2

Raw material

The material types Finished and Semi-finished form one group, and the material type Raw material another.

Until financial year

Fixed time periods (financial years) are assigned to number range intervals within a number range with a year value. These intervals can overlap within a number range. In this case the financial year or until financial year, as well as the assigned number, must be part of the application table key.

Re: Number ranges

Former Member — Thu, 15 May 2008 04:05:20 GMT

Hi,

Number ranges are used to increment unique numbers .

Create the Number Range Object using SNRO tcode

and define/maintain the number ranges for that object using SNUM tcode

and then use the fun module NUMBER_GET_NEXT in the code to get the next continuous numbers for that field

see the sample code

CALL FUNCTION 'NUMBER_GET_NEXT'

EXPORTING

nr_range_nr = '01'

object = 'ZDOCNUM'

QUANTITY = '1'

SUBOBJECT = ' '

TOYEAR = '0000'

IGNORE_BUFFER = ' '

IMPORTING

number = v_docno

QUANTITY =

RETURNCODE =

EXCEPTIONS

interval_not_found = 1

number_range_not_intern = 2

object_not_found = 3

quantity_is_0 = 4

quantity_is_not_1 = 5

interval_overflow = 6

buffer_overflow = 7

OTHERS = 8.

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.