SAP Table COMM_PRODUCT
Product
COMM_PRODUCT (Product) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link COMM_PRODUCT to other SAP tables.
COMM_PRODUCT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| PRODUCT_GUID | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW | 16 | 0 | |||||||||
| PRODUCT_ID | Product ID | COMT_PRODUCT_ID | CHAR | 40 | 0 | |||||||||
| PRODUCT_TYPE | Product Type | COMT_PRODUCT_TYPE | COMC_PR_TYPE | CHAR | 2 | 0 | ||||||||
| CONFIG | Determines Whether a Product Is Configurable | COMT_PRODUCT_CONFIGURABLE | CHAR | 1 | 0 | |||||||||
| XNOSEARCH | Product Is Not Relevant for Search Help | COMT_PRODUCT_XNOSEARCH | CHAR | 1 | 0 |
Possible values
|
||||||||
| OBJECT_FAMILY | Object Family | COMT_PRODUCT_OBJECT_FAMILY | COMC_PR_OBJ_FAM | CHAR | 4 | 0 | ||||||||
| BATCH_DEDICATED | Specifies Whether Batches Are Maintained for Product | COMT_BATCH_DEDICATED | CHAR | 1 | 0 |
Possible values
|
||||||||
| COMPETITOR_PROD | Indicates Product Is a Competitor Product | COMT_PR_COMP | CHAR | 1 | 0 |
Possible values
|
||||||||
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC | 15 | 0 | |||||||||
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC | 15 | 0 | |||||||||
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR | 12 | 0 | |||||||||
| HISTEX | History Exists | COMT_HISTEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOGSYS | Original System | COMT_LOGSYS | CHAR | 10 | 0 | |||||||||
COMM_PRODUCT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| COMM_PRODUCT | OBJECT_FAMILY | COMM_PRODUCT | OBJECT_FAMILY | COMC_PR_OBJ_FAM | Object Family | OBJECT_FAMILY |
| COMM_PRODUCT | PRODUCT_TYPE | COMM_PRODUCT | PRODUCT_TYPE | COMC_PR_TYPE | Product Master Definition of Product Types | PRODUCT_TYPE |
