Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

RAISING AN EVENT WHEN DATABASE TABLE UPDATES

Former Member

‎2005 Jul 24 1:58 PM

0 Kudos
767

hi all,

i want to raise an event when database table updates.For eg : if a price of a material has been changed then i have to raise an event and run the abap program in back ground.i know transaction SM62 to create event, i dont know about transaction SM64. please give me the procedure how to solve this problem. i dont know work flow. please give me a sample code how to raise event.

thanka and regards

suresh

2 REPLIES 2

athavanraja
Active Contributor

‎2005 Jul 24 2:04 PM

0 Kudos
234

check out these threads

Regards

Raja

Former Member

‎2005 Jul 25 1:04 AM

0 Kudos
234

Hi Suresh

It is important to understand that the SAP architecture abstracts the database from the application.

I think that you should look for ways that the application triggers an event when an update has taken place, rather than the DB.

Two ways of doing this that spring to mind are change pointers (for the ALE interface, see menu SALE) and Business Transaction Events (various things including CRM integration, see menu FIBF).

The latter works very well for sending prices to CRM when they change. I am more familiar with this than ALE so I will discuss it.

If you go to menu FIBF and then follow menu path Environment -> Info System (P/S), and then run the report for event 00503301, you can find documentation and a sample function module that you can copy.

Once you register your new function module in the event tables then it will be called when prices are changed.

Cheers

Dom