Skip to Content

Update info while using Table Maintenance

Hi All,

I have requirement to update user info and date & time in custom table whoever using Table Maintenance.

ie.

My requirement is if any user updating any table [SAP standard or Custom table] using table maintenance, then

i need to update the user name, date and time into custom table.

Can anbody suggest a solution for this.

Thanks

aRS

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 03:24 AM

    Hi,

    Try this solution...This might work for custom tables..

    Create a new report program..

    Take the table name as a parameter..

    Then get all the contents from the table and store it in a internal table..

    Then call the transaction SM30 with the table name..

    Once they update the table and save..The control will come back to the report program...

    Then again get the values from the custom table..

    Compare the values..If there is any change...Then update your custom table with the user info..

    Thanks,

    Naren

    Message was edited by: Narendran Muthukumaran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 05:48 PM

    You can do this in event 01 - Before saving the data in the database.

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 20, 2006 at 07:47 PM

    Hi folks,

    Can you please give more details about this event 01 , Rob had suggested.

    Thanks

    aRs

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Actually, I'm not sure it's what you want.

      As I understand it, you want to be able to add code to update user information for a custom table, but add that code only once (in SM30 somewhere).

      Events are available in the table maintenance dialogue for individual tables. In other words, you have to be using table maintenance dialogues (I think), and you have to add the code for each table.

      So, do you still want to know about events?

      Rob

  • Posted on Oct 20, 2006 at 05:33 PM

    Hi Naren,

    I am looking for is any userexit i can use for it, ie after updating using SM30 [Table maintenance]

    Thanks

    aRs

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2006 at 05:51 PM

    Hi,

    You may not find a common user exit in SM30..Which will be triggered when you try to update in all the custom tables...As each table will be created under different programs...

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 20, 2006 at 08:12 PM

    Hi Rob,

    Thanks your reply.

    I have 6980 custom tables with table maintenance. by adding code to each table maintenance is difficult from the programming point of view. I am looking for common

    trigger event before or after save OR user exit before or after save.

    Thanks

    aRs

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.