topic Re: SM30 Table entry in Application Development and Automation Discussions

SM30 Table entry

Former Member — Mon, 17 May 2010 04:26:27 GMT

Hi all,

I have created a customised table in se11.For this table i have created table maintanence Generatore and a transaction code.

If we give the transaction we can enter the record there and we can save it.

But there is one automatic increment field.Is it possible to increment this variable whenever a record gets updated by using this table maintanence geenrator.

Re: SM30 Table entry

Former Member — Mon, 17 May 2010 04:37:49 GMT

Hi,

You can done this by using EVENTs in Table Maintainance Gemerator

Use 02 event for this and Increment variable in event.

Regards,

Raghava Channooru

Re: SM30 Table entry

nirajgadre — Mon, 17 May 2010 04:38:03 GMT

Hi,

I guess you need to write the logic in the Flow logic of your table maintenance generator.

Or try to make use of the event in TMG.

Re: SM30 Table entry

Former Member — Mon, 17 May 2010 04:45:22 GMT

Hi,

To do this you can put your code in event '01' - Before saving the data in the database.

In table maintenance generator screen goto Environment->Modification->events from the menu bar.

choose the event 01 Before saving the data in the database and give the name of a form there.

in your form fetch the last value of that field and increment it by 1.

this will help U.

Regards

Dillip

Re: SM30 Table entry

Former Member — Mon, 17 May 2010 05:42:42 GMT

I have written the cod in a subroutine.But how to call this routine.

Whether it will take the parameter which was given for the other fields before saving the entry.

Re: SM30 Table entry

Former Member — Mon, 17 May 2010 05:45:08 GMT

And also how to make that field disable in the transation code.

Because for this the entry will be created automatically.So i need to make this field grey.

Re: SM30 Table entry

nirajgadre — Mon, 17 May 2010 06:12:59 GMT

Hi,

To make the Field gray out in the table maintenance generator need to add the logic in the PBO module of the TMG screen.

Add the Zmodule in this and write the logic to gray out the field.

Re: SM30 Table entry

Former Member — Mon, 17 May 2010 07:13:30 GMT

Hi,

In table maintenance generator screen goto Environment->Modification->events from the menu bar.

choose the event 01 and give your routine number.

To make the field gray out:

goto Environment->Modification->Maintenance screen.

Choose the screen no ->layout and cange the attributes of the field from INPUT FIELD to OUTPUTFIELD.

Regards

Dillip sahoo

Re: SM30 Table entry

Former Member — Mon, 28 Jun 2010 11:46:23 GMT

Thanks