Skip to Content
author's profile photo Former Member
Former Member

entries in ztable

Hi all,

I have a ztable created. My requirement is like whenever new entries are created or existing entries are modified, this information should be tracked in the program, like which fields are changed etc. How can I do this.. can anyone please tell me.

There is a table maintenance generator created and tcode created for this table. will this help us to proceed in any way.

<REMOVED BY MODERATOR>

Thanks & Regards,

Saroja.

Edited by: saroja ponnam on Jan 23, 2008 4:33 PM

Edited by: Alvaro Tejada Galindo on Jan 23, 2008 11:42 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 05:25 PM

    Hello Saroj,

    1)Go to SE11.

    2) In UTILITIES select TABLE MAINTANENCE

    3)ENVIRONMENT select EVENTS.

    4)Select any one of the relevant events for example

    02--after saving a data.

    5)create a Subroutine for this event.

    Inside this subroutine create your customized code.

    There are Fields(strings) like EXTRACT--which will have the new entries....U can also check TOTAL Field(string) which will

    have the row selected incase you need to delete the data.

    <REMOVED BY MODERATOR>

    Edited by: Alvaro Tejada Galindo on Jan 23, 2008 12:51 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Could U please send some details regarding field strings in the table maintenance generator. EXTRACT field string and TOTAL field strings are not handling the created and deleted records.

      If U give some details it will be very helpful to me.

      Thanks in advance.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 03:22 PM

    Hi,

    Do one thing, you can prepare one custom program in that program you extract all the records from custom table and save in a local file. After modifing the table entries you again execute the same program and in the program you need to extract the records(after modification) into internal table and upload the data from local file as we already saved before change. Now we have 2 internal tables with data now you can compare those 2 tables by using FM CSVB_COMPARE_TABLES in returns 3 tables one for new records and other for modified records details and last one for deleted entries, then after you can prepare one output and display all the details as you want.

    I dont say this is the only way to do this, but i know this because i had done this kind of work in my previous experience.

    Hope this will help you.

    Rgds,

    Bujji

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 03:25 PM

    Hi Saroja:

    I have something similar for which we schedule background jobs. I have couple of tables and whenever a record is inserted or modified we log some some kind of STATUS in another LOG table. For exampe I have Z1 and if a new record is inserted, I log status for example "C" in my ZLOG table. I have Z program that is scheduled to run every hour and it looks at ZLOG table for any changes based on the status and creates an output file. Hope this idea helps.

    Mithun

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2008 at 03:40 PM

    Hi,

    switch on "log data changes" in the technical settings of your z-table.

    After that, you will able to display any changes to the table entries via transaction SCU3.

    The changes are stored in table DBTABLOG.

    Greetings

    Thomas

    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.