topic Re: Event on Table Update, Insert or Modify. in Application Development and Automation Discussions

Event on Table Update, Insert or Modify.

Former Member — Sat, 04 Aug 2012 19:12:06 GMT

Hi All,

I have a requirement, where I need to execute a particular Z* program on Update, Insert or Modification of a particular Standard Table.

Is there any event or some other way available in SAP System, by which I can achieve this task ?

Please Note that I can not go for SAP Modification or Enhancement of Standard Code.

Thanking You All.

Re: Event on Table Update, Insert or Modify.

madhu_vadlamani — Sun, 05 Aug 2012 06:19:14 GMT

Hi Ankit,

Why you need update standard report with code.What is the business requirement.

Regards,

Madhu.

Re: Event on Table Update, Insert or Modify.

jayrajhareshkumar_joshi — Mon, 06 Aug 2012 07:56:25 GMT

Hi Ankit,

You can use the table maintenance event for the same. please go through below link for more details...

With regards,

Jayraj Joshi

Message was edited by: Thomas Zloch

Re: Event on Table Update, Insert or Modify.

ThomasZloch — Mon, 06 Aug 2012 08:14:59 GMT

This has been asked several times. Not available from "ABAP level", I'm afraid. A similar sort of event must be involved when table logging is activated for a table and DBTABLOG is filled, but this must be controlled through some lower level process somewhere in the kernel or DBMS.

Thomas

Re: Event on Table Update, Insert or Modify.

RaymondGiuseppi — Mon, 06 Aug 2012 08:30:08 GMT

First try to find where SAP updates those tables : usually you should look for update task FMs which execute the update of database (eg. VIQMEL_POST or VENDOR_UPDATE) use SM37, where-used tools on database table, debug or oss/scn search tools. Once the FMs are identified look where they are called, and look for customer-exits, BTE, BAdI or Enhancement in their "vicinity".

I can not go for SAP Modification or Enhancement of Standard Code

If you are not allowed or do not want to use such a solution, there are no such generic database triggers in SAP (AFAIK), only at database manager level.

Another solution could be periodic jobs which analyze the database update from timestamp or change documents (CDHDR/CDPOS). For some database table you could also rely on change pointers creating IDocs (BD61)

Regards,

Raymond

Re: Event on Table Update, Insert or Modify.

Former Member — Wed, 08 Aug 2012 17:59:38 GMT

Hi Madhu,

I have to collect data from three Standard Tables and then I need to update them in my Z* table, which will be used by some other report.

My requirement of updating the Z* table has been fulfilled,

but my PROBLEM is : these Standard Tables contains only the last updated entry and not all, so I can not track out all the changes made in Standard Table.

If I will be able to run my Report ( of updating the Z* table ) every time the Standard Table is getting updated, then I will be able to keep track of all changes done in these Standard Tables.

I can not Schedule my Report ( of updating the Z* table ), because the frequency of Updating the Standard Table is not fixed.

And I can not use Enhancement / Modification, since Client does not want any more Enhancement / Modification in this System.

I hope, I am clear with my requirement now.

Thanking You All.

Re: Event on Table Update, Insert or Modify.

Former Member — Wed, 08 Aug 2012 18:10:11 GMT

Hi Raymond,

Thanks for the help.

I have already got the FM and an Implicit Enhancement Point but can not use it because of restriction imposed by Client.

I have checked Change Pointer Option,but it does not exists for the relevant table fields, so this too ruled out.

Now, I am looking into CDHDR / CDPOS option.

Thanks a lot.