SAP ABAP View CRMV_MKTPL_VSEXT (MDF View Extractor: Validation Sheet (MDF INI))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-MDF (Application Component) Marketing Development Funds
     ⤷ CRM_MKTPL_MDF_BW (Package) Package for BW development for MDF objects

Basic Data

View Type	D	Database View
Database View	CRMV_MKTPL_VSEXT
Short Description	MDF View Extractor: Validation Sheet (MDF INI)
Root table	CRMD_CLA_VS_VS	Table of validation sheets

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_CLA_VS_VS	CRMD_CLA_VS_VS
2	CGPL_PROJECT
3	CRMD_CLA_VS_RL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_CLA_VS_VS	CLIENT	JL	EQ				0	0
2	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
3	CRMD_CLA_VS_VS	CLIENT	JL	EQ				0	0
4	CRMD_CLA_VS_RL	CLIENT	JR	EQ			AND	0	0
5	CRMD_CLA_VS_RL	REL_OBJ_GUID	JL	EQ				0	0
6	CGPL_PROJECT	GUID	JR	EQ			AND	0	0
7	CRMD_CLA_VS_VS	VS_GUID	JL	EQ				0	0
8	CRMD_CLA_VS_RL	VS_GUID	JR	EQ			AND	0	0
9	CRMD_CLA_VS_RL	RELATION_NAME		EQ	'1'		AND	0	0
10	CRMD_CLA_VS_VS	IS_SNAPSHOT		NE	'X'		AND	0	0
11	CRMD_CLA_VS_VS	DATA_STATUS		NE	'1'		AND	0	0
12	CGPL_PROJECT	OBJECT_TYPE		EQ	'INI'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_CLA_VS_VS	CLIENT		☐	MANDT	☐	Client
2	VS_GUID	CRMD_CLA_VS_VS	VS_GUID		☐	CRM_CLA_VS_GUID	☐	GUID of a Validation Sheet
3	GUID	CGPL_PROJECT	GUID		☐	CGPL_PROJECT_GUID	☐	Project Planning: 16 Character GUID for Projects
4	IS_SNAPSHOT	CRMD_CLA_VS_VS	IS_SNAPSHOT		☐	CRM_CLA_VS_IS_SNAPSHOT	☐	Validation Sheet is Snapshot or Not
5	DATA_STATUS	CRMD_CLA_VS_VS	DATA_STATUS		☐	CRM_CLA_VS_DATA_STATUS	☐	Status of a Dataset
6	EXT_VS_GUID	CRMD_CLA_VS_VS	EXT_VS_GUID		☐	CRM_CLA_VS_EXTERNAL_ID	☐	External ID for Validation Sheet (BI Use)
7	SNAPSHOT_VERSION	CRMD_CLA_VS_VS	SNAPSHOT_VERSION		☐	CRM_MKTPL_SEM_VERSION	☐	CRM Marketing SEM Version
8	MDF_INI_ID	CGPL_PROJECT	EXTERNAL_ID		☐	CGPL_EXTID	☐	Project Planning: External Indentifier of an Element
9	OBJECT_TYPE	CGPL_PROJECT	OBJECT_TYPE		☐	CGPL_OBJECT_TYPE	☐	Object Type in Project Planning
10	MDF_INI_GUID	CRMD_CLA_VS_RL	REL_OBJ_GUID		☐	CRM_CLA_VS_REL_OBJ_GUID	☐	Unique ID of Related Object
11	RELATION_NAME	CRMD_CLA_VS_RL	RELATION_NAME		☐	CRM_CLA_VS_REL_NAME	☐	Name of Relationship of Validation Sheet to Other Objects

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	20130604
SAP Release Created in	600