Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SM30 Table entry

Former Member
0 Likes
1,857

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,725

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

8 REPLIES 8
Read only

Former Member
0 Likes
1,725

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

Read only

nirajgadre
Active Contributor
0 Likes
1,725

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.

Read only

Former Member
0 Likes
1,726

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

Read only

Former Member
0 Likes
1,725

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.

Read only

0 Likes
1,725

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.

Read only

0 Likes
1,725

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.

Read only

0 Likes
1,725

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

Read only

Former Member
0 Likes
1,725

Thanks