Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Authorization for remove Bom

Hi All,

Is there a way using SP Stored Procedure to stop users from removing BOM ? But just someone can remove the BOM the others can't.

I have already try SBO_SP_TransactionNotification something like this:

DECLARE @User Nvarchar(8) 

IF @object_type='66'   
BEGIN

   SELECT @user=T1.USER_CODE 
      FROM OITT T0 LEFT JOIN OUSR T1 ON T0.UserSign2 = T1.USERID
     WHERE T0.Code=@list_of_cols_val_tab_del

  IF @user='manager'
   BEGIN

       IF @transaction_type='D'
        begin   
          set @error=1
          set @error_message=N'You can't delete the BOM'
        end

    END

END

But it can't work!!! How can I do?

Thanks in advance,

Vanessa

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question