Skip to Content
0
Former Member
Dec 20, 2012 at 03:04 PM

Restrict user update Item group in Item master data

198 Views

Hi all,

i would like to Restrict user update Item group in Item master data.

I want to allow only manager user to modify the Item group in the item master data.

Please help me modify this TN.

If @object_type='4' and @transaction_type='U'

BEGIN

If Exists

(Select T0.ItemCode from OITM T0 Inner Join AITM T1

On T0.ItemCode=T1.ItemCode

Where T0.ItmsGrpCod<>T1.ItmsGrpCod and

And T0.ItemCode = @list_of_cols_val_tab_del)

BEGIN

Select @error = -1,

@error_message = 'You can not change Item Group'

End

End

Thanks in advance.

Kind Regads,

O.