| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/C_DM_ABROL | Partner types for Assignment Based Resource Selection | 3 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
2 | /MRSS/D_PARTNR_H | Partner for Demands Header | 3 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
3 | /MRSS/M_MAPROLE | Mirror for Mapping of R/3 partner roles | 4 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
4 | /OPT/X040 | Document Type Roles | 6 | ROLE_TYPE | Role Resolution Type | nvarchar | 1 | 0 | | |
5 | /OPT/Y040 | Document Type Roles | 6 | ROLE_TYPE | Role Resolution Type | nvarchar | 1 | 0 | | |
6 | /OPT/Z040 | Document Type Roles | 6 | ROLE_TYPE | Role Resolution Type | nvarchar | 1 | 0 | | |
7 | /XLSO/REF_ROLE | Table Containing Roles of Reference users | 2 | ROLE_TYPE | Function of the Person | nvarchar | 2 | 0 | | |
8 | /XLSO/REF_USER | Reference User details | 2 | ROLE_TYPE | Function of the Person | nvarchar | 2 | 0 | | |
9 | GRACBUSROLESNAP | Business Role Snapshot | 7 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
10 | GRACMGRISKD | Risk Analysis Mgmt Sum data for Batch Risk Analysis. | 5 | ROLE_TYPE | Role Type for risk analysis | nvarchar | 1 | 0 | | |
11 | GRACNAMECONV | Naming Convention Table | 3 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
12 | GRACRLATT | Table for attributes for Naming Convention | 1 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
13 | GRACRLCOMPRL | Roles in Composite Roles | 4 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
14 | GRACRLNAMEMAXC | Table for max character of Role Name | 2 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
15 | GRACRLNAMEMAXS | Table for max character of Role Name | 1 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
16 | GRACROLE | Role | 5 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
17 | GRACROLEACTVL | Role Action Violation Table | 2 | ROLE_TYPE | Role Type for risk analysis | nvarchar | 1 | 0 | | |
18 | GRACROLEACTVLEXT | Role Action Violations for Extended Objects | 2 | ROLE_TYPE | Role Type for risk analysis | nvarchar | 1 | 0 | | |
19 | GRACROLEARC | Role Archiving table for deleted roles | 5 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
20 | GRACROLECRPVL | Role Critical Role/Profile Violation Table | 2 | ROLE_TYPE | Role Type for risk analysis | nvarchar | 1 | 0 | | |
21 | GRACROLEEXPORT | Table for templatory storing the role to be exported | 3 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
22 | GRACROLEPHASE | Role Valid Phases | 1 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
23 | GRACROLEPRMVL | Role Permission Violation Table | 2 | ROLE_TYPE | Role Type for risk analysis | nvarchar | 1 | 0 | | |
24 | GRACROLEPRMVLEXT | Role Permission Violation Table | 2 | ROLE_TYPE | Role Type for risk analysis | nvarchar | 1 | 0 | | |
25 | GRACROLETYPE | Role Type Table | 1 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
26 | GRACROLETYPEC | Role type table for Customizing | 3 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
27 | GRACROLETYPESTA | Status for Role Type | 2 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
28 | GRACROLETYPET | Role Type Text Table | 2 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
29 | GRACSYSROLETYP | Role Type - Connection Type relationship | 2 | ROLE_TYPE | Role Type | nvarchar | 3 | 0 | | |
30 | TLRT_TARO_PREFID | Trade Repository: Preferred ID Type | 5 | ROLE_TYPE | BP Role | nvarchar | 6 | 0 | | |
TOPCapacity and Resource Planning |
31 | /MRSS/C_MAPROLE | Mapping of R/3 partner roles | 2 | ROLE_TYPE | Category of R/3 partner role: technician 1 | nvarchar | 10 | 0 | | |
32 | /MRSS/C_RM_RTY | Role Type | 2 | ROLE_TYPE | Role Type ID | nvarchar | 2 | 0 | | |
33 | /MRSS/C_RM_RTY_T | Text for Role Types | 2 | ROLE_TYPE | Role Type ID | nvarchar | 2 | 0 | | |
34 | /MRSS/D_RM_CAND | Candidates for Demands | 3 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
35 | /OPT/VIM_BL_ROLE | Document Type Roles | 6 | ROLE_TYPE | Role Resolution Type | nvarchar | 1 | 0 | | |
TOPMaintenance Orders |
36 | /MRSS/C_ABROLE | Abstract Partner Role | 2 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
37 | /MRSS/C_ABROLET | Abstract Partner Role: Texts | 2 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
38 | /MRSS/C_NW_MAPRO | Mapping of partner roles | 2 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
39 | /MRSS/D_PARTNER | Partner for demands | 3 | ROLE_TYPE | Abstract Partner Role | nvarchar | 10 | 0 | | |
TOPNetWeaver Enterprise Search |
40 | ESH_OM_AOTYPNRO | Assignment of Roles to Nodes | 5 | ROLE_TYPE | Role Type | nvarchar | 30 | 0 | | |
41 | ESH_OM_COTYPNRO | Assignment of Roles to Nodes | 5 | ROLE_TYPE | Role Type | nvarchar | 30 | 0 | | |
42 | ESH_OM_IOTYPNRO | Assignment of Roles to Nodes | 5 | ROLE_TYPE | Role Type | nvarchar | 30 | 0 | | |
43 | ESH_OM_SOTYPNRO | Assignment of Roles to Nodes | 5 | ROLE_TYPE | Role Type | nvarchar | 30 | 0 | | |
TOPPortfolio Management |
44 | RPM_FES_PRJ_ASGN | Assignments for Project Manager | 14 | ROLE_TYPE | Role Type for Projects | nvarchar | 15 | 0 | | |
45 | RPM_FES_PRJ_ROLE | Assignments for Project Manager | 14 | ROLE_TYPE | Role Type for Projects | nvarchar | 15 | 0 | | |
46 | RPM_FES_RES_ASGN | To be deleted | 14 | ROLE_TYPE | Role Type for Projects | nvarchar | 15 | 0 | | |
47 | RPM_FES_RES_ROLE | To be deleted | 14 | ROLE_TYPE | Role Type for Projects | nvarchar | 15 | 0 | | |
48 | RPM_PROJ_STKHLD | Project Stakeholders | 3 | ROLE_TYPE | Role Type | nvarchar | 2 | 0 | | |
49 | RPM_SUBSTITUTE | RPM substitutes | 2 | ROLE_TYPE | Role Type | nvarchar | 2 | 0 | | |
50 | RPM_SUBST_STATUS | RPM substitute status | 2 | ROLE_TYPE | Role Type | nvarchar | 2 | 0 | | |
51 | RPM_SYST_ROLES | System Roles - Stakeholder Mapping | 3 | ROLE_TYPE | Role Type | nvarchar | 2 | 0 | | |
52 | RPM_SYST_ROLE_ID | System Roles - ID | 1 | ROLE_TYPE | Role Type | nvarchar | 2 | 0 | | |
53 | RPM_USERDATA | User data | 3 | ROLE_TYPE | Role Type | nvarchar | 2 | 0 | | |
TOPReal Estate |
54 | TCMS_RE_BPRL | Customizing table for Business Partner roles | 2 | ROLE_TYPE | Business Partner Function | nvarchar | 6 | 0 | | |
55 | TCMS_RE_BPRL_T | Business partner roles(Text table) | 2 | ROLE_TYPE | Business Partner Function | nvarchar | 6 | 0 | | |
TOPSAP Multiresource Scheduling |
56 | /MRSS/C_BP_ROLE | Mapping Role type to BP role | 2 | ROLE_TYPE | Role Type | nvarchar | 10 | 0 | | |