Serial No increment

[Former Member]

Dear SAP Guru's,

I created one table having key fields are mandt,sr_no,werks.My question is that when i create new entry in table it will check the client & plant and automatically take increase sr_no by 1. Is it possible

Thanks & Regards

Atul Singh

[Sandeep_Kumar]

You have to create maintenace view and implement the logic for auto increment in the Event "on_save"to achieve the same.

[bbalci]

Hi Atulks

First create a maintenance screen for your table,

Go to transaction se55, specify your table table , click on "Generated Objects" and click Change/Create

it will move you to your maintenance screen dialog.

Now click on menu item Environment > Modification > Events

you will see the events table , just click "new entries"

You want to set a new number for your new records,

than u should use event "05 Creating a new entry" and specify a form name for it here.

Now go to your function group ( that you have used for creating table maintenance )

and create that form in that function group. ( You can use a Z include etc. )

Now when user creates new entries, your maintenance screen will call this subroutine

you can set values for fields in that subroutine.

my table and field name was : zxss_table / number :

Here is my subroutine example :

FORM zxss_table_event_05.

DATA nr_object TYPE inri-object VALUE 'ZSD_XSS1.

IF zxss_table-number IS INITIAL.

CALL FUNCTION 'NUMBER_GET_NEXT'

EXPORTING

nr_range_nr = '00'

object = nr_object

• QUANTITY = '1'

• SUBOBJECT = ' '

• TOYEAR = '0000'

• IGNORE_BUFFER = ' '

IMPORTING

number = zxss_table-number

• QUANTITY =

• RETURNCODE =

EXCEPTIONS

interval_not_found = 1

number_range_not_intern = 2

object_not_found = 3

quantity_is_0 = 4

quantity_is_not_1 = 5

interval_overflow = 6

buffer_overflow = 7

OTHERS = 8.

IF sy-subrc <> 0.

ENDIF.

ENDIF.

ENDFORM.

I hope it helps.

Bulent

Edited by: Bulent Balci on Jul 9, 2010 1:10 PM