SAP COMC_IL_RELTYPE Definition of Relationship Types for Object Relationships Table data and field list

COMC_IL_RELTYPE is a standard SAP Table which is used to store Definition of Relationship Types for Object Relationships data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The COMC_IL_RELTYPE table consists of various fields, each holding specific information or linking keys about Definition of Relationship Types for Object Relationships data available in SAP. These include RELTYP (Relationship Type), SOURCE (Type of Object in a Relationship), DESTINATION (Type of Object in a Relationship), DIRECTED (Defines Whether a Relationship Type Is One-Way)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

COMC_IL_RELTYPE table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP COMC_IL_RELTYPE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the COMC_IL_RELTYPE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
RELTYPRelationship Type COMT_IL_RELTYPECHAR6
SOURCEType of Object in a Relationship COMT_IL_OBJTYPECHAR10COMC_IL_OBJTYPE
DESTINATIONType of Object in a Relationship COMT_IL_OBJTYPECHAR10COMC_IL_OBJTYPE
DIRECTEDDefines Whether a Relationship Type Is One-Way COMT_IL_DIRECTEDCHAR1
REVERSEDefines if a Relationship Type Is Reversible COMT_IL_REVERSECHAR1
SCARDNTYCardinality Source COMT_IL_SCARDNTYCHAR2
DCARDNTYCardinality Destination COMT_IL_DCARDNTYCHAR2
STRELTYPStorage of Relationship Type COMT_IL_STRELTYPCHAR6
ATTR_TYPEName of Structure with Relship-Type-Dependent Attributes COMT_IL_ATTR_TYPECHAR30
CHANGE_DOCDetermines Whether History Records Are Written COMT_IL_CHANGE_DOCCHAR1
MULTIPLEAllow Multiple Entries per Source/Destination COMT_IL_MULTIPLECHAR1COM_IL_MULTIPLE
CHECK_FUNCTIONCheck Function Module COMT_IL_CHECK_FUNCTIONCHAR30Assigned to domainFUNCNAME
AUTHORITY_CHECKExecute Authorization Check COMT_IL_AUTHORITY_CHECKCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table COMC_IL_RELTYPE using ABAP code

The following ABAP code Example will allow you to do a basic selection on COMC_IL_RELTYPE to SELECT all data from the table
DATA: WA_COMC_IL_RELTYPE TYPE COMC_IL_RELTYPE.

SELECT SINGLE *
FROM COMC_IL_RELTYPE
INTO CORRESPONDING FIELDS OF WA_COMC_IL_RELTYPE
WHERE...

How to access SAP table COMC_IL_RELTYPE

Within an ECC or HANA version of SAP you can also view further information about COMC_IL_RELTYPE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).