| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/T_ALRT_ROLE | Role <-> Recipient | 5 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
2 | /PERSONAS/ROFLAS | Personas : ROle FLavor ASsignments | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
3 | /PERSONAS/ROFLSH | Personas : ROle FLavor SHaring | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
4 | /PERSONAS/ROLES | Personas : Role Ranks | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
5 | /PERSONAS/ROTHAS | Personas : ROle THeme ASsignments | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
6 | /SYCLO/SC001 | Syclo Security Check Profile | 7 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
7 | /XFT/REG_APARR | APAR - Roles | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
8 | /XFT/REG_SPVAR | SPVA - Roles | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
9 | BBPC_SUS_UM_RSYS | SUS: Replication Systems for Users Created in SUS UM | 6 | AGR_NAME | Role to be Created in External System | nvarchar | 30 | 0 | | |
10 | BBPC_SUS_UM_RSYT | SUS: Replication Systems for Users Created in SUS UM | 4 | AGR_NAME | Role to be Created in External System | nvarchar | 30 | 0 | | |
11 | BBP_ATTR_ACCESS | Attribute Access Mode | 4 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
12 | BBP_MENU | User-Specific Start Menu | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
13 | GRACRTROLELOG | Log of user reason for profile gen with conflicts | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
14 | RSDMDM_IOBJ_AGR | Customizing for Master Data Maintenance | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
15 | RSDMDM_IOBJ_DTLS | Customizing for Master Data Maintenance | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
16 | SMI_ROLE_SGASSGN | Role Search Group Assignment | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPABAP Authorization and Role Management |
17 | AAACD1 | Standard Change Documents Table (Not Used) | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
18 | AAACD2 | Standard Change Documents Table (Not Used) | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
19 | AAA_KEYS | SAP Authorization Assistant - Definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
20 | AAA_ROLES | SAP Authorization Assistant - Roles Managed by Tool | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
21 | AAA_ROLES2 | SAP Authorization Assistant - Roles no longer Managed | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
22 | AAA_USERS | SAP Authorization Assistant - Definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
23 | AAA_VALUES | SAP Authorization Assistant - Values | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
24 | AAF_ROLES | SAP Authorization Assistant - User-Specific Favorites | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
25 | AAT_ROLES | SAP Authorization Assistant - Definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
26 | AAT_USERS | SAP Authorization Assistant - Definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
27 | AAT_VALUES | SAP Authorization Assistant - Values | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
28 | AGR_1016 | Name of the activity group profile | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
29 | AGR_1016B | Name of the activity group profile | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
30 | AGR_1250 | Authorization data for the activity group | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
31 | AGR_1251 | Authorization data for the activity group | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
32 | AGR_1252 | Organizational elements for authorizations | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
33 | AGR_1253 | Authorization Data for Activity Group - Static Objects | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
34 | AGR_AGRS | Roles in Composite Roles | 2 | AGR_NAME | Composite role | nvarchar | 30 | 0 | | |
35 | AGR_AGRS2 | Role definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
36 | AGR_ATTS | Role attributes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
37 | AGR_BUFFI | Internet Links for a Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
38 | AGR_BUFFI2 | Internet links table - Customer version of SAP roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
39 | AGR_BUFFI3 | Internet links table - SAP versions of SAP roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
40 | AGR_CUSTOM | Role Customizing objects | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
41 | AGR_DEFINE | Role definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
42 | AGR_FAVOS | Personal settings for PFCG | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
43 | AGR_FLAGS | Role attributes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
44 | AGR_FLAGSB | Role attributes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
45 | AGR_HIER | Table for Structure Information for Menu | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
46 | AGR_HIER2 | Menu structure information - Customer version of SAP roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
47 | AGR_HIER3 | Menu structure information - SAP version of SAP roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
48 | AGR_HIERT | Role menu texts | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
49 | AGR_HIERT2 | Role menu texts - Customer version of SAP objects | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
50 | AGR_HIERT3 | Role menu texts - SAP Original | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
51 | AGR_HIER_BOR | Table for Object-Oriented Navigation (OBN) | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
52 | AGR_HPAGE | Role Home Page | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
53 | AGR_HPAGET | Description of the Home Page for a Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
54 | AGR_INFO | Filter Values from Generation Run | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
55 | AGR_LOGSYS | Logical system | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
56 | AGR_LSD | Role attributes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
57 | AGR_MAPP | MiniApps in Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
58 | AGR_MINI | MiniApps in Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
59 | AGR_MINI2 | MiniApps in Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
60 | AGR_MINIT | Role mini-appl texts | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
61 | AGR_MINIT2 | Role mini-application texts | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
62 | AGR_OBJ | Assignment of Menu Nodes to Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
63 | AGR_PROF | Profile name for role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
64 | AGR_SELECT | Assignment of roles to Tcodes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
65 | AGR_TCDTXT | Assignment of roles to Tcodes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
66 | AGR_TCODE3 | Assignment of roles to Tcodes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
67 | AGR_TCODES | Assignment of roles to Tcodes | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
68 | AGR_TEXTS | File Structure for Hierarchical Menu - Customer | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
69 | AGR_TIME | Time Stamp for Role (Menu, Profile, Authorizations) | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
70 | AGR_TIMEB | Time Stamp for Role (Profile Generation) | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
71 | AGR_TIMEC | Time Stamp for Role (User Assignment) | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
72 | AGR_TIMED | Time Stamp for Role (Profile Comparison, RFC Distribution) | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
73 | AGR_USERS | Assignment of roles to users | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
74 | AGR_USERT | Assignment of roles to users | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
75 | CD1016 | Role Profile Name | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
76 | CD1251 | Authorization Data for Role | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
77 | CD1252 | Organizational elements for authorizations | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
78 | FAVO_ROLES | Favorites for roles in PFCG | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
79 | PRGN_SSM | Permitted menus for the Session Manager for role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
80 | ROLE_INAK | Inactive roles buffer | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
81 | ROLE_INAKT | Inactive roles buffer | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPAccounting - General |
82 | TFC_INST_ITEM | Administration of a Job (Report/Transaction or Workflow) | 32 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
83 | TFC_TEMPL_ITEM | Administration of a Job (Report/Transaction or Workflow) | 32 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPApplication Framework |
84 | USMD2001 | Personalization: Default Data Model | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
85 | USMD2003 | Personalization: Default UI Model for Each Data Model | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
86 | USMD2005 | Personalization: Role-depend. Personalization per Data Model | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPBasis Technology R3 |
87 | /ISDFPS/SYS_LSCP | System Landscape for the Distribution of Users | 4 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPBusiness Consolidation |
88 | UCMP040 | Global Parameters: Roles with Authorization Check | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
89 | UCUM020 | Assignment of Cutoff Tasks to User Role | 5 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
90 | UCUM04C | Favorites in Web Dynpro Monitor | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
91 | UCUM04T | Favorites in Web Dynpro Monitor | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
92 | UCUM060 | Reports in Web Dynpro Monitor | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
93 | UCUW001 | SAP Cons.: Personalization Workbench: Object Lists | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
94 | UCUW011 | SAP Cons.: Personalization Workbench: Object Lists | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPClinical System |
95 | N1DCS_AGR_RANGE | DCS: Quick Entry of Settings for Roles (Ranges) | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
96 | TN1PRECCONFUSERA | i.s.h.med: Patient Record, User-Configuration Assignment | 5 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPCommunication Services Mail, Fax, SMS, Telephony |
97 | BCST_RO | BCS: Folders for Semantic and Technical SAP Role Keys | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPCross-Application Components |
98 | TWPLROLES | Workplace Roles | 3 | AGR_NAME | Role (Release 4.5 and Above) | nvarchar | 30 | 0 | | |
99 | TWPLROLEUS | Assignment of Workplace Roles to Users | 10 | AGR_NAME | Role (Release 4.5 and Above) | nvarchar | 30 | 0 | | |
TOPDistributed System Landscape |
100 | /ISDFPS/DIST_AGR | User Distribution Additional Roles | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPEnd User Technology |
101 | RSZW_MINI_URL | Conversion: URLs for MiniApps | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
102 | RSZW_ROLE_URL | Conversion: URLs for Roles | 1 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPGRC Access Control Plug-In |
103 | /GRCPI/GRIA_LOCK | For RT loacking | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
104 | /GRCPI/GRIA_ROLD | Risk Terminator Role Old image | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
105 | /VIRSA/RTROLELCK | Risk Terminator Role Lock | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
106 | /VIRSA/RTROLELOG | Log of user reason for profile gen with conflicts | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
107 | /VIRSA/RTROLEOLD | Risk Terminator Role Old image | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
108 | /VIRSA/ZMITROLE | Mitigating Control - Role | 4 | AGR_NAME | Roles | nvarchar | 30 | 0 | | |
TOPPatient Accounting |
109 | NWVIEW_W01 | IS-H: Workplace - View Type W01 - MiniApp Reports | 4 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPPatient Management |
110 | NWPLACE_AD1 | IS-H: Clinical Process Builder - Personal Settings | 4 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
111 | NWPUSZ | Work Environment-to-User (Role) Assignment | 4 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
112 | NWPUSZT | Work Environment-to-User (Role) Assignment | 5 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
113 | NWPVZ_USZ | IS-H / IS-H*MED: Work Environment-to-Service View Assignment | 7 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
114 | TN1TC_RESP_ROLE | Treatment Contract - Assignments of OU Jurisdiction to Roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPProject Management |
115 | DPR_APPL_VIEW | Application Views When Accessing Project Management | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPRecords and Case Management |
116 | RMPS_DESK_MOD | Work Areas Available | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPRole Generator |
117 | /ISDFPS/AGR_DEF | Role Definitions for the Role Generator | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
118 | /ISDFPS/AUTH_BCK | Original Data of the Deactivated Authorizations for Roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPSAP Business Workflow |
119 | SWLIAG | Workflow Inbox Setting for Role | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPSAP Query |
120 | AQRLASS | Role Assignment of InfoSet Query Call-up | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPSAP Records Management |
121 | RCM_ORG_QACT_PRA | RCM Organizer: Quick Action: Profile <-> Role Assignment | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
122 | RCM_REC_TAFP | RCM Record: Function Profile <-> Role Assignment | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
123 | SRMORGRL2 | BC-RM : Roles (new) | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
124 | SRMORGRL2T | Text Table: View Elements | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
125 | SRMORGROL | SRM View Generator : Role Definition | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
126 | SRMORGROLT | Text Table for View Definition | 3 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPUser Administration |
127 | WP3ROLEAGR | Portal Roles: Assignment to Authorization Roles | 4 | AGR_NAME | Authorization Role | nvarchar | 30 | 0 | | |
128 | WP3ROLEHIER | Role Data Read from Child Systems for User Assignment | 4 | AGR_NAME | Authorization Role | nvarchar | 30 | 0 | | |
TOPUser and Authorization Management |
129 | TUTYHLP | Mass Maintain Price Categories | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
130 | USLA04 | CUA: Assignment of Users to Roles | 4 | AGR_NAME | Name of role in distribution model | nvarchar | 30 | 0 | | |
131 | USRSYSACT | CUA: Roles in Distributed Systems | 3 | AGR_NAME | Name of role in distribution model | nvarchar | 30 | 0 | | |
132 | USRSYSACTT | CUA: Roles in Distributed Systems | 4 | AGR_NAME | Name of role in distribution model | nvarchar | 30 | 0 | | |
TOPWD ABAP Page Builder |
133 | CHIP_PFCG_MAP | Assignment of Page to PFCG Menu Entry | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPWeb Channel User Management and Customer Profile |
134 | COMC_WEC_AGR_D | Web channel: Web Descriptions for web channel UA Roles | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
135 | COMC_WEC_UA_AGR | Web channel: User Management Possible Activity Groups | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPWorkbench |
136 | UGWB1101 | FIN Workbench: Personalization - General Settings | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
137 | UGWB1201 | FIN Workbench: Personalization - General Settings | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPWorkforce Management Application |
138 | WFAC_APPL_UI_CFG | WFM Application UI Configuration | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |
TOPWorkforce Management Core |
139 | WFMC_APPL_UI_CFG | WFM Application UI Configuration | 2 | AGR_NAME | Role Name | nvarchar | 30 | 0 | | |