2006 Jul 09 6:13 AM
Hi All,
Which table stores the release groups and codes for roles?
Transaction code PFCG
As well release strategies classification (Total Net Order value). Transaction code OMGS.
Thanks,
Pratibha
Hi All,
Which table stores the release groups and codes for roles?
Transaction code PFCG
As well release strategies classification (Total Net Order value). Transaction code OMGS.
Thanks,
Pratibha
2006 Jul 09 7:25 AM
Hi
What do u really need?
In PFCG those information are stored as autorizations
Max
2006 Jul 09 8:23 AM
Hi Max,
I have to develop report displaying Roles, Userids, Release groups and codes assigned to users
Thanks,
Pratibha
2006 Jul 09 9:12 AM
Hi
You can find out the roles from the table AGR_USERS and use the fm SUSR_AUTHORITY_CHECK_SIMULATE for Release groups and codes.
The authority object should be M_EINK_FRG, so u can use a code like this:
LOOP AT T_USER.
LOOP AT T_T16FC.
VAL1 = T_T16FC-FRGGR.
VAL2 = T_T16FC-FRGCO.
CALL FUNCTION 'SUSR_AUTHORITY_CHECK_SIMULATE'
EXPORTING
USER_NAME = T_USER-BNAME
OBJECT = 'M_EINK_FRG'
FIELD1 = 'FRGGR'
VAL1 = VAL1
FIELD2 = 'FRGCO'
VAL2 = VAL2
IMPORTING
SY_SUBRC = RC
EXCEPTIONS
NOT_AUTHORIZED = 1
USER_NOT_EXISTS = 2
INTERNAL_ERROR = 3
OTHERS = 4.
IF SY-SUBRC = 0.
*----> The user is ok
ENDIF.
ENDLOOP.
ENDLOOP.
max
2006 Jul 09 10:20 AM
Thanks for your reply.
Please help me with release group /code classification data (as below).
Characteristic Description: Total net order value
Value - 30000USD
Thanks
Pratibha
2006 Jul 09 2:11 PM
Hi
You need to read these tables:
- Table AUSP with MAFID = O
CLASSTYPE = '032'
object = <Strategy>
- TABLE CAWN/CAWNT using AUSP-CLINT and AUSP-ATZHL
Max
2006 Jul 10 11:33 AM
Hi Max,
In table AUSP there is not field called CLINT.
Regards,
Pratibha.
2006 Jul 11 12:31 AM
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |