CRMD_PRODUCT_I SAP (Transaction Item - Product) Table details

Dictionary Type: Table
Description: Transaction Item - Product




ABAP Code to SELECT data from CRMD_PRODUCT_I
Related tables to CRMD_PRODUCT_I
Access table CRMD_PRODUCT_I




Table field list including key, data, relationships and ABAP select examples

CRMD_PRODUCT_I is a standard SAP Table which is used to store Transaction Item - Product data and is available within R/3 SAP systems depending on the version and release level.

The CRMD_PRODUCT_I table consists of various fields, each holding specific information or linking keys about Transaction Item - Product data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), GROSS_WEIGHT (Gross Weight), NET_WEIGHT (Net Weight).. 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. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMD_PRODUCT_I table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
GROSS_WEIGHTGross Weight CRMT_GROSS_WEIGHTQUAN15(3) MENG15
NET_WEIGHTNet Weight CRMT_NET_WEIGHTQUAN15(3) MENG15
WEIGHT_UNITWeight Unit COMT_WEIGHT_UNITUNIT3Assigned to domainCUNITMEINS
VOLUMEVolume Occupied by the Product per Volume Unit CRMT_VOLUMEQUAN15(3) MENG15
VOLUME_UNITUnit for the Volume of a Product COMT_VOLUME_UNITUNIT3Assigned to domainCUNITMEINS
PRICE_PRODUCTPricing Reference Product Globally Unique Identifier CRMT_PRICE_PRODUCTRAW16SYSUUID
PROCESS_QTY_NUMNumerator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_NUMINT410CRM_PROCESS_QTY_NUM
PROCESS_QTY_DENDenominator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_DENINT410CRM_PROCESS_QTY_DEN
EXPONENT1010 Exponent for Quantity Conversion CRMT_EXPONENT10INT25CRM_EXPONENT10
PROCESS_QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
COMM_GROUPCommission Group CRMT_COMM_GROUPCHAR2CRMC_COMM_GRPCRM_COMM_GROUP
REBATE_GROUPVolume Rebate Group CRMT_REBATE_GROUPCHAR2CRMC_REBATEGRPCRM_REBATE_GROUP
CASH_DISCSpecifies Whether a Cash Discount Can Be Given for the Prod. CRMT_CASH_DISCCHAR1XFELD
PROD_PR_GROUPProduct Group CRMT_PROD_PR_GROUPCHAR2CRMC_PRC_PRGRPCRM_PROD_PR_GROUP
PRC_GROUP1Product Group 1 CRMT_PRC_GROUP1CHAR3CRMC_PRC_GRP1CRM_PRC_GROUP1
PRC_GROUP2Product Group 2 CRMT_PRC_GROUP2CHAR3CRMC_PRC_GRP2CRM_PRC_GROUP2
PRC_GROUP3Product Group 3 CRMT_PRC_GROUP3CHAR3CRMC_PRC_GRP3CRM_PRC_GROUP3
PRC_GROUP4Product Group 4 CRMT_PRC_GROUP4CHAR3CRMC_PRC_GRP4CRM_PRC_GROUP4
PRC_GROUP5Product Group 5 CRMT_PRC_GROUP5CHAR3CRMC_PRC_GRP5CRM_PRC_GROUP5
PROD_HIERARCHYProduct Category CRMT_PROD_HIERARCHYCHAR20COM_CATEGORY_IDCOM_CAT_SALES
RESID_VALUE_STResidual Value Strategy CRMT_RESID_VALUE_STCHAR3CRMT_RESID_VALUE_ST
RESID_VALUE_GRPResidual Value Curve CRMT_RESID_VALUE_GRPCHAR3Assigned to domainCRMT_RESID_VALUE_GRP
BATCH_IDBatch Number CRMT_BATCH_IDCHAR10BATCH_IDCHA
INT_INSPECTIONInternal Quality Inspection CRMT_INT_INSPECTIONCHAR4Assigned to domainCRM_ITEM_INSPECTION
RET_PROC_INDProcess Indicator PROCESS_INDICATORCHAR1PROCESS_INDICATOR
BASE_QTY_UNITBase Unit of Measure of Product COMT_PRODUCT_BASE_UOMUNIT3Assigned to domainCUNITMEINS
INT_OBJ_NO_BTInternal Object Number for Batch Properties CRMT_INT_OBJ_NO_BTNUMC18CUOBJ
EXCH_BUSINESSCore Entitlements CRMT_EXCH_BUSINESS_RELCHAR1CRM_EXCH_BUSINESS_REL

Key field Non-key field



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

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

SELECT SINGLE *
FROM CRMD_PRODUCT_I
INTO CORRESPONDING FIELDS OF WA_CRMD_PRODUCT_I
WHERE...

How to access SAP table CRMD_PRODUCT_I

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!