No Authorizations for the User to Remove Iem master data

[Former Member]

Dear All

I have provided a User to add a Item Master data in the SAP B1 but I dont want any one rights to remove it or cancel the item master data . once its created no body has right to remove it. but the issue is if no transactions has not passed in the system releted to the item master data SAP B1 provides the right to remove it. is thier any solutions in the general Authrizxations mode to control this .or some other solutions .

Thanks & Regards

Kisna

[former_member204969 · Accepted solution]

The procedure Petr send is for BP!

Try this one for items:

if @object_type = '4' and @transaction_type in ( 'C','D')
begin
select @error =1
select @error_message = 'You cannot cancel/delete item!'
end

[Former Member · Accepted solution]

Istvan is true, I didnt read your question carrefuly.

[Former Member]

Hi,

you may use sbo_sp_transactionnotification stored procedure to protect the BP for deleting (if nobody cannot delete it). The same way is in this procedure control, if anybody want cancel the BP master data.

This procedure is in sql server and you may modify it.

Petr

[Former Member]

hi Petr,

I am not clear how you would restrict a user from removing an item through stored procedure. Could you please explain it a little more?

Regards,

/Siddiq

[Former Member]

Add into your stored procedure sbo_sp_transactnotification lines

if @object_type = '2' and @transaction_type= 'A'

begin

select @error =1

select @error_message = 'You cannot delete BP

end

if @object_type = '2' and @transaction_type= 'C'

begin

select @error =1

select @error_message = 'You cannot cancel BP'

end

Petr