Community
Application Development and Automation 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: 
Read only

Database Trigger in ABAP Program

Former Member

‎2007 Aug 01 10:19 AM

0 Likes
705

Hi experts,

Is it possible to define a database trigger in an ABAP program, to be triggered when the data from a database table is modified?

Thanks,

Nuno Afonso

1 REPLY 1
Read only

VXLozano
Active Contributor

‎2007 Aug 01 10:30 AM

0 Likes
419

I doubt it, but if it's possible, I would NOT use it. Remember the application server assumes the role of the DBMS sometimes, and you will never be absolutely sure if your trigger will be used or not.

You can also define a TRIGGER for your Z-tables using the DBMS, but I will only recommend it if you are using ONLY z-tables. For standard tables, I would look for an alternate method, ie EXITs.

And if it's a Z-Table, you can just control its inputs by permissions (don't allow users to maintain it, just make a dialog to do it, and the dialog program would be the "trigger" guy)