Create table

[Former Member]

Hi,

I want to create a table, but one of the fields i want to put in the table, i want him to be of automatic numeration, what i want is for each record that is added the field is filled with the year and a sequencial number, like this:

200601 xxxxx xxxxx

200602 xxxxx xxxxx

200603 xxxxx xxxxx

....

200701 xxxxx xxxxx

200702 xxxxx xxxxx

....

anyone know if this is possible and how to do it?

Thanks

[Former Member]

Hi,

use SNRO transaction to create number range object

and use Fm Number_Get_next.

Regards

Amole

[andreas_mann3]

hi,

go to snr0 and move x to checkbox TNRO-YEARIND

A.

[messier31]

step 1.

If you have created a table maintenance, you will have

program name for table maintenance.

Naming convention is SAPLXXXXX where XXXX is table name.

Step 2.

Go to PAI of details screen.

In PAI read the last entry created for the auto increment

field and increment the same in the way you want.

step 3.

Assign the incremented value to table field

and you job is done ...every time you create a entry the auto entry field increment by itself and will get saved in database...

let me know if this solves your problem...

[Former Member]

Hi,

I have the same situation.

I create a table with maintenance program, and want a field with sequencial number that is auto generated when a user add a new record.

I need an example with how to do that.

Thanks,

Sidney