Hi,

I want to put constraint in 'Production Order' session for specific user.
I want user to view orders starting olny with 'AUT'. I do not want user to view other orders.
For this I have created role in session 'Role Data'(ttams2100m000) for specific user.
For this role in 'Table Data Authorisation' (ttams3145m000) session I have put authorisation for specific field data as shown in attached document.
Then I have assigned this role to user through 'User Data' (ttaad2500m000) session.
But still user is able to view all the orders instead of 'AUT' orders.
Pls inform me where I am wrong in assigning authorisation to user.

Regards,
Nirali

Hi,

Replace the Not Between with Greater Than and Less Than.

Reason:-

You are putting the conditions for No Authorization.


i.e. If the condition satisfies, the user will have no authorization. In your case, the condition will never satisfy and hence the user will have full authorization.

See the attachment.

Thanks Bhushan.
But issue resoleved by removing single quotes from values for eg.

pdno not between AUT0000001 and AUT999999.

It worked.

Thanks and Regards,
Nirali

Glad it worked. I just viewed your first post. You required the users to view only the orders in the range. And yes, quotes wont work. The complete field is considered as value.