Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

NRIV - Number Ranges

adnanmaqbool
Contributor
0 Kudos
388

Dear Guys

I am using number ranges while creating sale order invoices.Invoices are generated by a huge numbers of users due to which its taking too much time to read the NRIV table, even to print a single invoice.

I cant use to buffering because of legal issues and NRIV is taking time, is there any other way to make NRIV fast or any other buffering technique by which numbers lost can be avoid.

3 REPLIES 3

suresh_datti
Active Contributor
0 Kudos
192

Take a look at the sourcecode of the function module NUMBER_GET_NEXT.. It might give you an idea..

~Suresh

adnanmaqbool
Contributor
0 Kudos
192

Well NUMBER_GET_NEXT is used to just fetching the data from NRIV , I dont know how can it help us in retreavind data fast when we r not using Buffers.

Kindly give details about how to retrieve numbers fastly when not using buffers.As fetching data from NRIV is taking too much time.

former_member194669
Active Contributor
0 Kudos
192

Hi,

The following are the primary key fields in NRIV ie

OBJECT

SUBOBJECT

NRRANGENR

TOYEAR

If in your select you are not using these keys , then check for secondary indexes are available for NRIV.

Thanks

aRs