topic Re: Triggering an event when writing to Database in Application Development and Automation Discussions

Triggering an event when writing to Database

Former Member — Wed, 04 Jan 2012 21:39:06 GMT

Hi,

Does anyone knows a way to trigger some kind of event (some program / function)

when a specific standard table changes?

Thanks,

Doron Oded.

Re: Triggering an event when writing to Database

madhu_vadlamani — Thu, 05 Jan 2012 02:14:25 GMT

Hi Doron,

In general an entry will be created n a table when a record created from standard transaction and for change also.You can try will workflow.Ex:So created,changed,Po displayed, change.Then that even you can use for this.What is the business requirement.

Regards,

Madhu.

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 02:49:17 GMT

Oded,

the range of your question is very wide. can you please tell us what standard table are you interested in and how are you changing it,

1. from a table maintenance --> Yes, table maintenance events are there which trigger here

2. from a tcode like PO, SO changes -> yes, a variety of events trigger depending upon object type

3. from running any program -> depends upon the program

4. a field for which change pointer is active -> yes, change document write is called.

so please specify what exactly is your requirement

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 06:01:37 GMT

Hi,

Thanks for your answers.

I know the question is quite general...

The requirement is to trigger a program whenever somw tables changes..

But they don't want to be depend a UE or a specific program.. But a general DB table change.

So, from all the options you mentioned table maintenance event sound the most promising..

What is that? could you elaborate a bit?

Thanks again,

Doron Oded.

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 06:15:07 GMT

Search.. follow this link.

http://www.sdn.sap.com/irj/scn/advancedsearch?query=tablemaintenanceevents

this explains maintenance view events. but know that this is only when you create data from SM30. its not for any where else.

and about being generic.. WONT help.

UPDATE statement as such wont trigger any event.. so it depends upon where the Update is written, according to that you can look for the events you are talking about

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 06:25:54 GMT

Hi friend,

You can do like this check the CDHDR and CDPOS table.

From the CDHDR table you will get CHANGENR, OBJECTID and OBJECTCLAS values passing these values to CDPOS, then you will be getting VALUE NEW and VALUE OLD.

So check whether your table is changed and with the help of TMG events or using the driver program where you are checking for the changes call the other program which you want to call.

I think this is much clear if you still face issues please revert back to me i will help you.

Thanks,

Sri Hari

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 17:50:53 GMT

Hi,

Change documents (CDHDR, CDPOS) could be a solution for this issue. But what about tables which are not change documents managed?

And what is TMG event? and driver program? Could you please elaborate about them a bit more? or tell me where can I find more documentation?

Thank a lot!!

Doron.

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 17:53:27 GMT

TMG - table maintenance generator - the sm30 thing which i told earlier

and the CDPOS/CDHDR wont get updated automatically. for that also you need to check if the fields are logged or not.

you can activate table logging, but it will activate for all the tables

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eaf9446011d189700000e8322d00/content.htm

Edited by: Soumyaprakash Mishra on Jan 5, 2012 11:25 PM

Re: Triggering an event when writing to Database

madhu_vadlamani — Thu, 05 Jan 2012 17:54:05 GMT

Hi Doro,

TMG nothing but table maintenance generator.

Regards,

Madhu.

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 20:04:22 GMT

Hi,

OK, thats sounds not bad at all.. 2 questions:

1. If we activate Logging (change docs..), will all the tables be included or only a part?

2. How would we know a change has occured? should we scan the table periodically for changes? or is there some trigger/event?

Thanks again, you all are great!

Doron.

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 20:35:42 GMT

There is the catch... there are 3 things which can be done for table logging

1. system wide(all clients)

2. specific clients(better) -->this one you can go for if you want to

3. no logging

so, this is gonna activate for all tables.

the change can be checked though regular monitoring of SCU3. you can pull out a report and stuff from it.

Re: Triggering an event when writing to Database

ThomasZloch — Thu, 05 Jan 2012 22:12:40 GMT

To clarify, it takes the setting of rec/client AND the activation of logging for each table in its technical settings to actually activate the logging in table DBTABLOG (not CDHDR/CDPOS, that's something else), so it does not affect all tables.

And no, I don't know of any generic trigger that you can react on within an ABAP context after DB table entries have changed, irrespective of how they were changed.

The functionality that creates the entries in DBTABLOG must be somewhere down in the kernel or database.

Thomas

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 22:40:18 GMT


The functionality that creates the entries in DBTABLOG must be somewhere down in the kernel or database

Yes. Database layer

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 22:58:39 GMT

Hi,

When you say "you have to enable it for each table"..

where this should be done?

And, does it require a change request?

Thanks again,

Doron.

Re: Triggering an event when writing to Database

Former Member — Thu, 05 Jan 2012 23:03:13 GMT

in technical setting(in se11) for any table you will find this logging activated flag. only if the logging flag is set then only you can trace it though SCU3.

go though this link for details

http://help.sap.com/saphelp_nw04/helpdata/en/7e/c81ebb52c511d182c50000e829fbfe/content.htm

Edited by: Soumyaprakash Mishra on Jan 6, 2012 4:35 AM

Re: Triggering an event when writing to Database

Former Member — Fri, 06 Jan 2012 07:54:14 GMT

My friends,

I'm affraid this is not quite answering my question.. appearantly..

Because this is not a general enough solution, I've checked for example if tables EBAN, and MSEG are logging-enbaled in standard, and I was very dissapointed to see that they are not..

If I need an access key to change these kind of most basic logistics tables, this is the wrong solution.

So, I hope you won't be upset with me if I'll take our wonderfull discussion a bit back, and ask again,

is there a simple way to trigger some program when tables change?

The change could be from any program - SM30, or MIGO, or ME52n... Hence, it (the way) should not be based on the updating program (via UE), It should not require access keys for changing standard table settings..

Thanks again, and I appologize for my stubbornness,

Doron.

P.S: Have a lovely weekend.

Re: Triggering an event when writing to Database

Former Member — Fri, 06 Jan 2012 09:00:34 GMT

again, you need to specify what are you changing.

say its from SM30, that means you are not changing transactional data(EBAN,EKPO hold transactional data). the data might be some master data or config data.

moreover, if its a customizing table then you will have logs by default, else you need to use maintenance events.

say it from ME22n, ME52n etc. that mean you are changing business documents, mostly these are logged in CDPOS/CDHDR. just like when you click environment->item changes in me23n, it actually reads from CDPOS and CDHDR. you can monitor these tables.

and yes, its a business document means it has a BOR object, BOR object has events like CREATE,CHANGE,DELETE etc etc.. with these event you can link workflows in SWE2. So, when ever any of these events trigger your workflow can trigger and you can put any logic. lets say for PO change you want to do some task, so for BUS2012, change event, you will link a WF. and inside the WF you can do the code..

Re: Triggering an event when writing to Database

ThomasZloch — Fri, 06 Jan 2012 14:34:05 GMT

The general solution you are looking for is not available, to my knowledge.

EBAN and MSEG are not logged, because they are tracked via change documents (CDHDR/CDPOS) by the application.

Thomas

Re: Triggering an event when writing to Database

Former Member — Sat, 07 Jan 2012 21:39:00 GMT

Hey guys,

It seams reasonable to check CDHDR and CDPOS in order to track changes to business objects.. But. There are some very important tables that are not documented there.. The most obvious example is MSEG.. It has no change documents management..

So, does any of you know any other method of triggering a program when tables change?

Thanks,

Doron.

Re: Triggering an event when writing to Database

Former Member — Sat, 07 Jan 2012 22:11:14 GMT

you can go for MB_DOCUMENT_BADI. this badi triggers when a material document is posted.