SAP Knowledge Base Article - Preview

3133933 - S_TABU_LIN | How to assign INITIAL authorization values in transaction PFCG

Symptom

You plan to restrict the access to specific table rows with Line-oriented Authorizations, whereby the value of a key field can also be INITIAL. You want to know, how to assign an authorization value for an INITIAL value in transaction PFCG.
Example:

  1000S
  2000S
 1000 P
 10001000PS
 10002000PS MIX
 2000 P
 20002000PS
 DEF OTHER
 LLLL OTHER
1000  C
1000 1000CS
10001000 CP
100010001000CPS
100020001000CPS MIX
2000  C
2000 1000CS MIX
2000 2000CS
20002000 CP
200020002000CPS
ABC  OTHER
KKKK  OTHER
LLLL2000 OTHER MIX


You want to provide display access, for value 2000 or INITIAL for any of the key fields for example. The expected result looks like this:

  2000S
 2000 P
 20002000PS
2000  C
2000 2000CS
20002000 CP
200020002000CPS


FUNCTION 'VIEW_FILL_WHERETAB'

DBA_SELLIST[]

Row   OperatorValue AND_ORTABIX
1VKORG 0GE 0AND4
2VKORG 0LE zzz0OR4
3VKORG 0EQ20000AND4
4WERKS 0GE 0AND3
5WERKS 0LE zzz0OR3
6WERKS 0EQ20000AND3
7BUKRS 0GE 0AND2
8BUKRS 0LE zzz0OR2
9BUKRS 0EQ20000 2


VIM_WHERETAB

Row Line
1  VKORG GE '    '  AND
2 ( VKORG LE ' ZZZ'  OR
3  VKORG EQ '2000'  ) AND
4  WERKS GE '    '  AND
5 ( WERKS LE ' ZZZ'  OR
6  WERKS EQ '2000'  ) AND
7  BUKRS GE '    '  AND
8 ( BUKRS LE ' ZZZ'  OR
9  BUKRS EQ '2000'  )

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

This KBA applies for all SAP Products based on Net Weaver and S4H.

Product

SAP NetWeaver Application Server for SAP S/4HANA all versions ; SAP NetWeaver all versions

Keywords

Define organizational criteria, Leer , KBA , BC-CUS-TOL-TME , View Maintenance Tool , BC-CUS-TOL-IMG , Implementation Guide , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.