topic Re: Database Table with increment Primarey key??? in Application Development and Automation Discussions

Database Table with increment Primarey key???

Former Member — Wed, 31 Mar 2010 10:29:58 GMT

Hello at all,

i have a database table ZTEST and there are 2 Primarey keys:

MANDT & ID.

But the ID key must declared as increment.

If i insert a row in my table ZTEST, than the SYSTEM must automaticly increment the Primarey key ID.

How can i realize this in ABAP???

With kind regards

ETN

Former Member — Wed, 31 Mar 2010 10:47:34 GMT

Use u201Cselect max(id)u201D to get the higest value from table. Then increment it and save the data to table.

Regards

Prajwal K.

Former Member — Wed, 31 Mar 2010 10:48:28 GMT

Hello

You need to create a number range and use FM NUMBER_GET_NEXT for generate next value.

How to do this ?

Former Member — Wed, 31 Mar 2010 11:42:50 GMT

Thank you for help.

rainer_hbenthal — Wed, 31 Mar 2010 11:58:19 GMT


> Use u201Cselect max(id)u201D to get the higest value from table. Then increment it and save the data to table. 
> Prajwal K.

This is useless, consider paralell processing. You dont have any enqeue/deqeue processes, so two (or more) paralell reports can get the same number.