data table sequence?

[Former Member]

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

[Former Member]

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.

[Former Member]

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.