SAP ABAP Table CRMS_MKTPL_IB_DSTRC (Attributes of Campaign Distribution Trace (IBOM MKTPL))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_IB_GEN (Package) CRM Marketing: Generic objects for iBom for MKTPL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_DSTRC	Table Relationship Diagram
Short Description	Attributes of Campaign Distribution Trace (IBOM MKTPL)

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	Trace Structure Distribution Result
2	.INCLUDE	☐				0	0	Trace Structure Distribution
3	REFNUM	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
4	TRACE_INFO	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
5	.INCLUDE	☐				0	0	Value Splitting Database Structure
6	DISTRIBTYPE	☐	CRMT_MKTVL_DISTR		CHAR	4	0	Distribution Category
7	CO	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	T005
8	SO	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
9	MO	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
10	DC	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_DISTCHAN
11	DV	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	CRMC_DIVISION
12	PG	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
13	CG1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
14	CG4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
15	PRH1	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
16	PRH2	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
17	PRH3	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
18	BPH1	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
19	BPH2	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
20	BPH3	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
21	PROD	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
22	BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
23	REFNUM_PARENT	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
24	COT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
25	SOT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
26	MOT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
27	DCT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
28	DVT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
29	PGT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
30	CG1T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
31	CG4T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
32	PRH1T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
33	PRH2T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
34	PRH3T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
35	BPH1T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
36	BPH2T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
37	BPH3T	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
38	PRODT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field
39	BPT	☐	CRMT_MKTVL_TEXT	CRMT_MKTVL_TEXT	CHAR	40	0	Text Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_IB_DSTRC	CG1	CRMC_CUSTGRP1	CUST_GROUP1
2	CRMS_MKTPL_IB_DSTRC	CO	T005	LAND1
3	CRMS_MKTPL_IB_DSTRC	DC	CRMC_DISTCHAN	DISTCHAN
4	CRMS_MKTPL_IB_DSTRC	DV	CRMC_DIVISION	DIVISION
5	CRMS_MKTPL_IB_DSTRC	PG	CRMC_PRC_GRP1	PRC_GROUP1

History

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