SAP COMT_TEMP_MR_DB Table – Set Type Template for Multi-Value Set Types

The COMT_TEMP_MR_DB table in SAP ERP or S/4HANA stores Set Type Template for Multi-Value Set Types data. There are total 9 fields in COMT_TEMP_MR_DB table. The Set Type Template for Multi-Value Set Types table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of COMT_TEMP_MR_DB table. It is in Templates for Generating Set Types (COM_SETTYPE_TEMPLATES) ABAP package and is part of the Set Types and Attributes (AP-MD-PRO-SET) module.

SAP COMT_TEMP_MR_DB Table Fields

Following is the list of fields that are available in SAP COMT_TEMP_MR_DB table. The primary key fields of the table are CLIENT (Client), FRG_GUID (Set GUID), KEY_FIELD1 (Dummy function in length 1).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT * CLNT (3)
FRG_GUID Set GUID COMT_FRG_GUID RAW (16)
KEY_FIELD1 Dummy function in length 1 DUMMY CHAR (1)
VALID_FROM Valid From (Time Stamp) COMT_VALID_FROM DEC (15)
VALID_TO Valid To (Time Stamp) COMT_VALID_TO DEC (15)
UPNAME Name of the User Who Last Changed the Set COMT_UPNAME CHAR (12)
HISTEX History Exists COMT_HISTEX CHAR (1)
LOGSYS Original System COMT_LOGSYS * CHAR (10)
ATTRIBUTE_SVU Data Element for Templates COMT_FLDNAME_TEMP CHAR (10)