Stored procedure notification on UDT table

[Former Member]

Hi

   Can we create Stored Procedure Notification on UDT table . If Code of UDT table (TEMP) exists in TEMP1 or TEMP2 also UDT tables it should not be able to delete that record from TEMP table.

Thanks

[KennedyT21]

Hi Sunny Brar...

Yes, It is Possible to create TN SP for the UDT...

Regards

Kennedy

[Former Member]

Hi Kennedy

   Can u please help me for the above solution

Thanks

[KennedyT21]

Hi Sunny Brar..

IF @transaction_type IN ('A','U') AND @object_type = '-3'

BEGIN

IF EXISTS

     (

select T0.Code from [@u_udt] T0 where

(T0.Code = @list_of_cols_val_tab_del  ) and t0.code in ( select code from temp)

       )

BEGIN

SELECT @Error = 1, @error_message = 'xxxxx'

END

END

The above is the sample change according to your tables and try..

Hope Helpful

Regards

Kennedy

[KennedyT21]

Hi Sunny

Also your user table must be created as Data Master. Once done you go to the registration of objects and assigns an ID. Once you complete the registration of this object, you will not see in the list of user tables but you'll see in the list of objects, ie, in the Forms option by default.

Hope Helpful

Regards

Kennedy

[KennedyT21]

Hi Sunny....

Check with the Link for How to use TN SP

http://scn.sap.com/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-proce...

Hope Helpful

Regards

Kennedy

[Former Member]

Hi Edy

   I forgot to mention , i have UDT with no object . Will this work with the above SPN

Thanks

[KennedyT21]

no dear you have to register....

[KennedyT21]

no dear you have to register....