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:
1000 | S | ||
2000 | S | ||
1000 | P | ||
1000 | 1000 | PS | |
1000 | 2000 | PS MIX | |
2000 | P | ||
2000 | 2000 | PS | |
DEF | OTHER | ||
LLLL | OTHER | ||
1000 | C | ||
1000 | 1000 | CS | |
1000 | 1000 | CP | |
1000 | 1000 | 1000 | CPS |
1000 | 2000 | 1000 | CPS MIX |
2000 | C | ||
2000 | 1000 | CS MIX | |
2000 | 2000 | CS | |
2000 | 2000 | CP | |
2000 | 2000 | 2000 | CPS |
ABC | OTHER | ||
KKKK | OTHER | ||
LLLL | 2000 | 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:
2000 | S | ||
2000 | P | ||
2000 | 2000 | PS | |
2000 | C | ||
2000 | 2000 | CS | |
2000 | 2000 | CP | |
2000 | 2000 | 2000 | CPS |
FUNCTION 'VIEW_FILL_WHERETAB'
DBA_SELLIST[]
Row | Operator | Value | AND_OR | TABIX | ||||
1 | VKORG | 0 | GE | 0 | AND | 4 | ||
2 | VKORG | 0 | LE | zzz | 0 | OR | 4 | |
3 | VKORG | 0 | EQ | 2000 | 0 | AND | 4 | |
4 | WERKS | 0 | GE | 0 | AND | 3 | ||
5 | WERKS | 0 | LE | zzz | 0 | OR | 3 | |
6 | WERKS | 0 | EQ | 2000 | 0 | AND | 3 | |
7 | BUKRS | 0 | GE | 0 | AND | 2 | ||
8 | BUKRS | 0 | LE | zzz | 0 | OR | 2 | |
9 | BUKRS | 0 | EQ | 2000 | 0 | 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
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.