Rif: Re: Custom table modified

[Angelo Besenzoni]

thanks...Mike
 
Angelo
 
 
|--------+------------------------->
|        |          "Pokraka,      |
|        |          Michael"       |
|        |          <michael.pokrak|
|        |          a at kcc.com>     |
|        |                         |
|        |          17/10/2002     |
|        |          15.49          |
|        |          Per favore,    |
|        |          rispondere a   |
|        |          SAP Workflow   |
|        |          Users' Group   |
|        |                         |
|--------+------------------------->
  >----------------------------------------------------------------------------|
  |                                                                            |
  |       Per:    SAP-WUG at MITVMA.MIT.EDU                                       |
  |       Cc:     (ccr: Angelo Besenzoni/SAP_CONSULTING)                       |
  |       Oggetto:     Re: Custom table modified                               |
  >----------------------------------------------------------------------------|
 
 
 
 
 
 
If it helps any, the following is a fairly simple and quick to implement
solution which does not require a huge amount of tech knowledge:
Write file to a server,
Use startrfc to call a function module with parameter for the filename
The function module populates the table - and can even set a return code
which can be tested.
 
This is not pretty, but works and will get you up and running in a hurry.
Cheers
Mike
 
-----Original Message-----
From: Angelo Besenzoni [mailto:"Angelo
Besenzoni/SAP_CONSULTING%SAP_CONSULTING"@mailnotes.ibm.it]
Sent: 17 October 2002 15:12
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Rif: Re: Custom table modified
 
 
Ok Michael..
 
you are right, the scenario is not very good..
 
The update method they assume is not compatible with the following process
they
want to manage by workflow..
It's a good idea to drive them to use RFC, IDOC, BAPI.. adn so on...
 
Thanks for your usefull advices.
 
Angelo Besenzoni
Sap Italia Consulting s.r.l.
tel. +39 3351357236
 
 
 
|--------+------------------------->
|        |          "Pokraka,      |
|        |          Michael"       |
|        |          <michael.pokrak|
|        |          a at kcc.com>     |
|        |                         |
|        |          17/10/2002     |
|        |          13.56          |
|        |          Per favore,    |
|        |          rispondere a   |
|        |          SAP Workflow   |
|        |          Users' Group   |
|        |                         |
|--------+------------------------->
 
>---------------------------------------------------------------------------
-|
  |
|
  |       Per:    SAP-WUG at MITVMA.MIT.EDU
|
  |       Cc:     (ccr: Angelo Besenzoni/SAP_CONSULTING)
|
  |       Oggetto:     Re: Custom table modified
|
 
>---------------------------------------------------------------------------
-|
 
 
 
 
 
 
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.
 
 ===========================================================================
==
 
------------------------------------------------------------------------------
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.
 
 =============================================================================