Restricting specific value in a filed.

[Former Member]

Hi All,

Please look into the below scenario and suggest an appropriate procedure.

Suppose WERKS field consists of values viz AA01, AA02,BA01,BA02,CA01,CA03.....etc.

If we put * [Star] in WERKS field User will get authorization for all Plants. But we want to restrict User with the authority of a specific plant for example, we dont want to authorize him for Plant BA02.

Is there any method we can restrict him for this specific value and give authority for all plant values except BA02.

Kindly suggest.

[Former Member]

SAP doesn't give the ability to "exclude" in org level fields

You need to list all plants excluding the value you do not wish to provide.

You could use ranges to do this e.g. AA01 - BA01, BA03 - ZA01 etc

[Former Member]

HI Alex,

Thanks for the reply.

But if the list is comparatively large, and we want to restrict 5(example) values which are random and which cannot be easily put in a specific range. Then do we need to mention each and every value in the field. Please suggest.

[jurjen_heeck]

To exclude BA02 you could allow the following ranges:

AA01 - BA01

BA03 - ZZZZ

Not all plants in the ranges have to exist, but this approach may cause trouble when new plants are intorduced to the system. All existing users will automatically have access until the roles are amended. This is an example how the 'easier' route of trying to exclude rather than allow may bite back in the future..

Jurjen

[Former Member]

>

Then do we need to mention each and every value in the field. Please suggest.

Yes, that is correct.

[Former Member]

Thanks for the suggestion.