topic re: serial no generation in custom program in Application Development and Automation Discussions

re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 05:24:28 GMT

hello everybody,

in my requirement i have developed a modulepool program through which the end user enters the records into custom table,

for each entry i have designed manual code to generate the serial no of that record and when the user pressed enter (save button) the record will be saved into

custom table with the generated serial no and when the user presses new(custom button) a new serial no will be generated based on previous highest record

every thing is working fine,but my problem was when there are more records to enter , 2 or 3 users trying simultaneously to enter the records , problem was

distinct serial nos r not generating for each user until the first user saved his record.

here my requirement is if multiple users r simultaneously working, each user has to get distinct serial no without saving the first record( first user used ).

can any body plz help me that how can i achieve this.

thanks & regards

mahesh

Re: re: serial no generation in custom program

Aashish28 — Tue, 13 Mar 2012 05:32:44 GMT

Use Transaction SNRO OR SNUM and create number range object by this you will get distinct number ... Remember one thing number should get when user press SAVE by this your number loss probability will be less ... search on SDN for this topic you will get data for this

Re: re: serial no generation in custom program

former_member756927 — Tue, 13 Mar 2012 05:35:10 GMT

Hi Mahesh,

I think you are generating serial no when user clicks on New button. I think you have to Generate your serial No when user clicks on save button with your logic of highest no in custom table.

Mudassar.

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 05:50:07 GMT

thank u ashish for immediate response,

i have tried using number range object while developing this app, problem was

the end users previously uploaded the data for specific periods thru a bdc prog

with the single no for all records , by using snro we can generate a fixed no series(6-saleorder,5-gr)

right?, what my clients r asking is the new no should start from the previuos highest no

and for the next year the no should also repeats so i have used custom code previously

the new no generates when the previous no was saved,now they r asking for distinct no generation

for distinct user without saving the first used user no.

like generation of stas(out bound deleveries or etc..).

can u pls suggest me any links for reference ,how sap is generating serial nos using snro.

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 05:59:47 GMT

yes praniya,

until unless the first user saves his no all the other users r getting the same no

now i need to avoid that and i had to generate distnct no for distinc users without pressing svae.

pls help me.

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 06:19:19 GMT

SNRO transaction uses NUMBER_GET_NEXT Function module to generate the no sequence.

for detail go through the link

http://axsap.wordpress.com/2011/07/05/snro-sequence-number-range-object/.

I suggest you genrate the no on click of save button beacuse it will be very difficult to manage for the multiple user to generate no on click of new because either you have to save it inot a temp var for the particular user and generate the higher no for the othr user using that temp var and then after that once it has saved u hav to replace temp var with the current highest no in custom table. The logic could be complicated.

Re: re: serial no generation in custom program

Aashish28 — Tue, 13 Mar 2012 06:30:08 GMT

Hi Mahesh ,

SNRO LINK -

Link to blocked site removed by moderator

As you write 1) next year the no should also repeats.

2) new no should start from the previous highest no.

As i understand this is your 2 main requirement , But as per condition which you wrote SNRO will not resolve your problem because in SNRO number will get loss if transaction will not completed but you can use it if no loss is not problem you can set your number range as year wise repeated also but just go with my example ,

Your Number - 00002 Year - 2012

Assume 3 users open same transaction they all will get 00003 2012 as next number

You have to make recursion function which will check your generated number in your table at time of save than possibility of saving same number will become less.

all 3 press save than check this function .

This is basic Idea .

Message was edited by: Vinod Kumar

Re: re: serial no generation in custom program

former_member756927 — Tue, 13 Mar 2012 06:43:20 GMT

Dear Mahesh,

Again I suggest you to generate serial no when user clicks on save button.

I don't know whether you want to show serial no to user or not when they entering details for new records.

Because it was difficult to maintain serial no if u want to display serial no. to user when multiple users r simultaneously working.

I suggest you to generate serial no in background with previous highest no when user clicks on save button and display generated serial no in message as " Record No. : "Your Serial No." Saved ".

Regards.

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 07:04:45 GMT

thanks praniya,

i am doing the same the no is generated after pressing the save button only,

req is custom screen contains header data fields and table control for item details.

they enter header details and item check the screen.fgino is automatically generated

Re: re: serial no generation in custom program

former_member756927 — Tue, 13 Mar 2012 08:30:55 GMT

ohk...

Is it mandatory to show FGINO on screen?

If i am not wrong u r using two custom tables to store the data and Generated FGINO in "Headerdetails" is entered into every line of "Itemdetails". Right?

If its not mandatory to show FGINO in "Headerdetails" and "Itemdetails" then your problem can be solved.

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 09:08:32 GMT

hi ,

thanks for reply,

i dont know wether it is mandatory r not but they asked it for reference.

if consider ur suggestion, how multiple users enters the data simultaneously and how the header

and item data r linked.

Re: re: serial no generation in custom program

former_member756927 — Tue, 13 Mar 2012 10:11:10 GMT

I consider that u r using two tables one for header details and one for itemdetails.

when user clicks on save button first of all serial no will be generated and one variable will hold the value of serialno.

after that write two insert statements for saving records in custom tables.

1st statement will be for header details which will be stored in header table.

2nd statement will be for item details which will be stored in detail table.

In header table make FGINO (serialno) primary key field and in item table FGINO (serialno) field as foreign key. this way link between two tables will be created. and ya in item table make itemno field as primary key.

you can take reference of many header and detail tables like EKKO as header table for PO header data and EKPO as PO Irtem Detail Table.

And for reference you can show them FGINO in message as i suggested in earlier post.

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 10:42:37 GMT

I can suggest you to get 'Lock' on the custom table(s) to get the next available number, use it along with year to make it unique, create the records in both the tables, and then release the 'Lock'.

This way you can ensure you always get unique number.

Regards

Raj

Re: re: serial no generation in custom program

Former Member — Tue, 13 Mar 2012 12:39:14 GMT

HI,

use FM 'enqueue_<lockname>',while updating the custom table to with unique key is fyear and then release the lock by using dequeue_<lockname>.

Regards,

Gurunath Kumar