SAP ABAP Table BAD_ACTIVITY_I_MESS (Messaging Structure ACTIVITY_I (Activity Journal))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ CRM_DATAEXCHANGE_BTX (Package) One Order: MBDoc, Validation, Data Exchange R/3 Sales

Basic Data

Table Category	INTTAB	Structure
Structure	BAD_ACTIVITY_I_MESS	Table Relationship Diagram
Short Description	Messaging Structure ACTIVITY_I (Activity Journal)

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

Foreign Keys

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

History

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