topic Re: automatic increase fields in Application Development and Automation Discussions

automatic increase fields

Former Member — Wed, 16 Apr 2008 09:25:34 GMT

All experts:

are there an automatic increase field in Transp. Table?

I need a field that can automatic save the record index when I insert record in customized table.

Thanks in advance.

Re: automatic increase fields

Pramanan — Wed, 16 Apr 2008 11:15:35 GMT

Hi,

Use sy-tabix and sy-index , this shows how many times the loop get

executed and current position of loop

Sy-TABIX - gives the line number

SY-index - gives the current position.

sy-dbcnt - gives how many records get stored to or retrived from database

Re: automatic increase fields

Former Member — Wed, 16 Apr 2008 13:57:34 GMT

Hi,

The indexes are activated along with the table and are created automatically with it in the database.

Regards,

Muneesh Gitta.

Re: automatic increase fields

Former Member — Wed, 16 Apr 2008 20:12:09 GMT

Hi,

You mean to say that you have to maintain a field which autoincrements its value whenever a record is inserted.

Suppose the field is STUDENT_ID.

Whenever you are using LOOP ..ENDLOOP stmts and inserting the records, then You can pass SY-TABIX to the field STUDENT_ID. if you use DO..ENDO then go for SY-INDEX.

This is the case if you inert record by record, but if you want to insert multiple records using directly the internal table then you have to explicitly fill the column in the internal table and insert .

Reward points if helpful.

Thanks and regards.

Re: automatic increase fields

Former Member — Fri, 18 Apr 2008 00:23:16 GMT

You need to create a new number range object (Tcode SNRO). Then get the next sequential number using function module NUMBER_GET_NEXT in your ABAP code and insert in DB table.

Re: automatic increase fields

Former Member — Fri, 18 Apr 2008 00:40:22 GMT

Thank you very much.