| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/C_BUND_STA | User Status Exclusion table for Bundling | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
2 | /MRSS/C_LN_SGRS | Individual Status of Status Group | 3 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
3 | /MRSS/C_SGX_PRBK | Pre Booking | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
4 | /MRSS/C_SGX_WDGS | Dmenad Status table | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
5 | /MRSS/M_AUT_ASGN | Mirror for Control table for automatic assignment creation | 14 | STATUS_TYPE | Type of ERP Status | nvarchar | 10 | 0 | | |
6 | /MRSS/M_MAPSTAT | Mirror for Mapping of R/3 status | 4 | STATUS_TYPE | Type of ERP Status | nvarchar | 10 | 0 | | |
7 | /MRSS/M_PREV_DEL | Mirror for Prevent Deletion of Operations | 9 | STATUS_TYPE | Type of ERP Status | nvarchar | 10 | 0 | | |
8 | /MRSS/M_STAT_CTR | Mirror for Status Control for Assignment Operations | 9 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
9 | WBCPM_C_IVTY_I | CPM Calc Types per Status Type (for Item) | 2 | STATUS_TYPE | Status Type in Contract Processing Monitor | nvarchar | 4 | 0 | | |
10 | WBCPM_C_STATUS | CPM Status (of an item in the Status List) | 2 | STATUS_TYPE | Status Type in Contract Processing Monitor | nvarchar | 4 | 0 | | |
11 | WBCPM_C_STATUS_T | CPM Status Description | 3 | STATUS_TYPE | Status Type in Contract Processing Monitor | nvarchar | 4 | 0 | | |
12 | WBCPM_C_STA_TP | CPM Calc Types per Status Type (for Header) | 2 | STATUS_TYPE | Status Type in Contract Processing Monitor | nvarchar | 4 | 0 | | |
13 | WBCPM_C_STA_TP_T | CPM Status Type Description | 3 | STATUS_TYPE | Status Type in Contract Processing Monitor | nvarchar | 4 | 0 | | |
14 | WBCPM_C_VIEW_STP | CPM Status Types per View Type | 3 | STATUS_TYPE | Status Type in Contract Processing Monitor | nvarchar | 4 | 0 | | |
TOPCapacity and Resource Planning |
15 | /MRSS/C_MAPASTXT | Status texts for assignments | 2 | STATUS_TYPE | Type of R/3 status | nvarchar | 10 | 0 | | |
16 | /MRSS/C_MAPSTAT | Mapping of R/3 status | 2 | STATUS_TYPE | Type of ERP status | nvarchar | 10 | 0 | | |
17 | /MRSS/C_STAT_CTR | Status Control for Assignment Operations | 7 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
TOPClinical System |
18 | TN2COM_STATTYPES | Status for Document Dispatch | 4 | STATUS_TYPE | Status Type in Dispatch Log | nvarchar | 1 | 0 | | |
TOPERP related topics |
19 | /MRSS/C_SNO_CTRL | MRS: Resource Planning Relevance for Notifications | 4 | STATUS_TYPE | Type of ERP status | nvarchar | 10 | 0 | | |
20 | /MRSS/C_SNO_STCR | Control Assignment Processing Based on Notification status | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
TOPGlobal Organization Customizing |
21 | /MRSS/C_RQ_WK_ST | map abstract status to portal drop down status | 5 | STATUS_TYPE | status type | tinyint | 3 | 0 | | |
TOPMaintenance Orders |
22 | /MRSS/C_ABSTAT | Abstract Status | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
23 | /MRSS/C_ABSTAT_T | Abstract Status: Texts | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
24 | /MRSS/C_AUT_ASGN | Control table for automatic assignment creation | 12 | STATUS_TYPE | Type of ERP status | nvarchar | 10 | 0 | | |
25 | /MRSS/C_AUT_ASGS | Control Automatic Asssignment Creation Based on Status Type | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
26 | /MRSS/C_NW_MAPST | Mapping of Standard Status | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
27 | /MRSS/C_NW_STCTR | Status Control for Assignment Operations(Netweaver) | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
28 | /MRSS/C_PREV_DEL | Prevent Deletion of Operations | 7 | STATUS_TYPE | Type of ERP status | nvarchar | 10 | 0 | | |
29 | /MRSS/C_SGE_SIND | Demand status individualization for assignments | 3 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
30 | /MRSS/C_SGU_SGDS | Individual status in status groups | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
31 | /MRSS/C_SGU_SGRS | Individual status in status groups | 6 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
32 | /MRSS/C_STATUSES | Pushbutton for User Status | 5 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
33 | /MRSS/C_STAT_ACT | MRS: Customizing for mapping of Status to Action on Assignm. | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
34 | /MRSS/C_STAT_PRG | Assignments in Progress | 3 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
35 | /MRSS/C_SYMSTAT | Mapping Symbolic Status to Abstract Status | 3 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
36 | /MRSS/C_WL_CSTAT | Customer Status in Demand | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
37 | /MRSS/D_DEM_STAT | Status of demand items | 3 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
TOPMaintenance Processing |
38 | /MRSS/C_DPR_STAT | To store the status for CPRO | 2 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |
TOPPersonnel Time Management |
39 | PTREQ_STATUS_CHK | Check Methods for Status Transitions | 1 | STATUS_TYPE | Status Transfer Type | nvarchar | 4 | 0 | | |
40 | PTREQ_STATUS_TRA | Status Transfers | 1 | STATUS_TYPE | Status Transfer Type | nvarchar | 4 | 0 | | |
41 | PTREQ_TYPE | Request Types | 2 | STATUS_TYPE | Status Transfer Type | nvarchar | 4 | 0 | | |
42 | PTREQ_XFEREVENTS | Permitted Status Transitions | 1 | STATUS_TYPE | Status Transfer Type | nvarchar | 4 | 0 | | |
TOPRuntime WorkbenchMonitoring |
43 | SXMSMSTAT | Exchange Infrastructure: Message Status | 9 | STATUS_TYPE | XI: Type of a Status | nvarchar | 2 | 0 | | |
TOPSAP Multiresource Scheduling |
44 | /MRSS/C_SGX_WSGS | Individual Status Allocation to Status Group | 4 | STATUS_TYPE | Type of Abstract MRS Status | nvarchar | 10 | 0 | | |