topic Re: number generation in Application Development and Automation Discussions

number generation

Former Member — Mon, 04 Aug 2008 15:17:39 GMT

hi,

i need sequence numbers for a field. there r two ways i can do this...

create an object in SNRO and use

CALL FUNCTION 'NUMBER_GET_NEXT'

creat a custom table where i maintain the current number and the next number.

which is a better approach ? does any have adv/disadv over the other ?

thks

Re: number generation

RichHeilman — Mon, 04 Aug 2008 15:21:10 GMT

The first is the best way to do it, why? Becasue that is how SAP does it. Most every genreated number in R/3 uses the number range object approach. It supports buffering, and locking automatically so you don't have to worry about this in your custom table. Use the number range object and the function.

Regards,

Rich Heilman

Re: number generation

Sm1tje — Mon, 04 Aug 2008 15:21:36 GMT

Just use the standard way SAP Provides using SNRO. Advantage is the fact that you don't have to create custom development objects and SAP provides all the standard functionality like number range buffering, different ranges to be maintained, standard FM like (NUMBER_GET_NEXT).

Re: number generation

Former Member — Mon, 04 Aug 2008 15:22:18 GMT

create an object in SNRO and use

CALL FUNCTION 'NUMBER_GET_NEXT'

is used by standard programs.

so when ever you want to update new number you need to call the Function using the Object created in SNRO.

creat a custom table where i maintain the current number and the next number.

But for Normal Table appraoch is exactly the same as SNRO and NUMBER_GET_NEXT function behaves. so you are replicating the whole process.

instead you can reuse the Standard Functionality