SAP ABAP Table CRMT_BW_DS_ACTIVITY_I (Data Source for CRM Activities, Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_DS_ACTIVITY_I	Table Relationship Diagram
Short Description	Data Source for CRM Activities, Item Data

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	ORDERADM_H Data for BW DataSources
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE	☐				0	0	Activities Header Data for BW Data Sources
27	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
28	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority	*
29	OBJECTIVE	☐	CRMT_OBJECTIVE	CRM_OBJECTIVE	CHAR	3	0	Goal of an Activity	*
30	DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
31	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
32	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
33	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
34	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
35	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
36	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
37	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
38	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
39	.INCLUDE	☐				0	0	DATES Data for BW DataSources
40	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
41	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
42	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
43	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
44	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
45	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
46	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
47	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
48	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
49	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
50	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
51	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
52	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
53	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
54	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
55	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
56	EARLIEST_CONFIRM	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
57	DURA	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
58	DURA_FULLFILL	☐	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
59	DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
60	BEGIN_TO_COMPLET	☐	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
61	COMPLETE_TO_END	☐	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
62	REL_TO_BEGIN	☐	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
63	REL_BEFORE_END	☐	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
64	REQ_DLV_DATE	☐	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
65	LAST_DLV_DATE	☐	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
66	LAST_QI_ACT_DATE	☐	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
67	LAST_REQ_AVA_DAT	☐	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
68	LAST_CONF_AV_DAT	☐	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
69	LAST_REQ_QI_PLDA	☐	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
70	LAST_CONF_QI_PLD	☐	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
71	CONFIRMED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
72	ACTUAL_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
73	EARLIEST_CON_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
74	REQUESTED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
75	VALID_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
76	VALID_TO_TS	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
77	.INCLUDE	☐				0	0	Activity Item Data for BW Data Sources
78	.INCLUDE	☐				0	0	Activity Journal: Journal Guid
79	JOURNAL_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRMC_ACT_JRNL
80	.INCLUDE	☐				0	0	Activity: Product Reporting
81	DISCUSS	☐	CRMT_ACT_DISCUSSED	XFLAG	CHAR	1	0	Discussed
82	PRPRIO	☐	CRMT_ACT_PROD_PRIORITY	CRM_ACT_PROD_PRIORITY	CHAR	4	0	Product Priority	CRMC_ACT_PRPRI
83	STATUS	☐	CRMT_ACT_PROD_STATUS	CRM_ACT_PROD_STATUS	CHAR	4	0	Status of documented product	CRMC_ACT_PRSTA
84	PROD_HIERARCHY	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
85	.INCLUDE	☐				0	0	Activity Reporting Attributes IBU-SPECIFIC
86	.INCLUDE	☐				0	0	Activity: Product Measurement Reporting
87	LAENG	☐	COMT_LENGTH	MENG13	QUAN	13	3	Length of the Product or of the Packaging of the Product
88	BREIT	☐	COMT_WIDTH	MENG13	QUAN	13	3	Width of the Product or of the Packaging of the Product
89	HOEHE	☐	COMT_HEIGHT	MENG13	QUAN	13	3	Height of the Product or of the Packaging of the Product
90	MEABM	☐	COMT_UNIT_OF_DIMENSION	MEINS	UNIT	3	0	Unit in Which Length/Width/Height Is Measured	T006
91	.INCLUDE	☐				0	0	Activity: Product Availability Reporting
92	PRAVA	☐	CRMT_ACT_PROD_AVAILABLE_AFTER	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkout	CRMC_ACT_PRAVA
93	PRAVB	☐	CRMT_ACT_PROD_AVAILABLE_BEFORE	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check out	CRMC_ACT_PRAVB
94	.INCLUDE	☐				0	0	Activity: General Reporting
95	SUBJECTA	☐	CRMT_ACT_SUBJECTA	CRM_ACT_SUBJECTA	CHAR	10	0	Free Text: Subject A	CRMC_ACT_SBJTA
96	SUBJECTB	☐	CRMT_ACT_SUBJECTB	CRM_ACT_SUBJECTB	CHAR	10	0	Free Text: Subject B	CRMC_ACT_SBJTB
97	KV_RESULT	☐	CRMT_ACT_KVRESF	CRM_ACT_KVRESF	CHAR	1	0	Result	CRMC_ACT_RSLT
98	RESREAS	☐	CRMT_ACT_RESRAS	CRM_ACT_RESRAS	CHAR	3	0	Result Reason	CRMC_ACT_RESRS
99	.INCLUDE	☐				0	0	Activity: Decoration Check Reporting
100	KV_DEKO	☐	CRMT_ACT_DECO_MATERIAL	CRM_ACT_DECO_MATERIAL	CHAR	3	0	Decoration Material	CRMC_ACT_DECOM
101	DEKOTP	☐	CRMT_ACT_DECO_TYPE	CRM_ACT_DECO_TYPE	CHAR	3	0	Decoration Type	CRMC_ACT_DECOT
102	KV_STOCK	☐	CRMT_ACT_DECO_NUMBER_ON_STOCK	DEC6	DEC	6	0	Number of Products in stocks
103	.INCLUDE	☐				0	0	Activity: Placement Check Reporting
104	POSLOC	☐	CRMT_ACT_MAIN_LOCATION	CRM_ACT_MAIN_LOCATION	CHAR	3	0	main location of placement, eg. pallet, chip etc.	CRMC_ACT_MPLCT
105	KV_ZPANZ	☐	CRMT_ACT_SECOND_PLACEMENT	DEC3	DEC	3	0	Number of Second placements
106	KV_ZPAVA	☐	CRMT_ACT_SEC_PLACEMENT_AVAIL	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
107	.INCLUDE	☐				0	0	Activity: Inventory Check Reporting
108	NRMSHF	☐	CRMT_ACT_PROD_IN_MAIN_SHELF	DEC6	DEC	6	0	Number of produts in main shelf
109	NRPSHF	☐	CRMT_ACT_PROD_IN_PROM_SHELF	DEC6	DEC	6	0	Number of products in promation shelf
110	.INCLUDE	☐				0	0	Activity: Product Position Check Reporting
111	POSVER	☐	CRMT_ACT_VERTICAL_POS_IN_SHELF	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	CRMC_ACT_POSVR
112	POSHOR	☐	CRMT_ACT_HORIZONT_POS_IN_SHELF	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	CRMC_ACT_POSHR
113	POSQLI	☐	CRMT_ACT_QUALI_OF_SHEL_POS	CRMT_ACT_QUALI_OF_SHELF_POS	CHAR	3	0	Qualification of the shelf position	CRMC_ACT_POSQL
114	ECROPT	☐	CRMT_ACT_SHELF_OPTIMIZATION	CRM_ACT_SHELF_OPTIMIZATION	CHAR	3	0	Shelf Optimization performed within an ECR agreement	CRMC_ACT_CURES
115	.INCLUDE	☐				0	0	Activity: Facing Check Reporting
116	NROFFAC	☐	CRMT_NUMBER_OF_FACING	DEC4	DEC	4	0	Number of facings
117	FACLEN	☐	CRMT_ACT_LENGTH_OF_FACING	DEC6	DEC	6	0	Length of facing
118	FACWID	☐	CRMT_ACT_WIDTH_OF_FACING	DEC6	DEC	6	0	Width of facing
119	FACDEP	☐	CRMT_ACT_DEPTH_OF_FACING	DEC4_2	DEC	6	2	Depth of facing
120	FACUNIT	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	T006
121	.INCLUDE	☐				0	0	Activity: Price_check_reporting
122	SPRICE	☐	CRMT_SALES_PRICE_IN_STORE	CRMT_ACT_CURRENCY	CURR	28	2	Sales Price in store
123	OPRICE	☐	CRMT_ACT_ORDER_PRICE_IN_STORE	CRMT_ACT_CURRENCY	CURR	28	2	Order Price in store
124	APRICE	☐	CRMT_ACTION_PRICE_IN_STORE	CRMT_ACT_CURRENCY	CURR	28	2	Promotion price in store
125	KVCURR1	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
126	.INCLUDE	☐				0	0	Activity: Pharama fields Reporting
127	PHREFNR	☐	CRMT_ACT_PHARMA_REF_NUMBER	TEXT10	CHAR	10	0	Pharmaceutical Reference Number
128	.INCLUDE	☐				0	0	Activity: Free Samples Reporting
129	STORNO	☐	STORNO	CHAR1_X	CHAR	1	0	Indicator: Data to Be Canceled
130	LBVAL	☐	CRMT_ACT_VALUE_LEFT_BEHIND	DEC13_2	DEC	15	2	Value of Samples
131	.INCLUDE	☐				0	0	Activity Managment: IBU CP fields for Activity Journals
132	EDAY_LOW_PRICE	☐	EVERYDAY_LOW_PRICE	EVERYDAY_LOW_PRICE	CURR	12	2	Everyday-Low-Price
133	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
134	PRP_RANK	☐	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
135	KVCURR	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
136	.INCLUDE	☐				0	0	Activity: Structure provided for easy integration of MSA
137	PRAVA0	☐	CRMT_ACT_MSA_PRAVA0	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
138	PRAVA1	☐	CRMT_ACT_MSA_PRAVA1	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
139	PRAVA2	☐	CRMT_ACT_MSA_PRAVA2	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
140	PRAVA3	☐	CRMT_ACT_MSA_PRAVA3	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
141	PRAVA4	☐	CRMT_ACT_MSA_PRAVA4	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
142	PRAVB0	☐	CRMT_ACT_MSA_PRAVB0	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
143	PRAVB1	☐	CRMT_ACT_MSA_PRAVB1	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
144	PRAVB2	☐	CRMT_ACT_MSA_PRAVB2	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
145	PRAVB3	☐	CRMT_ACT_MSA_PRAVB3	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
146	PRAVB4	☐	CRMT_ACT_MSA_PRAVB4	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
147	.INCLUDE	☐				0	0	PARTNER (Opportunity/Activity) Data for BW DataSoures
148	COMPETITOR	☐	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
149	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
150	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
151	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
152	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
153	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
154	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
155	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
156	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
157	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
158	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
159	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
160	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
161	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
162	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
163	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
164	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
165	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
166	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
167	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
168	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
169	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
170	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
171	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
172	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
173	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
174	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
175	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
176	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
177	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
178	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
179	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
180	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
181	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
182	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
183	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
184	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
185	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
186	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
187	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
188	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
189	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
190	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
191	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
192	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
193	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
194	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
195	.INCLUDE	☐				0	0	General Product Data for BW DataSources
196	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
197	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
198	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
199	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
200	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
201	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
202	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
203	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
204	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
205	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
206	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
207	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
208	.INCLUDE	☐				0	0	PRODUCT_I Data for BW DataSources
209	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
210	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
211	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
212	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
213	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
214	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
215	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
216	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
217	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
218	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
219	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
220	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
221	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
222	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
223	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
224	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
225	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
226	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
227	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
228	.INCLUDE	☐				0	0	DOC_FLOW Data for BW DataSources
229	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
230	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
231	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
232	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
233	PRED_LEAD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
234	LEAD_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
235	PRED_OPPT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
236	OPPT_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
237	PRED_ACT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
238	ACT_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
239	ACT_DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
240	QUOTATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
241	QUOT_VALID_FROM	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
242	PROCESS_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
243	PROCESS_CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
244	PROCESS_CODEGR	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
245	PROCESS_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
246	PROCESS_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
247	PO_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
248	PO_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
249	LEAD_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
250	OPPT_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
251	QUOT_VALID_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
252	.INCLUDE	☐				0	0	Schedule line quantities - Daten für BW Datasoures
253	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
254	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
255	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
256	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
257	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
258	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
259	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
260	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
261	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
262	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
263	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
264	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
265	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
266	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
267	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
268	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
269	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
270	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
271	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
272	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
273	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
274	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
275	.INCLUDE	☐				0	0	USER STATUS GROUPS Data for BW Datasources
276	BWSTONEUSS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
277	.INCLUDE	☐				0	0	Territory Data for BW Data Sources (Partner Attribute)
278	PATH_GUID	☐	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
279	TERR_GUID	☐	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
280	.INCLUDE	☐				0	0	Further Product Data for BW DataSources
281	IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
282	IOBJECT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
283	CONFPROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
284	CONFPROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
285	PROD_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
286	BATCH_ID	☐	CRMT_BATCH_ID	BATCH_ID	CHAR	10	0	Batch Number
287	SAMPLE	☐	CRMT_SAMPLE_INV	CRM_BOOLEAN	CHAR	1	0	Sample Indicator
288	SAMPLE_SPEC	☐	CRMT_SAMPLE_SPEC	CRMBWSAMPLE	CHAR	1	0	Sample
289	SAMPLE_QTY_ALLOW	☐	CRM_ACT_NUMBER_OF_SAMPLES	DEC4	DEC	4	0	Number of samples
290	.INCLUDE	☐				0	0	CUOBJ for BW DataSources
291	CUOBJ	☐	CRMT_INT_OBJ_NO	IB_INSTANCE	NUMC	18	0	Configuration (Internal Object Number)
292	CC_CATEGORY_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_DS_ACTIVITY_I	DEKOTP	CRMC_ACT_DECOT	DEKOTP
2	CRMT_BW_DS_ACTIVITY_I	ECROPT	CRMC_ACT_CURES	ECROPT
3	CRMT_BW_DS_ACTIVITY_I	FACUNIT	T006	MSEHI
4	CRMT_BW_DS_ACTIVITY_I	JOURNAL_GUID	CRMC_ACT_JRNL	JOURNAL_GUID
5	CRMT_BW_DS_ACTIVITY_I	KV_DEKO	CRMC_ACT_DECOM	KV_DEKO
6	CRMT_BW_DS_ACTIVITY_I	KV_RESULT	CRMC_ACT_RSLT	KV_RESULT
7	CRMT_BW_DS_ACTIVITY_I	MEABM	T006	MSEHI
8	CRMT_BW_DS_ACTIVITY_I	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY
9	CRMT_BW_DS_ACTIVITY_I	POSHOR	CRMC_ACT_POSHR	POSHOR
10	CRMT_BW_DS_ACTIVITY_I	POSLOC	CRMC_ACT_MPLCT	POSLOC
11	CRMT_BW_DS_ACTIVITY_I	POSQLI	CRMC_ACT_POSQL	POSQLI
12	CRMT_BW_DS_ACTIVITY_I	POSVER	CRMC_ACT_POSVR	POSVER
13	CRMT_BW_DS_ACTIVITY_I	PRAVA	CRMC_ACT_PRAVA	PRAVA
14	CRMT_BW_DS_ACTIVITY_I	PRAVB	CRMC_ACT_PRAVB	PRAVB
15	CRMT_BW_DS_ACTIVITY_I	PRPRIO	CRMC_ACT_PRPRI	PRPRIO
16	CRMT_BW_DS_ACTIVITY_I	RESREAS	CRMC_ACT_RESRS	RESREAS
17	CRMT_BW_DS_ACTIVITY_I	STATUS	CRMC_ACT_PRSTA	STATUS
18	CRMT_BW_DS_ACTIVITY_I	SUBJECTA	CRMC_ACT_SBJTA	SUBJECTA
19	CRMT_BW_DS_ACTIVITY_I	SUBJECTB	CRMC_ACT_SBJTB	SUBJECTB

History

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