| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /XFT/EPA_T0012 | Checklists | 5 | SPS_ID | Element Type Record | nvarchar | 32 | 0 | | |
2 | /XFT/SRMCREC53 | Cust.: Status Profile->Derived Status Profile | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
3 | /XFT/SRMPSC001 | Customizing: WBS Element Records Element Types (Default) | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
4 | /XFT/SRMPSC002 | Customizing: WBS Element Records Element Types - Toolbar | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
5 | /XFT/SRMPSC002T | Customizing: WBS Element Records Element Types - Toolbar | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
6 | /XFT/SRMPSC101 | Customizing: WBS Records Element Types (Default) | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
7 | /XFT/SRMPSC102 | Customizing: WBS Records Element Types - Toolbar | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
8 | /XFT/SRMPSC102T | Customizing: WBS Records Element Types - Toolbar | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
9 | /XFT/SRM_DEMOC10 | Customizing: Patent Type | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
10 | /XFT/SRM_DEMOC4 | Customizing: Transaction for Material in Implementation | 5 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
11 | /XFT/SRM_DEMO_10 | Patent | 3 | SPS_ID | | nvarchar | 32 | 0 | | |
12 | SRMSPSBO | Relationship between Business Object ,SPS ID and RMS ID | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
13 | ZSRMPROTOCOL | SRM protocol entries | 15 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
TOPCase Management |
14 | SRMMIMESPS | Table of Possible SPS IDs for File Extensions | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
TOPClinical System |
15 | N2RADMPPS | IS-H*MED RAD: RIS Modality Performed Procedure Step Object | 8 | SPS_ID | RAD: Scheduled Procedure Step ID | nvarchar | 16 | 0 | | |
TOPRecords and Case Management |
16 | RMPSC_TRF_ENTITY | DoD: Transfer - export/import configuration - entities | 4 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
17 | RMPSE_SOA_DOC | Define Document Types for Services | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
18 | RMPSE_SOA_REC | Define Record Types for Services | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
19 | RMPSI_TRF_TPL_EN | DoD: Transfer - exp./imp. config - template entities | 4 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
20 | RMPS_A2RM_RM | BOR -> RMS/SPS | 4 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
21 | RMPS_ACL_CHECK | Authorizations and Element Types | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
22 | RMPS_AI_SCEN_EL | Scenario Elements | 4 | SPS_ID | RMS ID | nvarchar | 32 | 0 | | |
23 | RMPS_AUDIT_CUST | Audit: Output Control | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
24 | RMPS_OI_SCENARIO | Scenarios for Upload | 5 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
TOPSAP Records Management |
25 | RCMDOCCONFIG | Customizing Table F | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
26 | RCMDOCTRANSGR | RCM: Possible Transitions for SP Document in Web Dynpro | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
27 | RCM_ORG_OPENMODE | RCM Organizer: Configuration of Open Mode: Change, Display | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
28 | RCM_ORG_QACT_PRD | RCM Organizer: Definition of Views (Quick Action) | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
29 | SRMALATTRLIS | Attribute Memory, Language-Independent, Single-Value | 7 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
30 | SRMBORCUST | Overwrite Connection Parameters for SP BOR | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
31 | SRMDOCSPSPS | Table for Assignment SPS-ID to ALINK Docspace | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
32 | SRMDPDISP | Circular | 10 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
33 | SRMGSP_ATTR_CUST | Customizing for Archive Attribute Search | 1 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
34 | SRMORGFAV | BC-RM: Organizer Favorites | 9 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
35 | SRMORGRL2 | BC-RM : Roles (new) | 10 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
36 | SRMPROTOCOL | SRM protocol entries | 15 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
37 | SRMSRELCUST | Settings for Link Display in SP BOR | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
38 | SRM_ATTR_SPS_CU | Assignment of SPS ID to Attribute Model ID | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
39 | SRM_ECM_CSO | Client Supplied Owners of Document Locks | 6 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
40 | SRM_ECM_HASH | HashValues of SRM/ECM optimistic locking (value comparision) | 11 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
41 | SRM_ECM_NNT | Lookup table for RM node names in ECM integration | 8 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
42 | SRM_PROP_DATA | Obsolete! | 6 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
43 | SRM_PROP_DATA_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
44 | SRM_PROP_META_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
45 | SRM_PROP_MT_I_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
46 | SRM_PROP_MT_S_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
47 | SRM_PROP_MT_T_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
48 | SRM_PROP_QUER_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
49 | SRM_PROP_VISL_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
50 | SRM_PROP_VISU_CU | Obsolete! | 2 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |
51 | SRM_PU_QUERY_SPS | Assignment of SPS ID to Query ID | 3 | SPS_ID | Element Type ID | nvarchar | 32 | 0 | | |