cancel
Showing results for 
Search instead for 
Did you mean: 

Item Master data authorization for user

Former Member
0 Kudos
422

Hello expert,

My client want item master data authorization for user by Item group wise.Is it possible to give authorization to user on basis of Item group.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member205766
Active Contributor
0 Kudos

Hi Sachin

The only way you can restrict full item master in standard SAP Business one for user or other wise you can restrict via Stored Procedure.

Try the below stored procedure

IF @TRANSACTION_TYPE in ('A','U') AND @OBJECT_TYPE = '4'

BEGIN

IF EXISTS (Select T0.Itmsgrpcod from OITM T0 where T0.ItemCode = @LIST_OF_COLS_VAL_TAB_DEL

and T0.Itmsgrpcod='103' and T0.usersign2 ='4')

BEGIN

     SELECT @ERROR = 10001, @ERROR_MESSAGE = 'You are not authorized to Amend Master data for this Item Group.'

END

END

With Regards

Balaji Sampath

frank_wang6
Active Contributor
0 Kudos

No, it is not possible.

But u can use SP TN to block certain user from modifying data for certain item groups.