Number range for custom DB table field

[Former Member]

Hi All,

I want a number to be generated in a field of a custom DB table every time I insert an entry in this table. This number should be in a range. But I don't know how to assign a range to a custom table field and what to write in the program so that every time, the next number in the range, to be generated for this field.

Can anybody help me?

Thank you in advance,

Diana.

[Former Member]

You create a number range object and interval through transaction SNRO.

Before you do your insert, you call function NUMBER_GET_NEXT for the nmuber range object and interval and use the number you get.

[Former Member]

Thank you