SAP Table CMS_REL
Relationship details
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table CMS_REL (Relationship details) is a standard table in SAP ERP. It belongs to the package CMS_COMMON.
Technical Information
| Table | CMS_REL |
| Short Text | Relationship details |
| Package | CMS_COMMON |
| Table Type | Transparent Table |
Fields for Table CMS_REL
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| REL_GUID | ✔ | GUID for Table CMS_REL | CMS_DTE_REL_GUID | RAW | 16 | |
| REL_TYP | Relationship type | CMS_DTE_REL_TYP | CHAR | 6 | TCMS_REL_TYP | |
| SOURCE_GUID | Relationship Source GUID | CMS_DTE_REL_SOURCE_GUID | RAW | 16 | ||
| SRC_SEC_GUID | Relationship Source Secondary GUID | CMS_DTE_REL_SRC_SEC_GUID | RAW | 16 | ||
| DESTINATION_GUID | Relationship destination GUID | CMS_DTE_REL_DESTINATION_GUID | RAW | 16 | ||
| DST_SEC_GUID | Relationship destination GUID | CMS_DTE_REL_DST_SEC_GUID | RAW | 16 | ||
| VALID_FROM | Date from which the relationship came into effect | CMS_DTE_REL_VALID_FROM | NUMC | 15 | ||
| VALID_TO | Date until which the relationship stands valid | CMS_DTE_REL_VALID_TO | NUMC | 15 | ||
| REL_RANK | Relationship Rank-Order of the source linked to destination | CMS_DTE_REL_RANK | NUMC | 4 | ||
| REL_PRIORITY | Priority of a Relationship | CMS_DTE_REL_PRIORITY | NUMC | 4 | ||
| CALC_TYP | Calculation type for relations of collateral agreements | CMS_DTE_CALC_TYP | CHAR | 6 | ||
| REL_OBJ | Relationship Object | CMS_DTE_REL_OBJ | CHAR | 6 | ||
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR | 12 | ||
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC | 15 | ||
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR | 12 | ||
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC | 15 | ||
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR | 32 |