Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Regarding creation of z tables

Former Member

‎01-28-2008 2:07 PM

0 Kudos

Hi Friends,

How to create primary key field auto incremented in Ztable as in oracle and Access. I have data in which all columns are duplicate.Any body provide me the solution for this Requirment.

3 REPLIES 3

raymond_giuseppi
Active Contributor

‎01-28-2008 2:27 PM

0 Kudos

You have to attach the key to a number range and use function module like NUMBER_GET_NEXT to increment the key.

Regards

Former Member

‎01-29-2008 4:26 AM

0 Kudos

Hi Vishu, this will help.

you can maintain "number ranges" that will provide numbers in sequence according to rules customized in transaction SNUM

in your program, you have to call FM NUMBER_GET_NEXT that will return the next number of the range.

kindly reward if found helpful.

cheers,

Hema.

Former Member

‎01-29-2008 5:26 AM

0 Kudos

Hi,

Use number ranges for this.

You can use transaction SNRO for creating number ranges.

Regards,

Renjith Michael.