topic Re: How to increment table key field automaticly? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467675#M833495 <HTML><HEAD></HEAD><BODY><P>thank you guys. It helped.</P></BODY></HTML> Thu, 13 Mar 2008 10:41:08 GMT Former Member 2008-03-13T10:41:08Z How to increment table key field automaticly? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467671#M833491 <HTML><HEAD></HEAD><BODY><P>Hallo Guys,</P><P>I need to increment ID-field in DB table. Another record in table means id = id+1. </P><P>Is there any FM how to do it dynamicly or automaticly? Or is there a special setting in </P><P>table(data element) so I don't have to do it in my program by inserting new record?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 13 Mar 2008 10:09:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467671#M833491 Former Member 2008-03-13T10:09:42Z Re: How to increment table key field automaticly? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467672#M833492 <HTML><HEAD></HEAD><BODY><P>use tcode SNRO and fm number_get_next</P><P></P><P>A.</P></BODY></HTML> Thu, 13 Mar 2008 10:32:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467672#M833492 andreas_mann3 2008-03-13T10:32:44Z Re: How to increment table key field automaticly? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467673#M833493 <HTML><HEAD></HEAD><BODY><P>You should use a number range with internal numbering , and FM NUMBER_GET_NEXT (NUmber range: Assigns next free number).</P><P>Number ranges are managed by transaction SNRO.</P></BODY></HTML> Thu, 13 Mar 2008 10:35:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467673#M833493 Former Member 2008-03-13T10:35:45Z Re: How to increment table key field automaticly? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467674#M833494 <HTML><HEAD></HEAD><BODY><P>Sorry the first answer was not visible while I was typing mine, which is the same !</P></BODY></HTML> Thu, 13 Mar 2008 10:38:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467674#M833494 Former Member 2008-03-13T10:38:30Z Re: How to increment table key field automaticly? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467675#M833495 <HTML><HEAD></HEAD><BODY><P>thank you guys. It helped.</P></BODY></HTML> Thu, 13 Mar 2008 10:41:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-increment-table-key-field-automaticly/m-p/3467675#M833495 Former Member 2008-03-13T10:41:08Z