topic Re: table maintenance generator in Application Development and Automation Discussions

table maintenance generator

Former Member — Thu, 08 Mar 2007 17:17:27 GMT

I had created one table . For that table i created table maintenance generator. Its working fine...

Now , i need to Increment one numeric field automatically while i am creating new entries.. That numeric field should not changed by user.

Whether its possible or not.?

If possible means .. guide me how to do?

Former Member — Thu, 08 Mar 2007 17:21:28 GMT

Hi,

GO to screen painter..SE51..

GIve the program name - SAPL + the function group name that you used to create the table maintenance..

Give the screen number..Press change..

To disable the field..

Go to the layout of the numeric field..In the attributes Un check the Input button..

For automatic increment of the field..

Create a module in PAI..

Then in the module use SELECT MAX ( NUMERIC_FIELD )...to get the last number that was added...

Then use the value to populate the field..

Thanks,

Naren

Former Member — Thu, 08 Mar 2007 17:39:26 GMT

Hello,

if you are in the maint.genertor menu: go to the menu 'Environment'->'Modification'.

There you can add your own changes to modify the process in SM30 according your needs.

Rgds,