topic Re: table Maintenance in Application Development and Automation Discussions

table Maintenance

Former Member — Tue, 08 Aug 2006 21:55:28 GMT

Hi friends,

i need to maintaina custom table through custom transaction,at one point when a record is porcessed fully and the status gets changed to 'completed', then the particular row or record should be disabled which implies that the record does not need an updations.

is this possible to do in table maintenance meaning SM30?

Thanks in advance for ur help

Tian wilson

Re: table Maintenance

Former Member — Tue, 08 Aug 2006 21:59:35 GMT

Hi Tina,

From my experience,

it's not possible to achieve using SM30,

Regards,

Mike

Re: table Maintenance

Former Member — Tue, 08 Aug 2006 22:08:22 GMT

You can probably achieve it through events. Go to SE54, enter your table name and in the menu, 'Environment-->Events'.

Read the documentation on it and I think you can use an event that is triggered before selecting the data. In there, you can limit the records selected to only those which are not set to 'Completed' status.

Re: table Maintenance

vivekkrishnan — Tue, 08 Aug 2006 22:23:34 GMT

hi Tina,

How do you identify whether a record is completed or not ?

Re: table Maintenance

Former Member — Tue, 08 Aug 2006 22:31:02 GMT

hi vivek,

i would set a flag 'C' for completion,all the staus would be manually eneterd or updated by the user, so when the user sets or change the flag to 'C', then that particular record should change to uneditable mode.

is thats poosible to do ?

Re: table Maintenance

Former Member — Tue, 08 Aug 2006 22:37:43 GMT

It is possible, You can check this link which give smore details about Table Generator maintenance

http://help.sap.com/saphelp_47x200/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

Message was edited by: Ashish Gundawar

Re: table Maintenance

Former Member — Wed, 23 Aug 2006 14:39:52 GMT

My name is Pam Beran, I'm with BH Solutions Group in Akron Ohio. We located your resume on Jobvertise and tried to reach you via the phone numbers listed. We also emailed you via the resume web site. We are very interested in speaking with you.

We have several SAP opportunities that may be of interest. Please review them at www.bhsolutionsgroup.com. If you are interested, please contact Ben Basnett, our Managing Partner, at 330-666-6970 ext 14 or email basnett@bhsolutionsgroup.com.

Best Regards,

Pam