topic data table sequence? in Application Development and Automation Discussions

data table sequence?

Former Member — Fri, 30 Nov 2007 11:09:19 GMT

Hi,

i have created a data table with the transaction se11.

For this table i want to create a sequence.

Is this possible?

Thanx

Tony

Re: data table sequence?

Former Member — Fri, 30 Nov 2007 20:50:32 GMT

If you want to create a sequence so that the value of a particular column of your table gets filled up automatically, you have to do it in your maintenance logic. There is no automatic way to do it. You can create a custom number range, call that number range to get next number in the sequence and put that into this column everytime there is a new record to be inserted.

Re: data table sequence?

Former Member — Fri, 07 Dec 2007 11:34:00 GMT

It is possible to create a table sequence. Here you will be having one table which will have a foreign key relation to the other table.

An already existing example of such a tables would be spfli, sflight and sbook.