CMS_REL - Relationship details

Relationship details information is stored in SAP table CMS_REL.
 It is part of development package CMS_COMMON in software component FS-CMS. This development package consists of objects that can be grouped under "Tools & Common Interfaces used by CMS".

Fields for table CMS_REL

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
.INCLUDEXCMS_STR_REL_PKY0
REL_GUIDGUID for Table CMS_RELXCMS_DTE_REL_GUIDRAW16
.INCLUDECMS_STR_REL_LKY0
REL_TYPRelationship typeCMS_DTE_REL_TYPCHAR12TCMS_REL_TYP
.INCLUDECMS_STR_REL_SRC_LKY0
SOURCE_GUIDRelationship Source GUIDCMS_DTE_REL_SOURCE_GUIDRAW16
SRC_SEC_GUIDRelationship Source Secondary GUIDCMS_DTE_REL_SRC_SEC_GUIDRAW16
.INCLUDECMS_STR_REL_DST_LKY0
DESTINATION_GUIDRelationship destination GUIDCMS_DTE_REL_DESTINATION_GUIDRAW16
DST_SEC_GUIDRelationship destination GUIDCMS_DTE_REL_DST_SEC_GUIDRAW16
.INCLUDECMS_STR_REL_DATA0
.INCLUDECMS_STR_REL_DATES_DB0
VALID_FROMDate from which the relationship came into effectCMS_DTE_REL_VALID_FROMNUMC30
VALID_TODate until which the relationship stands validCMS_DTE_REL_VALID_TONUMC30
.INCLUDECMS_STR_REL_DETAIL0
REL_RANKRelationship Rank-Order of the source linked to destinationCMS_DTE_REL_RANKNUMC8
REL_PRIORITYPriority of a RelationshipCMS_DTE_REL_PRIORITYNUMC8
CALC_TYPCalculation type for relations of collateral agreementsCMS_DTE_CALC_TYPCHAR12*
.INCLUDECMS_STR_REL_OBJ_DATA0
REL_OBJRelationship ObjectCMS_DTE_REL_OBJCHAR12
.INCLUDECHG_HISTORYCMS_STR_CHG_HISTORY0
CREATED_BYLogin ID of the User who created the RecordCMS_DTE_USERCHAR24
CREATED_ATCreation TimestampCMS_DTE_CREATED_ATDEC8
CHANGED_BYLast Changed ByCMS_DTE_LAST_CHNG_USERCHAR24
CHANGED_ATChange TimestampCMS_DTE_CHANGED_ATDEC8
SOURCEOFENTRYSource of EntryCMS_DTE_SOURCE_OF_ENTRYCHAR64
Privacy Policy