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

Foreign Keys

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

History

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