Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Descritpion of all Authorization fields

Former Member
0 Kudos

Hi,

Could someone let me know which table has the description or long text for all auhtorization fields? For example ACTV T= Activity

Many Thanks,

Yolanda

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Most of the authorization fields text you can get it from DD04T table if you know the associated data element name. For most of the authorization field names also same as data element. For example BUKRS, the table DD04T gives company code.

Venkat

13 REPLIES 13

Former Member
0 Kudos

There is no single table for this because they are defined differently.

If you know the object name, then you can see the technical field names in table TOBJ. This will lead you to table AUTHX but the runtime object (SE11) does not have a check or text table because it is "free" and "translated" via the type of the field.

So... you need to see how PFCG does it --> which will lead you to the function module SAUT_AUTHX_FIELD_GET_INFO (which is language dependent and what you are looking for is in the TEXT export parameter.

Luckily there is an easier way but it is less fun... -> make sure you have regenerated SAP_ALL in SU21 after checking that all objects are included in table PRGN_CUST settings. Then import SAP_ALL into a role and export the expanded role data maintenance tab to a file (e.g. Excel) with the "technical names" turned ON.

If you only want the field texts without their object reference then it is however not very usefull within SAP because you can simply type the fields to the DDIC and get the texts automatically.

A tool outside of ABAP is destined to fail over time (if that is your intention). The main reason is the fact that you don't have a value search help (F4). You cannot use the value ranges of the domains, and you cannot perform input validation.

Not using value helps and input validations are THE most common cause of faulty authorization concepts in my opinion (along with laziness in SU53 and dis-jointed security concepts for development work).

Hope that helps you further but please add some infos about why you want to do this?

Cheers,

Julius

0 Kudos

Thanks for your posting. That is exactly what I was lloking for.

Oliver

mvoros
Active Contributor
0 Kudos

Hi,

ST01 is your friend. You can run SQL trace for transaction where your text is displayed. Sometimes it's hard to get through all tables but you don't need any ABAP skills to do it.

Cheers

Former Member
0 Kudos

Most of the authorization fields text you can get it from DD04T table if you know the associated data element name. For most of the authorization field names also same as data element. For example BUKRS, the table DD04T gives company code.

Venkat

0 Kudos

Hi Venkat,

What we are looking for is the text for the field from the table AGR_1251 - FIELD.

We have found some of the values, but for the majority are unable to find the text table behind.

Kathleen

0 Kudos

Hi all,

Actually I found table DD01V that does give some of the text in the field DDTEXT.

Kathleen

Former Member
0 Kudos

Hi,

Please use AGR_1250 you will get exactly what you need in the column "ATEXT"

put the role names correctly otherwise it will throw blank in that column

0 Kudos

> AGR_1250 you will get exactly what you need in the column "ATEXT"

Are you sure...? How come these texts can be changed?

Cheers,

Julius

0 Kudos

Thank you all for your help.

The table DD04T give me the information.

Cheers,

Yolanda.

0 Kudos

> For example ACTV T= Activity

How come ACTVT isn't in DD04T, for example... ?

Cheers,

Julius

0 Kudos

Hi Julius,

Yes, you are right . Activity is not there, but at least the table helped us with some of the fields we were looking for.

Regards,

Yolanda.

0 Kudos

You can use function module

AUTH_FIELD_GET_INFO

.

Try it!

nidhi_kumari02
Advisor
Advisor
0 Kudos

Please check tcode SU20.