Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to increment table key field automaticly?

Former Member
0 Likes
829

Hallo Guys,

I need to increment ID-field in DB table. Another record in table means id = id+1.

Is there any FM how to do it dynamicly or automaticly? Or is there a special setting in

table(data element) so I don't have to do it in my program by inserting new record?

Thanks.

Hallo Guys,

I need to increment ID-field in DB table. Another record in table means id = id+1.

Is there any FM how to do it dynamicly or automaticly? Or is there a special setting in

table(data element) so I don't have to do it in my program by inserting new record?

Thanks.

4 REPLIES 4
Read only

andreas_mann3
Active Contributor
0 Likes
716

use tcode SNRO and fm number_get_next

A.

Read only

Former Member
0 Likes
716

You should use a number range with internal numbering , and FM NUMBER_GET_NEXT (NUmber range: Assigns next free number).

Number ranges are managed by transaction SNRO.

Read only

Former Member
0 Likes
716

Sorry the first answer was not visible while I was typing mine, which is the same !

Read only

0 Likes
716

thank you guys. It helped.