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.