Transparent table with one column with sequence

[Former Member]

Hi Everyone,

From an oracle perspective we can create tables with any one column to generate the sequence. But in ABAP for a transparent table how i create a column or field to generate the sequence, i there a background way like instead of the creating the transparent table from the gui, we can create it by using the create table script in ABAP. Please let me know, any help will be of great help.

Thanks,

Prabhu

[Former Member]

you can't create a table with scripts like ..

CREATE TABLE ...

You should not do it at the SAP's database level also.

For number sequence, it should be handled in your application using Number Ranges.

I think FM GET_NUMBER_NEXT ( try using * in SE37 to find it , not sure about the name ) is used for getting the next number from the number range.

You can define number ranges using transaction SNRO.

Thanks,

Ram

Message was edited by: Ram Manohar Tiwari

[Former Member]

Thanks,

It helped me a lot.

Regards,

Prabhu.

[jayanthi_jayaraman]

Hi,

You can also generate a table maintenance for the table and then in PBO of the screen you can achieve it by coding manually like

select max (field) into count ...

count = count + 1.

..

After that in PBO itself you can make it uneditable by the user.