cancel
Showing results for 
Search instead for 
Did you mean: 

SP_Transaction_Notification Question

former_member541807
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member541807
Active Contributor
0 Kudos

im sory..its duplicated Thread.

Fidel

Former Member
0 Kudos

Hi Fidel,

You posted the same question in Two thread so close the one of the thread

Regards

Jambulingam.P

Former Member
0 Kudos

Hi!

It is a Duplicate thread, please close this and follow the Original.