08-26-2010 9:26 PM
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
08-27-2010 5:03 PM
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
08-26-2010 10:35 PM
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
05-08-2014 12:47 PM
08-27-2010 12:12 AM
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
08-27-2010 5:03 PM
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
08-27-2010 6:46 PM
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
08-27-2010 7:11 PM
Hi all,
Actually I found table DD01V that does give some of the text in the field DDTEXT.
Kathleen
08-27-2010 11:20 PM
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
08-28-2010 2:57 PM
> 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
08-30-2010 1:43 PM
Thank you all for your help.
The table DD04T give me the information.
Cheers,
Yolanda.
08-30-2010 1:57 PM
> For example ACTV T= Activity
How come ACTVT isn't in DD04T, for example... ?
Cheers,
Julius
09-13-2010 6:31 PM
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.
08-03-2011 3:52 AM
10-13-2021 7:30 AM