SAP ABAP Table CMS_REL (Relationship details)
Hierarchy
☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_COMMON (Package) Tools & Common Interfaces used by CMS
Basic Data
Table Category TRANSP    Transparent table 
Transparent table CMS_REL   Table Relationship Diagram
Short Description Relationship details    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 .INCLUDE       0   0   Primary key for CMS_REL  
3 REL_GUID CMS_DTE_REL_GUID SYSUUID RAW 16   0   GUID for Table CMS_REL  
4 .INCLUDE       0   0   Link keys for table CMS_REL  
5 REL_TYP CMS_DTE_REL_TYP CMS_REL_TYP CHAR 6   0   Relationship type TCMS_REL_TYP
6 .INCLUDE       0   0   Relationship Source Link Key  
7 SOURCE_GUID CMS_DTE_REL_SOURCE_GUID SYSUUID RAW 16   0   Relationship Source GUID  
8 SRC_SEC_GUID CMS_DTE_REL_SRC_SEC_GUID SYSUUID RAW 16   0   Relationship Source Secondary GUID  
9 .INCLUDE       0   0   Relationship Destination Link Key  
10 DESTINATION_GUID CMS_DTE_REL_DESTINATION_GUID SYSUUID RAW 16   0   Relationship destination GUID  
11 DST_SEC_GUID CMS_DTE_REL_DST_SEC_GUID SYSUUID RAW 16   0   Relationship destination GUID  
12 .INCLUDE       0   0   Relationship data  
13 .INCLUDE       0   0   Relationship dates(DB Format)  
14 VALID_FROM CMS_DTE_REL_VALID_FROM TZNTSTMPSL NUMC 15   0   Date from which the relationship came into effect  
15 VALID_TO CMS_DTE_REL_VALID_TO TZNTSTMPSL NUMC 15   0   Date until which the relationship stands valid  
16 .INCLUDE       0   0   Relationship Details  
17 REL_RANK CMS_DTE_REL_RANK CMS_PRIORITY NUMC 4   0   Relationship Rank-Order of the source linked to destination  
18 REL_PRIORITY CMS_DTE_REL_PRIORITY CMS_PRIORITY NUMC 4   0   Priority of a Relationship  
19 CALC_TYP CMS_DTE_CALC_TYP CMS_CALC_TYP CHAR 6   0   Calculation type for relations of collateral agreements  
20 .INCLUDE       0   0   Realtionship Object data  
21 REL_OBJ CMS_DTE_REL_OBJ CMS_CAT CHAR 6   0   Relationship Object  
22 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
23 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
24 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
25 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
26 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
27 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_REL MANDT T000 MANDT KEY 1 CN
History
Last changed by/on SAP  20040322 
SAP Release Created in 200