SAP ABAP View V_CRMD_MKTPL_TTD (Database view for todos)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRMC_MKTPL (Package) CRM Marketing Planning - Customizing

Basic Data

View Type	D	Database View
Database View	V_CRMD_MKTPL_TTD
Short Description	Database view for todos
Root table	CRMC_MKTPL_TODO	CRM Marketing ToDo

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMC_MKTPL_TODO	CRMC_MKTPL_TODO
2	CRMC_MKTPL_CTYTD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMC_MKTPL_TODO	CLIENT	JL	EQ				0	0
2	CRMC_MKTPL_CTYTD	CLIENT	JR	EQ			AND	0	0
3	CRMC_MKTPL_TODO	TODO	JL	EQ				0	0
4	CRMC_MKTPL_CTYTD	TODO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMC_MKTPL_TODO	CLIENT		☐	MANDT	☐	Client
2	TODO	CRMC_MKTPL_TODO	TODO		☐	CRM_MKTPL_TODO	☐	ToDo key
3	CATEGORY	CRMC_MKTPL_TODO	CATEGORY		☐	CRMT_ACTIVITY_CATEGORY	☐	Activity Category (Communication Type)
4	PROCESS_TYPE	CRMC_MKTPL_TODO	PROCESS_TYPE		☐	CRMT_PROCESS_TYPE	☐	Business Transaction Type
5	USER_STAT_PROC	CRMC_MKTPL_TODO	USER_STAT_PROC		☐	J_STSMA	☐	Status Profile
6	CLOSEDSTAT	CRMC_MKTPL_TODO	CLOSEDSTAT		☐	CRM_MKTPL_CLOSED_STATUS	☐	Closed status for the To-Do
7	CAMP_TYPE	CRMC_MKTPL_CTYTD	CAMP_TYPE		☐	CRM_MKTPL_CAMPTYPE	☐	Type
8	PRIORITY	CRMC_MKTPL_CTYTD	PRIORITY		☐	CRM_MKTPL_TODOPRIO	☐	ToDo priority
9	MANDATORY	CRMC_MKTPL_CTYTD	MANDATORY		☐	CRM_MKTPL_TODOMAND	☐	Mandatory/optional flag
10	GEN_STATUS	CRMC_MKTPL_CTYTD	GEN_STATUS		☐	CRM_MKTPL_GEN_STATUS	☐	To-Do generation campaign status
11	TARGET_STATUS	CRMC_MKTPL_CTYTD	TARGET_STATUS		☐	CRM_MKTPL_TARGET_STATUS	☐	To-Do target campaign status
12	TGST_STSMA	CRMC_MKTPL_CTYTD	TGST_STSMA		☐	J_STSMA	☐	Status Profile
13	GENST_STSMA	CRMC_MKTPL_CTYTD	GENST_STSMA		☐	J_STSMA	☐	Status Profile

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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