SAP MRELATION Table in S/4 HANA - Relationship Between Download Tables
MRELATION is a standard SAP Table which is used to store Relationship Between Download Tables data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MRELATION table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type)
Dictionary Type: Structure
Database Table: MRELATION
MRELATION table structure field list
Below is the full MRELATION field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | Assigned to domain | MANDT | ||||
| FTABLE | Table Name of Higher-Level Table | MFTABLE | CHAR | 30(0) | CHAR30 | |||||
| FFIELD | Field Name from Higher-Level Table | MFFIELD | CHAR | 30(0) | CHAR30 | |||||
| CTABLE | Table Name from Sub-Table | MCTABLE | CHAR | 30(0) | CHAR30 | |||||
| CFIELD | Field Name from Sub-Table | MCFIELD | CHAR | 30(0) | CHAR30 | |||||
| FOFFSET | Offset Key Field from Higher-Level Table | CRMFOFFSET | NUMC | 6(0) | NUMC06 | |||||
| FLENGTH | Length of Key Field from Higher-Level Table | CRMFLENGTH | NUMC | 6(0) | NUMC06 | |||||
| COFFSET | Offset Key Field for Sub-Table | CRMCOFFSET | NUMC | 6(0) | NUMC06 | |||||
| CLENGTH | Length of Key Field from Sub-Table | CRMCLENGTH | NUMC | 6(0) | NUMC06 | |||||
| FVALUE | Fixed Value of Key Field from Higher-Level | CRMFVALUE | NUMC | 6(0) | NUMC06 |
Search for further information about these or an SAP related objects