topic Authorization field value in Application Development and Automation Discussions

Authorization field value

arindam_samanta — Wed, 01 May 2013 09:52:16 GMT

Hi Experts,

Basis team has created one authorization object and created one authorization field for warehouse number. They will assign value to that field.

My question is:

Is there any table to get the authorization field value for that object? or How could I get the value for this authorization field value?

Because I should use that value in my select statement.

Any possible solution will be gratefully accepted.

Thanks & Regards,

Arindam Samanta.

Re: Authorization field value

Former Member — Wed, 01 May 2013 10:06:11 GMT

Hi ,

please check below example

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60d70376-712c-2e10-61ab-c1f3700efee3?QuickLink=index&overridelayout=true&50676319258380

Re: Authorization field value

former_member188827 — Wed, 01 May 2013 10:09:04 GMT

use "Authority-Check" statement in your program to check if user is authorized for the warehouse entered. if sy-subrc = 0, it means he is authorized and you can proceed with select statement otherwise display an error message.

Regards

Re: Authorization field value

Former Member — Wed, 01 May 2013 10:24:21 GMT

I don't think Authorisation Field value is stored in any table.

check

TOBJ ---> Authorization Objects

TDDAT ---> Authorization classes

Re: Authorization field value

Former Member — Thu, 02 May 2013 06:09:14 GMT

Hi Arindam,

If you want to check user authorization then you can directly use the 'Authorization-Check' statement. But if you need to specifically write a query probably UST12 (try UST* tables) should be of your help.

Please check the table and revert if this works out for your requirement.

Regards,

Deepak.

Re: Authorization field value

Former Member — Thu, 02 May 2013 06:39:43 GMT

Hi Arindam,

You shall get the warehouse number using SELECT query from it's master or transaction table and pass it to the AUTHORITY-CHECK statement.

Example:

SELECT SINGLE pernr
        INTO   l_pernr
        FROM   pa0105
        WHERE uname EQ sy-uname AND
               usrty EQ '0001'   AND
               begda LE sy-datum AND
               endda GE sy-datum.

AUTHORITY-CHECK OBJECT 'ZAUTH_HRT' ID 'PERNR' FIELD l_pernr.
IF sy-subrc <> 0.
   MESSAGE 'No authorization' TYPE 'E'.
ELSE.
   MESSAGE 'Congrats! You are authorized' TYPE 'I'.
ENDIF.

Hence, it will automatically check the values in l_pernr with the values in Authorization field.

You can check the values passed to authorization field using the T.code - PFCG

With Regards,

Gurulakshmi

Re: Authorization field value

arindam_samanta — Thu, 02 May 2013 07:38:45 GMT

Hi Deepak,

Thanks for your reply. I checked UST12 table. There is another table: TOBJVORDAT, which also stores the authorization field values.

Regards,

Arindam Samanta.