SAP COMM_PRCAT Product Category Table data and field list

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

The COMM_PRCAT table consists of various fields, each holding specific information or linking keys about Product Category data available in SAP. These include CLIENT (Client), CATEGORY_GUID (Category GUID), PRODUCT_TYPE (Product Type), AUTH_GROUP (Authorization Group)... 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 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: Cannot Be Enhanced


SAP COMM_PRCAT 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 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16COMM_CATEGORYSYSUUID
PRODUCT_TYPEProduct Type COMT_PRODUCT_TYPECHAR2COMC_PR_TYPECOM_PRODUCT_TYPECOM_PRODUCT_TYPECOM_PR_TYPE_ACTIVE
AUTH_GROUPAuthorization Group COMT_AUTH_GROUPCHAR4COMC_PR_AUTHGRCOM_AUTH_GROUP
RESPONSIBLE_PERSBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
OBJECT_FAMILYObject Family COMT_PRODUCT_OBJECT_FAMILYCHAR4COMC_PR_OBJ_FAMCOM_PRODUCT_OBJECT_FAMILYCOM_OBJFAM_PRTYP
NON_SELECTABLECategory Can Be Selected at Database Level COMT_NON_SELECTABLE_CATEGORYCHAR1COM_NON_SELECTABLE_CATEGORY
ID_TYPEID Type for Alternative IDs COMT_ALTID_TYPECHAR16CHAR16COM_ALTIDCOM_PROD_ALTID
NO_DOCUMENTSIndicator: Product Documents Cannot Be Maintained COMT_PRODUCT_NO_DOCUMENTSCHAR1COM_BOOLEAN
NO_PRICE_CONDInd.: Pricing Conditions Cannot Be Maintained in Product COMT_PRODUCT_NO_PRICE_CONDCHAR1COM_BOOLEAN
PARTNER_DET_PROCIdentification of a Partner Determination Procedure COMT_PRODUCT_PARTNER_DET_PROCCHAR8CHAR8
COMPETITOR_PRODObsolete COMT_PRCAT_COMPETITOR_PRODUCTCHAR1COM_BOOLEAN
ECMIndicator: Product Can Be Maintained with ECM COMT_PRODUCT_FLAG_ECMCHAR1COM_BOOLEAN
PRODUCT_TEMPLATEProduct Template for Creating a Configurable Product COMT_PRODUCT_CFG_TEMPLATERAW16SYSUUID
VALID_FROMValid From (Time Stamp) COMT_VALID_FROMDEC15TSTPSBCOS_TSTMP
VALID_TOValid To (Time Stamp) COMT_VALID_TODEC15TSTPSBCOS_TSTMP
UPNAMEName of the User Who Last Changed the Set COMT_UPNAMECHAR12UNAME
HISTEXHistory Exists COMT_HISTEXCHAR1COM_BOOLEAN
LOGSYSOriginal System COMT_LOGSYSCHAR10Assigned to domainALPHALOGSYSCOM_LOGSYSCOM_PRODUCT_LOGSYS

Key field Non-key field



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

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

SELECT SINGLE *
FROM COMM_PRCAT
INTO CORRESPONDING FIELDS OF WA_COMM_PRCAT
WHERE...

How to access SAP table COMM_PRCAT

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

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