SAP ABAP Table CRMT_MKTVL_SEL_GUID (GUID Assignment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_VALUE_SPLITTING (Package) CRM_MKTPL_VALUE_SPLITTING

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTVL_SEL_GUID	Table Relationship Diagram
Short Description	GUID Assignment

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	DISTLINEGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
2	.INCLUDE	☐				0	0	Value Splitting Database Structure
3	DISTRIBTYPE	☐	CRMT_MKTVL_DISTR		CHAR	4	0	Distribution Category
4	CO	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	T005
5	SO	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
6	MO	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
7	DC	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_DISTCHAN
8	DV	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	CRMC_DIVISION
9	PG	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
10	CG1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
11	CG4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
12	PRH1	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
13	PRH2	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
14	PRH3	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
15	BPH1	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
16	BPH2	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
17	BPH3	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
18	PROD	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
19	BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*

Foreign Keys

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

History

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