CMS_REL is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_REL in SAP.
- Table description : Relationship details
- Module : FS-CMS
- Parent Module : FS
- Package : CMS_COMMON
- Software Component : EA-FINSERV
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMS_REL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| .INCLUDE | Primary key for CMS_REL | ||
| REL_GUID | GUID for Table CMS_REL | CMS_DTE_REL_GUID | SYSUUID |
| .INCLUDE | Link keys for table CMS_REL | ||
| REL_TYP | Relationship type | CMS_DTE_REL_TYP | CMS_REL_TYP |
| .INCLUDE | Relationship Source Link Key | ||
| SOURCE_GUID | Relationship Source GUID | CMS_DTE_REL_SOURCE_GUID | SYSUUID |
| SRC_SEC_GUID | Relationship Source Secondary GUID | CMS_DTE_REL_SRC_SEC_GUID | SYSUUID |
| .INCLUDE | Relationship Destination Link Key | ||
| DESTINATION_GUID | Relationship destination GUID | CMS_DTE_REL_DESTINATION_GUID | SYSUUID |
| DST_SEC_GUID | Relationship destination GUID | CMS_DTE_REL_DST_SEC_GUID | SYSUUID |
| .INCLUDE | Relationship data | ||
| .INCLUDE | Relationship dates(DB Format) | ||
| VALID_FROM | Date from which the relationship came into effect | CMS_DTE_REL_VALID_FROM | TZNTSTMPSL |
| VALID_TO | Date until which the relationship stands valid | CMS_DTE_REL_VALID_TO | TZNTSTMPSL |
| .INCLUDE | Relationship Details | ||
| REL_RANK | Relationship Rank-Order of the source linked to destination | CMS_DTE_REL_RANK | CMS_PRIORITY |
| REL_PRIORITY | Priority of a Relationship | CMS_DTE_REL_PRIORITY | CMS_PRIORITY |
| CALC_TYP | Calculation type for relations of collateral agreements | CMS_DTE_CALC_TYP | CMS_CALC_TYP |
| .INCLUDE | Realtionship Object data | ||
| REL_OBJ | Relationship Object | CMS_DTE_REL_OBJ | CMS_CAT |
| .INCLUDE | Stucture to record history of changes in all application tab | ||
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CMS_USER |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | TZNTSTMPS |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CMS_USER |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | TZNTSTMPS |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE |
CMS_REL related tables
| Table | Note |
|---|---|
| TFREP | Reports with Form Details and Sender Details |
| CMS_REL | Relationship details |
| TCMS_REL_CAT | Relationship category details |
| THMHRT_HR_VAL | Valuation details for the hedging relationship |
| BUT051 | BP Relationship: Contact Person Relationship |
| BUT051S | Shadow Table BP Relationship: Contact Person Relationship |
| CRMC_ISA_RSG_LST | Relationship Types of a Relationship Group |
| CRMD_ICM_REL | ICM Relationship: Relationship |
| P05TPRNL_EE_PR | Pension Return: Income Relationship Pens/Ins Relationship PL |
| TBZ9G | BP Relationship Category->Dyn. Text f. Relationship Overview |
| TZV09 | Relationship - Reference relationship link |
| TZV11 | Relationship category of partner-partner relationship |
| ACMACAVIEWDETAIL | ACM: Access-Condition Authorization-View Details |
| ACMASPPFCGDETAIL | ACM: Details for PFCG_AUTH-Aspects |
| ACMTSTASPPFCGDET | ACMTST: PFCG_AUTH-Aspect-Details (Expected results) |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP