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

COMC_IL_TYPE 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_TYPE 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 SOURCE (Type of Object in a Relationship), DESTINATION (Type of Object in a Relationship), DIRECTED (Defines Whether a Relationship Type Is One-Way), REVERSE (Defines if a Relationship Type Is Reversible)... 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_TYPE 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

Text table = COMC_IL_TYPE_T

SAP COMC_IL_TYPE 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_TYPE 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
RELTYPE	Relationship Type	COMT_IL_RELTYPE	CHAR	6
SOURCE	Type of Object in a Relationship	COMT_IL_OBJTYPE	CHAR	10	COMC_IL_OTYPE
DESTINATION	Type of Object in a Relationship	COMT_IL_OBJTYPE	CHAR	10	COMC_IL_OTYPE
DIRECTED	Defines Whether a Relationship Type Is One-Way	COMT_IL_DIRECTED	CHAR	1
REVERSE	Defines if a Relationship Type Is Reversible	COMT_IL_REVERSE	CHAR	1
SCARDNTY	Cardinality Source	COMT_IL_SCARDNTY	CHAR	2
DCARDNTY	Cardinality Destination	COMT_IL_DCARDNTY	CHAR	2
STRELTYP	Storage of Relationship Type	COMT_IL_STRELTYP	CHAR	6
ATTR_TYPE	Name of Structure with Relship-Type-Dependent Attributes	COMT_IL_ATTR_TYPE	CHAR	30
CHANGE_DOC	Determines Whether History Records Are Written	COMT_IL_CHANGE_DOC	CHAR	1
MULTIPLE	Allow Multiple Entries per Source/Destination	COMT_IL_MULTIPLE	CHAR	1			COM_IL_MULTIPLE
CHECK_FUNCTION	Check Function Module	COMT_IL_CHECK_FUNCTION	CHAR	30	Assigned to domain		FUNCNAME
AUTHORITY_CHECK	Execute Authorization Check	COMT_IL_AUTHORITY_CHECK	CHAR	1			XFELD
KEYTYPE_ID	Differentiation Key for a Relationship Type	COMT_IL_KEYTYPE_ID	CHAR	10	Assigned to domain		COM_IL_ORGTYPE_ID
GEN_FLG	Flag: Relationship Type Has Been Generated	COMT_IL_GENFLG	CHAR	1			COM_IL_GENFLG
CLEARING_NODEKEY	Nodes in Clearing Tool	COMT_CLEARING_NODE_KEY	CHAR	10
BW_RELEVANT	Relevance of Description Type for Business Info. Warehouse	COMT_IL_BW_RELEVANT	CHAR	1			COM_BOOLEAN

Key field

Non-key field

< COMC_IL_STRUC - Structures and Table Types of Relationship Types COMC_IL_TYPE_SFW - Definition of Switch per Relationship Type and Product Type >

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

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

SELECT SINGLE *
FROM COMC_IL_TYPE
INTO CORRESPONDING FIELDS OF WA_COMC_IL_TYPE
WHERE...

How to access SAP table COMC_IL_TYPE

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

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