2007 Feb 28 4:06 PM
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.
2007 Feb 28 4:15 PM
Take a look at the sourcecode of the function module NUMBER_GET_NEXT.. It might give you an idea..
~Suresh
2007 Feb 28 4:45 PM
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.
2007 Feb 28 5:26 PM
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