topic Re: Automatic counter in database in Application Development and Automation Discussions

Automatic counter in database

former_member659396 — Fri, 30 Jan 2009 05:42:08 GMT

Dear friends

I am doing module pool programming and i am saving data in database table through screen..

I have to give counter to that saved data..

Following is my logic to give counter to database table...

where i have to define it in PBO or PAI

SELECT SINGLE ZRD_HDRID INTO P FROM ZRD_ORDTYP

WHERE ZRD_HDRID = ( SELECT MAX( ZRD_HDRID ) FROM ZRD_ORDTYP ) .

LOOP AT WA_ORDTYP.

P = 0.

P = P + 1.

WA_ORDTYP-ZRD_HDRID = P.

ENDLOOP.

modify zrd_ordtyp from wa_ordtyp

Please Help me

Regards

Rohan

Re: Automatic counter in database

Former Member — Fri, 30 Jan 2009 05:51:08 GMT

Hi,

If your requirement is to use serial number as primary key in your table

then better to use number range for this...

If your requirement is other than serial number then please clarify...

Regards,

Meet

Re: Automatic counter in database

former_member659396 — Fri, 30 Jan 2009 06:10:15 GMT

How to give that number range

Re: Automatic counter in database

Former Member — Fri, 30 Jan 2009 06:20:53 GMT

HI,

For number range you need to create Z number range from SNRO transaction,

then use that in your code..

At the time of inserting data in Z table, you need to call FM : 'NUMBER_GET_NEXT'

it will give you next number to the maximum number of you \r number range..

steps are below...

create number range using SNRO transaction

then call Fm 'NUMBER_GET_NEXT' before inserting data in tabel.

it will give you nex number, use it as your serial number.

insert data using that number..

hope it will help you..

Regards,

Meet

Re: Automatic counter in database

Former Member — Fri, 30 Jan 2009 06:24:04 GMT

You will save the data along with the counter in PAI.

Because it will be executed after you insert the values and hit a button.

Hope this helps

Regards,

Jayanthi.K

Re: Automatic counter in database

former_member659396 — Fri, 30 Jan 2009 10:20:34 GMT

zxd

Re: Automatic counter in database

ThomasZloch — Fri, 30 Jan 2009 10:29:52 GMT

You don't have to leave nonsense when marking as answered, the comment field is optional.

Thomas