SAP COMM_PRCAT_ILH Product Category - Relationship Type Assignment: History Table data and field list

COMM_PRCAT_ILH is a standard SAP Table which is used to store Product Category - Relationship Type Assignment: History data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The COMM_PRCAT_ILH table consists of various fields, each holding specific information or linking keys about Product Category - Relationship Type Assignment: History data available in SAP. These include CLIENT (Client), CATEGORY_GUID (Category GUID), IL_RELTYPE (Relationship Type), IL_DIRECTION (Defines the Direction of a Directed Relationship)... 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. .

COMM_PRCAT_ILH table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP COMM_PRCAT_ILH 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 COMM_PRCAT_ILH 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
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
CATEGORY_GUID	Category GUID	COMT_CATEGORY_GUID	RAW	16			SYSUUID
IL_RELTYPE	Relationship Type	COMT_IL_RELTYPE	CHAR	6
IL_DIRECTION	Defines the Direction of a Directed Relationship	COMT_IL_DIRECTION	CHAR	1			COM_ILDIRECTION
VALID_TO	Valid To (Time Stamp)	COMT_VALID_TO	DEC	15		TSTPS	BCOS_TSTMP
INHERITED	Relationship Type Inherited from Higher-Level Category	COMT_IL_INHERITED	CHAR	1			COM_BOOLEAN
VALID_FROM	Valid From (Time Stamp)	COMT_VALID_FROM	DEC	15		TSTPS	BCOS_TSTMP
UPNAME	Name of the User Who Last Changed the Set	COMT_UPNAME	CHAR	12			UNAME
LOGSYS	Original System	COMT_LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS	COM_LOGSYS	COM_PRODUCT_LOGSYS
UPDATE_TYPE	Type of Change	UPDATE_TYPE	CHAR	1			UPDATE_TYPE

Key field

Non-key field

< COMM_PRCAT_IL - Product Category - Relationship Type Assignment COMM_PRCAT_STRUCT - ADD : com_product structure for category - path >

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

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

SELECT SINGLE *
FROM COMM_PRCAT_ILH
INTO CORRESPONDING FIELDS OF WA_COMM_PRCAT_ILH
WHERE...

How to access SAP table COMM_PRCAT_ILH

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

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