SAP COMS_ALTID_VAL Table for Alternative ID Table data and field list

COMS_ALTID_VAL is a standard SAP Table which is used to store Table for Alternative ID data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The COMS_ALTID_VAL table consists of various fields, each holding specific information or linking keys about Table for Alternative ID data available in SAP. These include ID_VALUE (Field Value for Alternative IDs), PRODUCT_GUID (Internal Unique ID of Product), PRODUCT_ID (Product ID), SHORT_TEXT (Product Description)... 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. .

COMS_ALTID_VAL table Technical Details:

Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP COMS_ALTID_VAL 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 COMS_ALTID_VAL 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
ID_TYPEID Type for Alternative IDs COMT_ALTID_TYPECHAR16CHAR16COM_ALTIDCOM_PROD_ALTID
ID_VALUEField Value for Alternative IDs COMT_ALTID_VALUE_SHORTCHAR54COM_ALTID_VALUE_SHORT
PRODUCT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
SHORT_TEXTProduct Description COMT_PRSHTEXTXCHAR40PRSHTEXT40
SHTEXT_LARGEProduct Description in Uppercase for F4 Help COMT_PRSHTEXTGCHAR40PRSHTEXTG40

Key field Non-key field



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

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

SELECT SINGLE *
FROM COMS_ALTID_VAL
INTO CORRESPONDING FIELDS OF WA_COMS_ALTID_VAL
WHERE...

How to access SAP table COMS_ALTID_VAL

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

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