catching system events

[Former Member]

Hi All,

in the various reciept forms after clicking the OK button it gives me a messagebox and when i click ok it writes journalentries.

my questions is this:

1. can i know when the system added the journalentries?

is there an event that tells me that?

2. can you tell me how to create udf and link it to

those entries?

i need to add some more journalentries write after that.

thanks

[Former Member · Accepted solution]

Hello Ronen,

You can catch all the event in SAP through SBO_SP_TransactionNotification stored procedure. Use this example and run it in MS SQL Analyzer or any application which can run the SQL.

/* add table */

CREATE TABLE [SAP_Transactions]

(

timstamp datetime

DEFAULT CURRENT_TIMESTAMP,

object_type varchar(20),

transaction_type nchar(1),

num_of_cols_in_key int,

list_of_key_cols_tab_del varchar(255),

list_of_cols_val_tab_del varchar(255)

)

GO

Then

insert into [SAP_Transactions]

(object_type, transaction_type, num_of_cols_in_key, list_of_key_cols_tab_del, list_of_cols_val_tab_del)

values

(@object_type, @transaction_type, @num_of_cols_in_key, @list_of_key_cols_tab_del, @list_of_cols_val_tab_del)

This will list all the event happen in SAP. Hope this helps.