In this post, I will try and describe everything you need to know about the SAP crmd_product_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_PRODUCT_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_PRODUCT_I....Right lets get started!
Object Name: CRMD_PRODUCT_I
Dictionary Type: Transparent table
Description: Transaction Item - Product
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| GROSS_WEIGHT | CRMT_GROSS_WEIGHT | QUAN | 15(3) | Gross Weight | MENG15 | CRM | ||||||
| NET_WEIGHT | CRMT_NET_WEIGHT | QUAN | 15(3) | Net Weight | MENG15 | CRM | ||||||
| WEIGHT_UNIT | COMT_WEIGHT_UNIT | UNIT | 3(0) | * | Weight Unit | MEINS | CRM | |||||
| VOLUME | CRMT_VOLUME | QUAN | 15(3) | Volume Occupied by the Product per Volume Unit | MENG15 | CRM | ||||||
| VOLUME_UNIT | COMT_VOLUME_UNIT | UNIT | 3(0) | * | Unit for the Volume of a Product | MEINS | CRM | |||||
| PRICE_PRODUCT | CRMT_PRICE_PRODUCT | RAW | 16(0) | Pricing Reference Product Globally Unique Identifier | SYSUUID | CRM | ||||||
| PROCESS_QTY_NUM | CRMT_PROCESS_QTY_NUM | INT4 | 10(0) | Numerator (factor) for conversion trans. quantity in BME | CRM_PROCESS_QTY_NUM | CRM | ||||||
| PROCESS_QTY_DEN | CRMT_PROCESS_QTY_DEN | INT4 | 10(0) | Denominator (factor) for conversion trans. quantity in BME | CRM_PROCESS_QTY_DEN | CRM | ||||||
| EXPONENT10 | CRMT_EXPONENT10 | INT2 | 5(0) | 10 Exponent for Quantity Conversion | CRM_EXPONENT10 | CRM | ||||||
| PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | UNIT | 3(0) | * | Unit of Measure in Which the Product Is Sold | MEINS | CRM | |||||
| COMM_GROUP | CRMT_COMM_GROUP | CHAR | 2(0) | CRMC_COMM_GRP | Commission Group | CRM_COMM_GROUP | CRM | |||||
| REBATE_GROUP | CRMT_REBATE_GROUP | CHAR | 2(0) | CRMC_REBATEGRP | Volume Rebate Group | CRM_REBATE_GROUP | CRM | |||||
| CASH_DISC | CRMT_CASH_DISC | CHAR | 1(0) | Specifies Whether a Cash Discount Can Be Given for the Prod. | XFELD | CRM | ||||||
| PROD_PR_GROUP | CRMT_PROD_PR_GROUP | CHAR | 2(0) | CRMC_PRC_PRGRP | Product Group | CRM_PROD_PR_GROUP | CRM | |||||
| PRC_GROUP1 | CRMT_PRC_GROUP1 | CHAR | 3(0) | CRMC_PRC_GRP1 | Product Group 1 | CRM_PRC_GROUP1 | CRM | |||||
| PRC_GROUP2 | CRMT_PRC_GROUP2 | CHAR | 3(0) | CRMC_PRC_GRP2 | Product Group 2 | CRM_PRC_GROUP2 | CRM | |||||
| PRC_GROUP3 | CRMT_PRC_GROUP3 | CHAR | 3(0) | CRMC_PRC_GRP3 | Product Group 3 | CRM_PRC_GROUP3 | CRM | |||||
| PRC_GROUP4 | CRMT_PRC_GROUP4 | CHAR | 3(0) | CRMC_PRC_GRP4 | Product Group 4 | CRM_PRC_GROUP4 | CRM | |||||
| PRC_GROUP5 | CRMT_PRC_GROUP5 | CHAR | 3(0) | CRMC_PRC_GRP5 | Product Group 5 | CRM_PRC_GROUP5 | CRM | |||||
| PROD_HIERARCHY | CRMT_PROD_HIERARCHY | CHAR | 20(0) | Product Category | COM_CATEGORY_ID | COM_CAT_SALES | CATEGORY_ID | CRM | ||||
| RESID_VALUE_ST | CRMT_RESID_VALUE_ST | CHAR | 3(0) | Residual Value Strategy | CRMT_RESID_VALUE_ST | CRM | ||||||
| RESID_VALUE_GRP | CRMT_RESID_VALUE_GRP | CHAR | 3(0) | * | Residual Value Curve | CRMT_RESID_VALUE_GRP | CRM | |||||
| BATCH_ID | CRMT_BATCH_ID | CHAR | 10(0) | Batch Number | BATCH_ID | CHA | CRM | |||||
| INT_INSPECTION | CRMT_INT_INSPECTION | CHAR | 4(0) | * | Internal Quality Inspection | CRM_ITEM_INSPECTION | CRM | |||||
| RET_PROC_IND | PROCESS_INDICATOR | CHAR | 1(0) | Process Indicator | PROCESS_INDICATOR | CRM | ||||||
| BASE_QTY_UNIT | COMT_PRODUCT_BASE_UOM | UNIT | 3(0) | * | Base Unit of Measure of Product | MEINS | CRM | |||||
| INT_OBJ_NO_BT | CRMT_INT_OBJ_NO_BT | NUMC | 18(0) | Internal Object Number for Batch Properties | CUOBJ | CRM | ||||||
| EXCH_BUSINESS | CRMT_EXCH_BUSINESS_REL | CHAR | 1(0) | Core Entitlements | CRM_EXCH_BUSINESS_REL | CRM |