SAP ABAP Table CRMT_PRODUCT_I_DB_WRK (Product Data: Structure for Database Buffer)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-SLO (Application Component) Sales Transaction
     ⤷ CRM_PRODUCT_I (Package) CRM Sales Order: Product Processing Item

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRODUCT_I_DB_WRK	Table Relationship Diagram
Short Description	Product Data: Structure for Database Buffer

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Transaction Item - Product
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	Item Data Product - Structure with External Fields
6	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
7	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
8	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
9	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
10	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
11	PRICE_PRODUCT	☐	CRMT_PRICE_PRODUCT	SYSUUID	RAW	16	0	Pricing Reference Product Globally Unique Identifier
12	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
13	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
14	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
15	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
16	COMM_GROUP	☐	CRMT_COMM_GROUP	CRM_COMM_GROUP	CHAR	2	0	Commission Group	CRMC_COMM_GRP
17	REBATE_GROUP	☐	CRMT_REBATE_GROUP	CRM_REBATE_GROUP	CHAR	2	0	Volume Rebate Group	CRMC_REBATEGRP
18	CASH_DISC	☐	CRMT_CASH_DISC	XFELD	CHAR	1	0	Specifies Whether a Cash Discount Can Be Given for the Prod.
19	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	CRMC_PRC_PRGRP
20	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
21	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	CRMC_PRC_GRP2
22	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	CRMC_PRC_GRP3
23	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	CRMC_PRC_GRP4
24	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	CRMC_PRC_GRP5
25	PRODUCT_SEGMENT	☐	CRMT_MKTTG_PRSEG_GUID	SYSUUID	RAW	16	0	GUID of a Product Segment
26	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
27	RESID_VALUE_ST	☐	CRMT_RESID_VALUE_ST	CRMT_RESID_VALUE_ST	CHAR	3	0	Residual Value Strategy
28	RESID_VALUE_GRP	☐	CRMT_RESID_VALUE_GRP	CRMT_RESID_VALUE_GRP	CHAR	3	0	Residual Value Curve	*
29	BATCH_ID	☐	CRMT_BATCH_ID	BATCH_ID	CHAR	10	0	Batch Number
30	INT_INSPECTION	☐	CRMT_INT_INSPECTION	CRM_ITEM_INSPECTION	CHAR	4	0	Internal Quality Inspection	*
31	RET_PROC_IND	☐	PROCESS_INDICATOR	PROCESS_INDICATOR	CHAR	1	0	Process Indicator
32	.INCLUDE	☐				0	0	EEW Include
33	PRODUCT_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
34	.INCLUDE	☐				0	0
35	.INCLUDE	☐				0	0	Item Data Product . Structure of Internal Fields
36	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
37	INT_OBJ_NO_BT	☐	CRMT_INT_OBJ_NO_BT	CUOBJ	NUMC	18	0	Internal Object Number for Batch Properties
38	EXCH_BUSINESS	☐	CRMT_EXCH_BUSINESS_REL	CRM_EXCH_BUSINESS_REL	CHAR	1	0	Core Entitlements
39	IS_GIFTCARD	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
40	GC_SEND_TYPE	☐	CRM_GC_SEND_TYPE	CRM_GC_SEND_TYPE	CHAR	1	0	Gift Card Send Type
41	.INCLUDE	☐				0	0	Product Data: Dynamic Fields for Database Buffer
42	NOREC_FLAG	☐	CRMT_NOREC	CRM_BOOLEAN	CHAR	1	0	Entry does not Exist in Database

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in