Skip to Content
0
Aug 27, 2009 at 08:26 AM

SP_Transaction_Notification Question

20 Views

hello all,

have a nice day.

i been able to download the manual for SP_TransactionNotification from this URL

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/e991e2b9-0901-0010-0395-ef5268b00aaf

im learning how to make SP by myself and some questions bothers my mind.

1. what is the difference of SET & Select?

bcoz i found this line in SP_TransactionNotification manual in page 5. "If you are placing code in the SBO_SP_TransactionNotification, please make sure you always go through the u201Cselect @error, @error_messageu201D line at the end, especially in the case where you want the transaction to be considered as successful."

here is a sample of SP,the first one uses SET and the second uses Select, they both work fine

IF (@object_type = '60') and (@transaction_type IN (N'A', N'U'))

BEGIN

IF EXISTS (SELECT T0.Docentry from OIGE T0 Inner Join IGE1 T1 ON T0.Docentry=T1.Docentry where

T1.DocEntry = @list_of_cols_val_tab_del and (T1.u_DEPT is null or T1.u_based =''))

BEGIN

SET @error = 10

SET @error_message = N'Department Must be filled-up!'

END

END

-


IF (@object_type = '60') and (@transaction_type IN (N'A', N'U'))

BEGIN

IF EXISTS (SELECT T0.Docentry from OIGE T0 Inner Join IGE1 T1 ON T0.Docentry=T1.Docentry where

T1.DocEntry = @list_of_cols_val_tab_del and (T0.U_DEPT is null or T0.U_DEPT =''))

BEGIN

Select @error = 10, @error_message = N'Department Must be filled-up!'

END

END

-


im really confused in this part...

2. when should i use @list_of_key_cols_tab_del or when is @list_of_key_cols_tab_del appropriate to be used.

3. when should i use @list_of_cols_val_tab_del or when is @list_of_cols_val_tab_del appropriate to be used.

Best Regards,

Fidel