Database Table with increment Primarey key???

[Former Member]

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]

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

Regards

Prajwal K.

[rainer_hbenthal]

>

> 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.

[Former Member]

Hello

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

How to do this ?

Check: http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=50004015

[Former Member]

Thank you for help.