SP_Transaction_Notification Question

[former_member541807]

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-ef5...

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

[Former Member · Accepted solution]

Hi Avelino,

Check the following thread

*Close the thread if issue solved.

Regards

Jambulingam.P

Edited by: Jambulingam P on Aug 27, 2009 10:39 AM

[Former Member]

Hi!

Check this links to know the difference between SET and SELECT

http://vyaskn.tripod.com/differences_between_set_and_select.htm

http://ryanfarley.com/blog/archive/2004/03/01/390.aspx

[former_member541807]

Hello Thanga Raj,

Thanks for the reply. examples are enough to differentiate Set and Select

@ Jambulingam P

Thanks for giving me the link for @list_of_key_cols_tab_del and @list_of_cols_val_tab_del, threads are enough for learning and work around....

Best regardz,

im always having an error when posting its says "Secure Connection Failed!" that causes Double posting....

Fidel