SAP COMT_IL_IDENT1 IDs in a Relationship Table data and field list

COMT_IL_IDENT1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IDs in a Relationship" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_COMT_IL_IDENT1 TYPE COMT_IL_IDENT1.

The COMT_IL_IDENT1 table consists of various fields, each holding specific information or linking keys about IDs in a Relationship data available in SAP. These include SOURCEGUID (Internal ID for Source in a Relationship), DESTINGUID (Internal ID for Destination in a Relationship), SALES_ORG (Sales Organization), DISTR_CHAN (Distribution Channel)... 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. .

COMT_IL_IDENT1 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP COMT_IL_IDENT1 structure 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 COMT_IL_IDENT1 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
ILGUIDInternal, Unique ID of a Relationship COMT_IL_ILGUIDRAW16SYSUUID
SOURCEGUIDInternal ID for Source in a Relationship COMT_IL_SOURCEGUIDRAW16SYSUUID
DESTINGUIDInternal ID for Destination in a Relationship COMT_IL_DESTINGUIDRAW16SYSUUID
SALES_ORGSales Organization COMT_IL_SALES_ORGCHAR14HROBJEC_14
DISTR_CHANDistribution Channel COMT_IL_DISTRIBUTION_CHANNELCHAR2Assigned to domainCOM_IL_DISTRIBUTION_CHANNEL

Key field Non-key field



How do I retrieve data from SAP structure COMT_IL_IDENT1 using ABAP code?

As COMT_IL_IDENT1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on COMT_IL_IDENT1 as there is no data to select.

How to access SAP table COMT_IL_IDENT1

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

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