topic Re: Generate number range with date in Application Development and Automation Discussions

Generate number range with date

Former Member — Wed, 07 Sep 2011 13:46:13 GMT

We would like to generate a unique numeric value to represent an external invoice number. This number begins with the current date followed by the next number in the sequence 0-9999 e.g. 201109070001. The sequence needs to be reset to 1 at the start of each day.

We currently use a program to select and update a database table which stores the date and next number in the sequence for a given day and finally reset the number at the start of each day. Unfortunately we sometime experience duplications of the invoice numbers.

I've tried using a SAP number range object (transaction SNRO) but I can't find a function to reset the number.

Is there a function to reset a SAP number range object or an alternate method to obtain the required results?

Thanks,

Nicholas

Re: Generate number range with date

former_member209703 — Wed, 07 Sep 2011 14:08:19 GMT

RRBA_NUMBER_RANGE_RESET

Re: Generate number range with date

Former Member — Wed, 07 Sep 2011 14:21:15 GMT

Hi,

It is not recommended to reset the number range. Why cant you try finding a function module where you can propose a number based on the requirement.

Please check the below thread :

Shiva

Re: Generate number range with date

Former Member — Wed, 07 Sep 2011 14:35:20 GMT

At first, sorry if i sound any harsh or what, thats in no way intended. I´m just a technician.

What i dont get is, why you dont just do that yourself. either create a table or make use of a TVARVC variable where you store your last number, along with the date where it was created/used.

you can easily write a FM which does what NUMBER_GET_NEXT does. Means if a number is requested, goto your table or TVARVC variables (yeah two, one for number, one for the date), and check what number you got there.

If date = sy-datum then increment number by one, store it to your table/TVARVC variable, and return that number as an exporting parameter.

elseif date # sy-datum then store 1 and your new date in your table/TVARVC variables and return it as exporting parameter.

As it would be a FM of your own, soleley for this purpose you can even return a concatenated value of sy-datum and your number, instead of just the number.

I would estimate a maximum workload of one hour for such a solution, and it would exactly do what you need.

hope you got my drift.

Re: Generate number range with date

Former Member — Wed, 07 Sep 2011 14:50:02 GMT

Florian, your suggestion is what we currently have in place and for the most part it is works. However, every once an a while we find orders with the same invoice number. This number is suppose to be unique for each external invoice.

I'm trying to eliminate all chances of duplicated invoice numbers and using a number range object seems to be my best bet.

Re: Generate number range with date

Former Member — Wed, 07 Sep 2011 14:56:38 GMT

Are you locking your number range table while you get the next number and update it?

Rob

Re: Generate number range with date

Former Member — Wed, 07 Sep 2011 18:34:43 GMT

The table isn't locked. How do I go about locking?

Please note it is frequently accessed.

Re: Generate number range with date

Former Member — Wed, 07 Sep 2011 18:45:36 GMT

Locking tables is pretty basic. Please search the forums for ideas.

Rob