PFCG

[Former Member]

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

[Former Member]

Hi

What do u really need?

In PFCG those information are stored as autorizations

Max

[Former Member]

Hi Max,

I have to develop report displaying Roles, Userids, Release groups and codes assigned to users

Thanks,

Pratibha

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Max,

In table AUSP there is not field called CLINT.

Regards,

Pratibha.

[Former Member]

Hi

Excuse me: AUSP-ATINN

Max