SAP ABAP Table CRMST_ACTIVITYI_PRODUCTS (Structure for copy product after mapping)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BTIL_OBJ (Package) Objects of the Transaction Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_ACTIVITYI_PRODUCTS	Table Relationship Diagram
Short Description	Structure for copy product after mapping

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	SAMRETURN	☐	CRMT_ACT_REP_RETURN	XFLAG	CHAR	1	0	Indicator for Return
2	SAMTOBESENT	☐	CRMT_ACT_REP_REQUEST	XFLAG	CHAR	1	0	Request
3	EXPLOSION	☐	CRMT_ACT_PRODUCT_EXPLOSION	CRM_BOOLEAN	CHAR	1	0	Product Category/Product Heirarcy should be exploded
4	SAMPLES_GIVEN	☐	CRMT_SAMPLES_GIVEN	DEC4	DEC	4	0	Samples History
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	CRM Schedule Line: Structure with Fields Changed Internally
36	SCHEDLIN_NO	☐	CRMT_SCHEDLIN_NO	CRM_SCHEDLIN_NO	NUMC	4	0	Schedule Line Number
37	.INCLUDE	☐				0	0	CRM Schedule Line: Structure With Fields Changeable Extern.
38	.INCLUDE	☐				0	0	CRM Schedule Line:Struct. w. Extern. Changeable Fields Part1
39	ITEM_GUID	☐	CRMT_ITEM_GUID	SYSUUID	RAW	16	0	Item GUID for a CRM Document
40	PARENT_SDLN_GUID	☐	CRMT_SCHEDLIN_GUID	SYSUUID	RAW	16	0	GUID for Schedule Line in Business Transaction
41	.INCLUDE	☐				0	0	CRM Schedule Line: Structure With Fields Changeable Extern.
42	EVENT_TYPE_APPL	☐	EV_TYPE_APPL	EV_TYPE_APPL	CHAR	4	0	Application: Date Type
43	EVENT_TYPE	☐	EV_TYPE	EV_TYPE	CHAR	12	0	Date Type
44	FROM_FLAGFIXED	☐	EV_FR_FLAGFIXED	XFLAG	CHAR	1	0	Flag Whether Start Time is Fixed
45	TO_FLAGFIXED	☐	EV_TO_FLAGFIXED	XFLAG	CHAR	1	0	Flag Whether End Time is Fixed
46	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
47	SOURCE	☐	CRMT_SCHEDLIN_SOURCE	CRM_SCHEDLIN_SOURCE	CHAR	1	0	Source of Schedule Line
48	FROM_TIME	☐	EV_FR_TIME	BCOS_TSTMP	DEC	15	0	Start Time Stamp: Date
49	FROM_TIMEZONE	☐	EV_FR_TIMEZONE	TZNZONE	CHAR	6	0	Start Time Zone: Date	*
50	TO_TIME	☐	EV_TO_TIME	BCOS_TSTMP	DEC	15	0	End Time Stamp: Date
51	TO_TIMEZONE	☐	EV_TO_TIMEZONE	TZNZONE	CHAR	6	0	End Time Zone: Date	*
52	FROM_TIME_IO	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
53	SCHED_NO_EXT	☐	CRMT_SCHED_NO_EXT	CHAR10	CHAR	10	0	External Schedule Line Number for Type ORDERED
54	.INCLUDE	☐				0	0	EEW Include
55	SCHEDLIN_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
56	.INCLUDE	☐				0	0
57	DISCUSS	☐	CRMT_ACT_DISCUSSED	XFLAG	CHAR	1	0	Discussed
58	PRPRIO	☐	CRMT_ACT_PROD_PRIORITY	CRM_ACT_PROD_PRIORITY	CHAR	4	0	Product Priority	CRMC_ACT_PRPRI
59	STATUS	☐	CRMT_ACT_PROD_STATUS	CRM_ACT_PROD_STATUS	CHAR	4	0	Status of documented product	CRMC_ACT_PRSTA
60	.INCLUDE	☐				0	0
61	.INCLUDE	☐				0	0	EEW Include
62	ACTIVITY_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
63	.INCLUDE	☐				0	0
64	.INCLUDE	☐				0	0	Activity Journal: Journal Guid
65	JOURNAL_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRMC_ACT_JRNL
66	.INCLUDE	☐				0	0	Item: Structure of System Fields
67	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
68	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
69	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
70	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
71	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
72	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
73	DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
74	.INCLUDE	☐				0	0	Item: Structre of External Fields
75	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
76	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
77	ALTERNATIVE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
78	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
79	PRODUCT_SRC_SYS	☐	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
80	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
81	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
82	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
83	ITM_LANGUAGE	☐	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
84	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
85	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
86	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
87	ORDER_DATE	☐	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
88	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
89	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
90	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
91	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
92	LOG_SYSTEM_EXT	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
93	.INCLUDE	☐				0	0	EEW Extension
94	ORDERADM_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
95	.INCLUDE	☐				0	0
96	.INCLU--AP	☐				0	0	Additional Fields in ORDERADM_I_EXT
97	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
98	PARENT_IN_COMP_TX	☐	CRMT_COMP_TX_PARENT_GUID	SYSUUID	RAW	16	0	Higher-Level Item Number in Composite Transaction
99	NUMBER_INT_COMP_TX	☐	CRMT_COMP_TX_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Composite Transaction-Specific Item Number
100	ITEM_TYPE_DESCR	☐	CRMT_ITM_TYPE_DESC_20	TEXT20	CHAR	20	0	Item Category Text(20 character)
101	SUBSTITUTED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
102	REF_OBJECT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
103	TYPE	☐	CRMT_ACT_PRODUCT_TYPE	CRM_ACT_PRODUCT_TYPE	CHAR	2	0	Activity Management: Product Type for Journals
104	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMST_ACTIVITYI_PRODUCTS	COMM_GROUP	CRMC_COMM_GRP	COMM_GROUP	REF	C	CN
2	CRMST_ACTIVITYI_PRODUCTS	JOURNAL_GUID	CRMC_ACT_JRNL	JOURNAL_GUID
3	CRMST_ACTIVITYI_PRODUCTS	PRC_GROUP1	CRMC_PRC_GRP1	PRC_GROUP1	REF	C	CN
4	CRMST_ACTIVITYI_PRODUCTS	PRC_GROUP2	CRMC_PRC_GRP2	PRC_GROUP2	REF	C	CN
5	CRMST_ACTIVITYI_PRODUCTS	PRC_GROUP3	CRMC_PRC_GRP3	PRC_GROUP3	REF	C	CN
6	CRMST_ACTIVITYI_PRODUCTS	PRC_GROUP4	CRMC_PRC_GRP4	PRC_GROUP4	REF	C	CN
7	CRMST_ACTIVITYI_PRODUCTS	PRC_GROUP5	CRMC_PRC_GRP5	PRC_GROUP5	REF	C	CN
8	CRMST_ACTIVITYI_PRODUCTS	PROD_PR_GROUP	CRMC_PRC_PRGRP	PRC_PR_GROUP	REF	C	CN
9	CRMST_ACTIVITYI_PRODUCTS	PRPRIO	CRMC_ACT_PRPRI	PRPRIO
10	CRMST_ACTIVITYI_PRODUCTS	REBATE_GROUP	CRMC_REBATEGRP	REBATE_GROUP	REF	C	CN
11	CRMST_ACTIVITYI_PRODUCTS	STATUS	CRMC_ACT_PRSTA	STATUS

History

Last changed by/on	SAP	20140802
SAP Release Created in	701