CMS_REL

Relationship details | #masterdata | Component: Collateral Management System
Column Name Description
MANDT FK Client
REL_GUID GUID for Table CMS_REL
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SOURCE_GUID Relationship Source GUID SYSUUID
SRC_SEC_GUID Relationship Source Secondary GUID SYSUUID
DESTINATION_GUID Relationship destination GUID SYSUUID
DST_SEC_GUID Relationship destination GUID SYSUUID
VALID_FROM Date from which the relationship came into effect TZNTSTMPSL
VALID_TO Date until which the relationship stands valid TZNTSTMPSL
REL_RANK Relationship Rank-Order of the source linked to destination CMS_PRIORITY
REL_PRIORITY Priority of a Relationship CMS_PRIORITY
CALC_TYP Calculation type for relations of collateral agreements CMS_CALC_TYP
REL_OBJ Relationship Object CMS_CAT
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
Master Data Relations Join Conditions
Foreign key for Mandt CMS_REL.MANDT == T000.MANDT
Foreign key for Relationship type CMS_REL.MANDT == TCMS_REL_TYP.MANDT