SAP ABAP Table CRMS_MKTPL_CLDR_SF (CAL: Additional Search fields for Calendar Query)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-CAL (Application Component) Marketing Calendar
     ⤷ CRM_MKTPL_CALENDAR (Package) Marketing Planner calendar

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_CLDR_SF	Table Relationship Diagram
Short Description	CAL: Additional Search fields for Calendar Query

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	PG	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	CRMC_PRC_GRP1
2	PRODUCT_CAT	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
3	CATEGORY2_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
4	CUSTOMER_ID	☐	CRM_MKTPL_PLANNING_CUSTOMER		CHAR	72	0	Planning Customer ID
5	DESCR	☐	CRMT_MKTTG_SET_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of Profile Set
6	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
7	PROD_CAT_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
8	CAMP_YEAR	☐	CRM_MKTPL_YEAR	CRM_MKTPL_YEAR	CHAR	4	0	Year in the Marketing Calendar (for Query)
9	PERS_RESPONSIBLE	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
10	CAMP_DESCR	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
11	STATUS	☐	CRM_MKTPL_STATUS_TEXT	TXT30	CHAR	30	0	Campaign Status
12	HIERARCHY	☐	CRM_MKTPL_HIER	CRM_MKTPL_HIER	CHAR	1	0	Hierarchy Indicator for Marketing Calendar
13	DEAL_CUSTOMER_ID	☐	CRM_MKTPL_CUSTOMER_ID	CHAR20	CHAR	20	0	Planning Account ID
14	DEAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
15	CUSTOMERTYPE	☐	CRM_MKTPL_PLCUST_TYPE	CRM_MKTPL_PLCUST_TYPE	CHAR	2	0	Type of Account (BP, Hierarchy Node, Target Group)
16	ACTIVE_STATE	☐	CRMT_MKTPL_ACTIVE_STATE	CRM_MKTPL_ACTIVE_STATE	CHAR	10	0	Active State of Marketing Project (For Search)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_CLDR_SF	PG	CRMC_PRC_GRP1	PRC_GROUP1

History

Last changed by/on	SAP	20110908
SAP Release Created in	300