AW: Custom table modified

[Nathan Fox]

Hello
 
If everything took place from within SAP things would be a bit easier.  Your
requirements, however, include an update from outside the SAP system by a
foreign system.  This means you must be very rigorous in programming
properly your LUW (logical unit of work), with commit work, and rollback
work scenarios.
 
This is typically a BAPI scenario.  BAPI allows non-SAP systems to update
the SAP databank in a consistent manner.  BAPI services include
"BAPI_COMMIT" and "BAPI_ROLLBACK" to ensure databank consistency.
 
Your BAPI is actually not very complicated, the scenario might look like
this :
 
The custom BAPI must call a custom update function "in update task" where
the actual update of the databank takes place.  If the update is successful
you call the SWE_EVENT_CREATE triggering the custom-event of your custom
business object.  After calling the custom BAPI the non-SAP system must call
also the "BAPI_COMMIT" service function, or the "BAPI_ROLLBACK" service if
errors occured.  Only when the commit work service is called will the actual
databank update and event trigger take place.
 
good luck
Nathan Fox
Switzerland
++41 79 427 31 37
 
 
-----Ursprungliche Nachricht-----
Von: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU]Im Auftrag von
Angelo Besenzoni
Gesendet: Donnerstag, 17. Oktober 2002 11:29
An: SAP-WUG at MITVMA.MIT.EDU
Betreff: Custom table modified
 
 
Hello workflow's users...
 
In our system there is an external application that directly write on a Sap
custom table.
I think there is an SQL via ODBC... or something similar...
 
My problem is to activate an event when that external application writes on
Sap
custom table...
 
Any ideas would be very welcome.
 
we are in 4.5B.
 
Tanks..
 
Angelo Besenzoni
Sap Italia Consulting s.r.l.
tel. +39 3351357236