CDBD_PRODUCT_I SAP (Business transaction item - product) Table details

Dictionary Type: Table
Description: Business transaction item - product




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




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

CDBD_PRODUCT_I is a standard SAP Table which is used to store Business transaction item - product data and is available within R/3 SAP systems depending on the version and release level.

The CDBD_PRODUCT_I table consists of various fields, each holding specific information or linking keys about Business transaction item - product data available in SAP. These include PRODUCT_I_GUID (Global Unique Identifier), ORDERADM_I_GUID (Global Unique Identifier), 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 CDBD_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
PRODUCT_I_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
ORDERADM_I_GUIDGlobal Unique Identifier SMO_GUIDCHAR32SMO_GUID
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
BASE_QTY_UNITBase Unit of Measure of Product COMT_PRODUCT_BASE_UOMUNIT3Assigned to domainCUNITMEINS
TR_USERTransaction User SMO_TR_USRCHAR32SMO_TR_USR
TR_IDTransaction Identifier SMO_TR_IDCHAR32SMO_TR_ID
TR_STATUSStatus of Transaction SMO_TR_STSCHAR4SMO_TR_STS
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DELETEDMobile Sales Deleted SMO_DELETDCHAR1SMO_DELETD
TR_ROOTIDIdentifier of BDoc Root object SMO_RTGUIDCHAR32SMO_GUID

Key field Non-key field



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

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

SELECT SINGLE *
FROM CDBD_PRODUCT_I
INTO CORRESPONDING FIELDS OF WA_CDBD_PRODUCT_I
WHERE...

How to access SAP table CDBD_PRODUCT_I

Within an ECC or HANA version of SAP you can also view further information about CDBD_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!