SAP ABAP Table CDBD_PRODUCT_I (Business transaction item - product)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_PRODUCT_I	Table Relationship Diagram
Short Description	Business transaction item - product

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PRODUCT_I_GUID	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	ORDERADM_I_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
4	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
5	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
6	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
7	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
8	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
9	PRICE_PRODUCT	☐	CRMT_PRICE_PRODUCT	SYSUUID	RAW	16	0	Pricing Reference Product Globally Unique Identifier
10	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
11	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
12	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
13	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
14	COMM_GROUP	☐	CRMT_COMM_GROUP	CRM_COMM_GROUP	CHAR	2	0	Commission Group	CRMC_COMM_GRP
15	REBATE_GROUP	☐	CRMT_REBATE_GROUP	CRM_REBATE_GROUP	CHAR	2	0	Volume Rebate Group	CRMC_REBATEGRP
16	CASH_DISC	☐	CRMT_CASH_DISC	XFELD	CHAR	1	0	Specifies Whether a Cash Discount Can Be Given for the Prod.
17	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	CRMC_PRC_PRGRP
18	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
19	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	CRMC_PRC_GRP2
20	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	CRMC_PRC_GRP3
21	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	CRMC_PRC_GRP4
22	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	CRMC_PRC_GRP5
23	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
24	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
25	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
26	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
27	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
28	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
29	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
31	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CDBD_PRODUCT_I	COMM_GROUP	CRMC_COMM_GRP	COMM_GROUP	REF	C	CN
2	CDBD_PRODUCT_I	PRC_GROUP1	CRMC_PRC_GRP1	PRC_GROUP1	REF	C	CN
3	CDBD_PRODUCT_I	PRC_GROUP2	CRMC_PRC_GRP2	PRC_GROUP2	REF	C	CN
4	CDBD_PRODUCT_I	PRC_GROUP3	CRMC_PRC_GRP3	PRC_GROUP3	REF	C	CN
5	CDBD_PRODUCT_I	PRC_GROUP4	CRMC_PRC_GRP4	PRC_GROUP4	REF	C	CN
6	CDBD_PRODUCT_I	PRC_GROUP5	CRMC_PRC_GRP5	PRC_GROUP5	REF	C	CN
7	CDBD_PRODUCT_I	PROD_PR_GROUP	CRMC_PRC_PRGRP	PRC_PR_GROUP	REF	C	CN
8	CDBD_PRODUCT_I	REBATE_GROUP	CRMC_REBATEGRP	REBATE_GROUP	REF	C	CN

History

Last changed by/on	SAP	20030214
SAP Release Created in	30A