SAP ABAP Table CRMT_HH_PRODUCT_MAIN (CRM HH: main product attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-HH (Application Component) Handheld
     ⤷ CRM_HH (Package) CRM Mobile Applications for Handhelds

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_HH_PRODUCT_MAIN	Table Relationship Diagram
Short Description	CRM HH: main product attributes

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	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
2	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
3	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
4	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
5	BATCH_DEDICATED	☐	COMT_BATCH_DEDICATED	COM_BOOLEAN	CHAR	1	0	Specifies Whether Batches Are Maintained for Product
6	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
7	BASE_UOM	☐	COMT_MAT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of a Material	*
8	IS_SALES_PRODUCT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
9	IS_SPARE_PART	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
10	GTIN	☐	COMT_GTIN	COM_GTIN	CHAR	40	0	Global Trade Item Number (GTIN)
11	.INCLUDE	☐				0	0	Sales Data on Product: Control Fields, Quantities (w/o Key)
12	PROCESS_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	T006
13	CASH_DISC	☐	CRMT_CASH_DISC	XFELD	CHAR	1	0	Specifies Whether a Cash Discount Can Be Given for the Prod.
14	MIN_ORDER	☐	CRMT_MIN_ORDER	MENG13	QUAN	13	3	Minimum Order Quantity in Base Unit of Measure
15	PRICE_PRODUCT	☐	CRMT_PRICE_PRODUCT	SYSUUID	RAW	16	0	Pricing Reference Product Globally Unique Identifier	COMM_PRODUCT
16	S_ITEM_CAT_GROUP	☐	CRMT_SALES_ITEM_CAT_GROUP	CRM_ITEM_CAT_GROUP	CHAR	4	0	Distribution-Chain-Dependent Item Category Group	CRMC_ITEM_CAT_GR
17	UNDEL	☐	CRMT_UNDEL	MEINS	UNIT	3	0	Unit of Measure of Delivery Unit	*
18	DELY_UNIT	☐	CRMT_DELY_UNIT	MENG13	QUAN	13	3	Delivery Unit
19	UNSALE_NOT_VAR	☐	CRMT_UNSALE_NOT_VAR	XFELD	CHAR	1	0	Variable Sales Unit Not Allowed
20	LOC_BUPA	☐	INVENT_LOC_BUPA	BU_PARTNER	CHAR	10	0	Delivering Location	*
21	O_ITEM_CAT_GROUP	☐	CRMT_IND_OBJ_ITEM_CAT_GROUP	CRM_ITEM_CAT_GROUP	CHAR	4	0	Item Category Group for Individual Objects	*
22	.INCLUDE	☐				0	0	Sales Data on Product: Groupings (Without Key)
23	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	CRMC_PRC_PRGRP
24	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
25	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	CRMC_PRC_GRP2
26	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	CRMC_PRC_GRP3
27	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	CRMC_PRC_GRP4
28	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	CRMC_PRC_GRP5
29	REBATE_GROUP	☐	CRMT_REBATE_GROUP	CRM_REBATE_GROUP	CHAR	2	0	Volume Rebate Group	CRMC_REBATEGRP
30	COMM_GROUP	☐	CRMT_COMM_GROUP	CRM_COMM_GROUP	CHAR	2	0	Commission Group	CRMC_COMM_GRP
31	ACCTGRP_PROD	☐	CRMT_ACCTGRPPROD	CRM_ACCTGRPPROD	CHAR	2	0	Account Assignment Group for Product	CRMC_ACGRPPROD
32	SALESCAT_GUID	☐	CRMT_SALESCAT_GUID	SYSUUID	RAW	16	0	Distribution Chain Dependent Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_HH_PRODUCT_MAIN	ACCTGRP_PROD	CRMC_ACGRPPROD	ACCTGRP_PROD
2	CRMT_HH_PRODUCT_MAIN	COMM_GROUP	CRMC_COMM_GRP	COMM_GROUP
3	CRMT_HH_PRODUCT_MAIN	PRC_GROUP1	CRMC_PRC_GRP1	PRC_GROUP1
4	CRMT_HH_PRODUCT_MAIN	PRC_GROUP2	CRMC_PRC_GRP2	PRC_GROUP2
5	CRMT_HH_PRODUCT_MAIN	PRC_GROUP3	CRMC_PRC_GRP3	PRC_GROUP3
6	CRMT_HH_PRODUCT_MAIN	PRC_GROUP4	CRMC_PRC_GRP4	PRC_GROUP4
7	CRMT_HH_PRODUCT_MAIN	PRC_GROUP5	CRMC_PRC_GRP5	PRC_GROUP5
8	CRMT_HH_PRODUCT_MAIN	PRICE_PRODUCT	COMM_PRODUCT	CLIENT
9	CRMT_HH_PRODUCT_MAIN	PROCESS_UNIT	T006	MSEHI
10	CRMT_HH_PRODUCT_MAIN	PROD_PR_GROUP	CRMC_PRC_PRGRP	PRC_PR_GROUP	REF	1	CN
11	CRMT_HH_PRODUCT_MAIN	REBATE_GROUP	CRMC_REBATEGRP	REBATE_GROUP
12	CRMT_HH_PRODUCT_MAIN	S_ITEM_CAT_GROUP	CRMC_ITEM_CAT_GR	ITEM_CAT_GROUP

History

Last changed by/on	SAP	20110908
SAP Release Created in	400