topic Re: Create table in Application Development and Automation Discussions

Create table

Former Member — Fri, 15 Sep 2006 09:08:35 GMT

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

Re: Create table

Former Member — Fri, 15 Sep 2006 09:10:35 GMT

Hi,

use SNRO transaction to create number range object

and use Fm Number_Get_next.

Regards

Amole

Re: Create table

andreas_mann3 — Fri, 15 Sep 2006 10:27:51 GMT

hi,

go to snr0 and move x to checkbox TNRO-YEARIND

Re: Create table

messier31 — Fri, 15 Sep 2006 12:58:44 GMT

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...

Re: Create table

Former Member — Fri, 17 Nov 2006 12:34:46 GMT

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