topic Re: how to do auto increment ? in Application Development and Automation Discussions

how to do auto increment ?

Former Member — Wed, 19 Sep 2012 18:19:30 GMT

HI ,

how to do auto increment for primary key field . When i am entered Remaining field data then it auto increment how to do . i am working in module pool screens . its possible for function modules like (NUMBER_GET_NEXT , QF05_RANDOM_INTEGER ) but i want logically how to do ....

please help me .....

for example..

DATA : V_NUM TYPE i.

SORT ITAB BY NUMBER.

V_NUM = 1 .

V_NUM = V_NUM + 1.

* it is increments to next number 2 but what about next ...

i want like v_num = max (from database ) ...how ...

thaks @ regards ,

prasad .

Re: how to do auto increment ?

Former Member — Wed, 19 Sep 2012 18:34:31 GMT

There are two approaches -

1) If the program is running and runtime you need to get auto increment you need to use the varaible as static.

2) If you are updating these fields in a Db table then after each comming you need to read the max value from the table and increment it by one.

let me know some more details and I will be able to provide more concrete solution.

best regrads,

swanand

Re: how to do auto increment ?

Clemenss — Wed, 19 Sep 2012 22:08:45 GMT

Hi prasad,

yes, we have the SELECT MAX( NUM ) INTO LV_maxbum FROM <database table>.

Regards,

Clemens

Re: how to do auto increment ?

former_member156446 — Wed, 19 Sep 2012 22:17:15 GMT

You have some options:

1. If its database table update, use "table maint. generator events" and have code to build a number.

2. Can use a number range and use next_number_get / GET_NEXT_NUMBERS functions

3. You can save the max number into TVARVC / TVARV table and get that number each time and update that number after the processing is complete.

4. or as suggested above select max ...

Option 2 sounds good to me.

Re: how to do auto increment ?

Former Member — Thu, 20 Sep 2012 05:51:38 GMT

for more than two values write the code within the loop it will work. so based on varable you can increment values under loops based on fatabase table.

Re: how to do auto increment ?

prakashjasti — Thu, 20 Sep 2012 06:22:45 GMT

Hi ,

For this when you find that there are no entries in your db table please send 1 in the key field.

and when there are entries in your database then select the maximum available number in your key field and increment it by 1 and store the new entry.

Regards,

Prakash.

Re: how to do auto increment ?

Former Member — Thu, 20 Sep 2012 11:08:05 GMT

Thanq Clemens li its working ....