SAP ABAP Table CRMT_BW_ACTIVITY_I (Activity Item Data for BW Data Sources)

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_ACTIVITY_I	Table Relationship Diagram
Short Description	Activity Item Data for BW Data Sources

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	Activity Journal: Journal Guid
2	JOURNAL_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRMC_ACT_JRNL
3	.INCLUDE	☐				0	0	Activity: Product Reporting
4	DISCUSS	☐	CRMT_ACT_DISCUSSED	XFLAG	CHAR	1	0	Discussed
5	PRPRIO	☐	CRMT_ACT_PROD_PRIORITY	CRM_ACT_PROD_PRIORITY	CHAR	4	0	Product Priority	CRMC_ACT_PRPRI
6	STATUS	☐	CRMT_ACT_PROD_STATUS	CRM_ACT_PROD_STATUS	CHAR	4	0	Status of documented product	CRMC_ACT_PRSTA
7	PROD_HIERARCHY	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
8	.INCLUDE	☐				0	0	Activity Reporting Attributes IBU-SPECIFIC
9	.INCLUDE	☐				0	0	Activity: Product Measurement Reporting
10	LAENG	☐	COMT_LENGTH	MENG13	QUAN	13	3	Length of the Product or of the Packaging of the Product
11	BREIT	☐	COMT_WIDTH	MENG13	QUAN	13	3	Width of the Product or of the Packaging of the Product
12	HOEHE	☐	COMT_HEIGHT	MENG13	QUAN	13	3	Height of the Product or of the Packaging of the Product
13	MEABM	☐	COMT_UNIT_OF_DIMENSION	MEINS	UNIT	3	0	Unit in Which Length/Width/Height Is Measured	T006
14	.INCLUDE	☐				0	0	Activity: Product Availability Reporting
15	PRAVA	☐	CRMT_ACT_PROD_AVAILABLE_AFTER	CRM_ACT_PROD_AVAILABLE_AFTER	CHAR	3	0	Product available after visit at checkout	CRMC_ACT_PRAVA
16	PRAVB	☐	CRMT_ACT_PROD_AVAILABLE_BEFORE	CRM_ACT_PROD_AVAILABLE_BEFORE	CHAR	3	0	Product available before Visit at check out	CRMC_ACT_PRAVB
17	.INCLUDE	☐				0	0	Activity: General Reporting
18	SUBJECTA	☐	CRMT_ACT_SUBJECTA	CRM_ACT_SUBJECTA	CHAR	10	0	Free Text: Subject A	CRMC_ACT_SBJTA
19	SUBJECTB	☐	CRMT_ACT_SUBJECTB	CRM_ACT_SUBJECTB	CHAR	10	0	Free Text: Subject B	CRMC_ACT_SBJTB
20	KV_RESULT	☐	CRMT_ACT_KVRESF	CRM_ACT_KVRESF	CHAR	1	0	Result	CRMC_ACT_RSLT
21	RESREAS	☐	CRMT_ACT_RESRAS	CRM_ACT_RESRAS	CHAR	3	0	Result Reason	CRMC_ACT_RESRS
22	.INCLUDE	☐				0	0	Activity: Decoration Check Reporting
23	KV_DEKO	☐	CRMT_ACT_DECO_MATERIAL	CRM_ACT_DECO_MATERIAL	CHAR	3	0	Decoration Material	CRMC_ACT_DECOM
24	DEKOTP	☐	CRMT_ACT_DECO_TYPE	CRM_ACT_DECO_TYPE	CHAR	3	0	Decoration Type	CRMC_ACT_DECOT
25	KV_STOCK	☐	CRMT_ACT_DECO_NUMBER_ON_STOCK	DEC6	DEC	6	0	Number of Products in stocks
26	.INCLUDE	☐				0	0	Activity: Placement Check Reporting
27	POSLOC	☐	CRMT_ACT_MAIN_LOCATION	CRM_ACT_MAIN_LOCATION	CHAR	3	0	main location of placement, eg. pallet, chip etc.	CRMC_ACT_MPLCT
28	KV_ZPANZ	☐	CRMT_ACT_SECOND_PLACEMENT	DEC3	DEC	3	0	Number of Second placements
29	KV_ZPAVA	☐	CRMT_ACT_SEC_PLACEMENT_AVAIL	CRM_ACT_SDPMT	CHAR	1	0	Second Placement Available	*
30	.INCLUDE	☐				0	0	Activity: Inventory Check Reporting
31	NRMSHF	☐	CRMT_ACT_PROD_IN_MAIN_SHELF	DEC6	DEC	6	0	Number of produts in main shelf
32	NRPSHF	☐	CRMT_ACT_PROD_IN_PROM_SHELF	DEC6	DEC	6	0	Number of products in promation shelf
33	.INCLUDE	☐				0	0	Activity: Product Position Check Reporting
34	POSVER	☐	CRMT_ACT_VERTICAL_POS_IN_SHELF	CRM_ACT_VERTICAL_POS_IN_SHELF	CHAR	3	0	vertical position in shelf	CRMC_ACT_POSVR
35	POSHOR	☐	CRMT_ACT_HORIZONT_POS_IN_SHELF	CRM_ACT_HORIZONT_POS_IN_SHELF	CHAR	3	0	horizontal position in shelf	CRMC_ACT_POSHR
36	POSQLI	☐	CRMT_ACT_QUALI_OF_SHEL_POS	CRMT_ACT_QUALI_OF_SHELF_POS	CHAR	3	0	Qualification of the shelf position	CRMC_ACT_POSQL
37	ECROPT	☐	CRMT_ACT_SHELF_OPTIMIZATION	CRM_ACT_SHELF_OPTIMIZATION	CHAR	3	0	Shelf Optimization performed within an ECR agreement	CRMC_ACT_CURES
38	.INCLUDE	☐				0	0	Activity: Facing Check Reporting
39	NROFFAC	☐	CRMT_NUMBER_OF_FACING	DEC4	DEC	4	0	Number of facings
40	FACLEN	☐	CRMT_ACT_LENGTH_OF_FACING	DEC6	DEC	6	0	Length of facing
41	FACWID	☐	CRMT_ACT_WIDTH_OF_FACING	DEC6	DEC	6	0	Width of facing
42	FACDEP	☐	CRMT_ACT_DEPTH_OF_FACING	DEC4_2	DEC	6	2	Depth of facing
43	FACUNIT	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	T006
44	.INCLUDE	☐				0	0	Activity: Price_check_reporting
45	SPRICE	☐	CRMT_SALES_PRICE_IN_STORE	CRMT_ACT_CURRENCY	CURR	28	2	Sales Price in store
46	OPRICE	☐	CRMT_ACT_ORDER_PRICE_IN_STORE	CRMT_ACT_CURRENCY	CURR	28	2	Order Price in store
47	APRICE	☐	CRMT_ACTION_PRICE_IN_STORE	CRMT_ACT_CURRENCY	CURR	28	2	Promotion price in store
48	KVCURR1	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
49	.INCLUDE	☐				0	0	Activity: Pharama fields Reporting
50	PHREFNR	☐	CRMT_ACT_PHARMA_REF_NUMBER	TEXT10	CHAR	10	0	Pharmaceutical Reference Number
51	.INCLUDE	☐				0	0	Activity: Free Samples Reporting
52	STORNO	☐	STORNO	CHAR1_X	CHAR	1	0	Indicator: Data to Be Canceled
53	LBVAL	☐	CRMT_ACT_VALUE_LEFT_BEHIND	DEC13_2	DEC	15	2	Value of Samples
54	.INCLUDE	☐				0	0	Activity Managment: IBU CP fields for Activity Journals
55	EDAY_LOW_PRICE	☐	EVERYDAY_LOW_PRICE	EVERYDAY_LOW_PRICE	CURR	12	2	Everyday-Low-Price
56	LISTING_FEE	☐	LISTING_FEE	LISTING_FEE	CURR	12	2	Listing Fee
57	PRP_RANK	☐	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
58	KVCURR	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
59	.INCLUDE	☐				0	0	Activity: Structure provided for easy integration of MSA
60	PRAVA0	☐	CRMT_ACT_MSA_PRAVA0	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
61	PRAVA1	☐	CRMT_ACT_MSA_PRAVA1	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
62	PRAVA2	☐	CRMT_ACT_MSA_PRAVA2	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
63	PRAVA3	☐	CRMT_ACT_MSA_PRAVA3	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
64	PRAVA4	☐	CRMT_ACT_MSA_PRAVA4	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
65	PRAVB0	☐	CRMT_ACT_MSA_PRAVB0	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
66	PRAVB1	☐	CRMT_ACT_MSA_PRAVB1	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
67	PRAVB2	☐	CRMT_ACT_MSA_PRAVB2	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
68	PRAVB3	☐	CRMT_ACT_MSA_PRAVB3	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*
69	PRAVB4	☐	CRMT_ACT_MSA_PRAVB4	CRM_ACT_MSA_PLACEHOLDERS	CHAR	3	0	Placeholder for MSA fields	*

Foreign Keys

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

History

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