SAP ABAP Table CRMT_ACTIVITY_I_ADD_FIELDS (Activity Reporting Attributes IBU-SPECIFIC)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ACT (Application Component) Activity Management
     ⤷ CRM_ACTIVITY_I (Package) CRM Activity Item Data

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ACTIVITY_I_ADD_FIELDS	Table Relationship Diagram
Short Description	Activity Reporting Attributes IBU-SPECIFIC

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

History

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