Custom table modified

[Pokraka, Michael]

Ouch, that's generally not a good scenario to start with. Normally you'd
find SAP strongly recommending against that due to buffering issues and
whatnots - depending on how exactly the tables are configured it is possible
to end up with inconsistent data. Your question reflects exactly the
situation I'm talking about - how does SAP know the table has changed?
 
It might be worthwhile to look at alternative update methods as there are
many: RFC, IDOC, BAPI it's way more efficient in the long run!
 
Of course if you really have to go down this route, you'd need to get your
application to call an FM explicitly to raise the event after this is done.
You can do this via startrfc, I think SWE_EVENT_CREATE is callable from
outside SAP.
There is one caveat with this: normally, an event is called within the
update task - i.e. receiving an event pretty much guarantees that the
database is committed and everything is in synch. If you call the event
explicitly from outside, you have no guarantee what state the DB is in. ODBC
may talk to Oracle or whatever's underneath SAP, but SAP buffers may still
reflect the old data for some time afterwards.
 
Cheers
Michael
 
 
-----Original Message-----
From: Angelo Besenzoni [mailto:"Angelo
Besenzoni/SAP_CONSULTING%SAP_CONSULTING"@mailnotes.ibm.it]
Sent: 17 October 2002 10:29
To: SAP-WUG at MITVMA.MIT.EDU
Subject: 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
 
------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law.  If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.
 
 =============================================================================