SAP Table CMS_REL
Relationship details
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
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 |