SAP ABAP Table CRMD_MKTPL_QUERY (CAL: Queries)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTPL_QUERY	Table Relationship Diagram
Short Description	CAL: Queries

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	QUERYGUID	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	QUERYID	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
4	QUERYNAME	☐	CRM_MKTPL_QUERY	CRM_MKTPL_QUERY	CHAR	35	0	Query
5	CAMPCLASS	☐	CRM_MKTPL_OBJ_GROUP	CHAR3	CHAR	3	0	Object Grouping for Various Object Types in Marketing	CRM_MKTPL_OGRP
6	SEARCHCRITID	☐	CRM_MKTPL_SCID	CHAR15	CHAR	15	0	Search Criteria ID	CRMC_MKTPL_SCID
7	LOGONUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
8	ROLE	☐	AGR_NAME	AGR_NAME	CHAR	30	0	Role Name	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_MKTPL_QUERY	CAMPCLASS	CRM_MKTPL_OGRP	OBJECT_GROUP	REF	1	CN
2	CRMD_MKTPL_QUERY	SEARCHCRITID	CRMC_MKTPL_SCID	SEARCHCRITID	REF	1	CN

History

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