The COMM_ATTR_DB_TMP table in SAP ERP or S/4HANA stores Template for Database Tables of Multi-Value Attributes data. There are total 5 fields in COMM_ATTR_DB_TMP table. The Template for Database Tables of Multi-Value Attributes 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 COMM_ATTR_DB_TMP 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 COMM_ATTR_DB_TMP Table Fields
Following is the list of fields that are available in SAP COMM_ATTR_DB_TMP table. The primary key fields of the table are CLIENT (Client), OBJECT_GUID (Internal Key of Set Type), VALUE_KEY (Key for the Values of Multi-Value Attributes).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| OBJECT_GUID | Internal Key of Set Type | COMT_SETTYPE_GUID | RAW (16) | |
| VALUE_KEY | Key for the Values of Multi-Value Attributes | COMT_ATTR_MV_VALUE_KEY | NUMC (9) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| ATTR_VALUE | Data Element for Templates | COMT_FIELDNAME_TEMP | CHAR (10) |
