topic Re: System generated number in Application Development and Automation Discussions

System generated number

Former Member — Wed, 23 Jul 2008 10:00:42 GMT

Hi all,

I m developing a module pool with z table 1 Header & 1 Item table. Now I would like to ask how I can get system generated number for the pk filed supose gate pass number and my filed type is char 10.

When user enter a new entry then system will auto generqte the gpass number .

so pls let me know if any one can help me to do this job.

Thanks in advance.

manju

Re: System generated number

Former Member — Wed, 23 Jul 2008 10:10:29 GMT

Create a number range object using transaction SNRO. You can find all documentation needed on http://help.sap.com.

Regards.

John.

Re: System generated number

former_member200872 — Wed, 23 Jul 2008 10:20:27 GMT

Hi,

A simple solution could be using system date and time to generate a unique number.

Try this:

DATA: V_UNQ(14) TYPE C.

START-OF-SELECTION.

CONCATENATE SY-DATUM+4(4) SY-UZEIT INTO V_UNQ.

WRITE:/ 'Format is - MMDDHHMMSS : ', V_UNQ.

CONCATENATE SY-DATUM2(6) SY-UZEIT(4) INTO V_UNQ.

WRITE:/ 'Format is - YYMMDDHHMM : ', V_UNQ.

CONCATENATE SY-DATUM SY-UZEIT INTO V_UNQ.

WRITE:/ 'Format - YYYYMMDDHHMMSS - is always Unique', V_UNQ.

Regards,

Wajid Hussain P.

Re: System generated number

Former Member — Wed, 23 Jul 2008 11:48:49 GMT

Hi John,

thnx for ur prompt reply. I hv gone thorugh the SNRO but how i know which object will be suitable to my requirement bcoz my filed type is char 10.

so pls let me know the right object or can i create a new one.

manju

Re: System generated number

Former Member — Wed, 23 Jul 2008 11:49:45 GMT

Thnx wajid for your prompt reply and idea abt unique number.

thnx once again.

bye

manju

Re: System generated number

Former Member — Wed, 23 Jul 2008 12:00:06 GMT

Hey Manju,

first pre determine what range your number should be having , like starting from 0000000001 like that or 1000000001 etc, after that :

Scenario 1 ( if you have to show the number as a field on the screen)

write a select query in the PBO of the screen as below

let the field name be gateno.

select max(gateno)

from <dbtab>

into < var1>.

this will fetch the last number and then you can increase it.

if syst-subrc is initial.

var1 = var1 + 1.

endif.

move the value of var1 to the screen field name.

Scenario 2 ( If you just need to update in the database table)

write the above select query in the PAI module of the screen when the user performs some action like SAVE.

Hope this helps,

reward if useful,

Regards ,

Re: System generated number

Former Member — Wed, 23 Jul 2008 13:13:10 GMT

HI RK,

THNX FOR REPLY I WAS DOING THE SAME AS U WRITTEN ONLY I DIDNT SPECIFY THE RANG SO IT WAS NOT GIVING LEADING ZEROS WHILE GENERATIN NUBER BUT NOW FROM UR EMAIL I HV DEFINE THE RANG SO IT'S WORKING FINE.

THNX.

Re: System generated number

Former Member — Thu, 24 Jul 2008 09:07:46 GMT

Hi RK ,

thnx for yesterday solution.

I need your help again.......pls go through this

I m having a char field lenght 1 and input value with eithr 'O' or 'C' .

and another 2 text field for Vendor and Contractor name as a input.

so my Q is @ the time of creating gate pass entry

when user enter 'O' so contrator name text should be disable and when enter 'C' so vendor name should be disable or vice versa.

so what code i should write in module pool and where either in PBO or PAI.

Awaiting for response.

Thanks in Advance.

Manju

Re: System generated number

former_member200872 — Thu, 24 Jul 2008 09:35:55 GMT

Hi,

When the display attributes of screen fields are to be changed, it has to be done in pbo.

Check the code given below.

Regards,

Wajid Hussain P.

* * * *

case p_text1.

when 'O'.

loop at screen .

if screen-name = 'P_CONTRACTOR'.

screen-input = 0.

else.

screen-input = 1.

endif.

modify screen.

endloop.

when 'C'.

if screen-name = 'P_VENDOR'.

screen-input = 0.

else.

screen-input = 1.

endif.

modify screen.

endcase.