SAP ABAP View CRMV_IUDSMSURVEY (DSM Program Surveys View)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-DSM (Application Component) Demand Side Management
     ⤷ CRM_IU_DSM_COMMON (Package) Utilities DSM (Demand Side management) common

Basic Data

View Type	D	Database View
Database View	CRMV_IUDSMSURVEY
Short Description	DSM Program Surveys View
Root table	CRM_SVY_DB_S	CRM Surveys: Survey

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRM_SVY_DB_S	CRM_SVY_DB_S
2	CRM_SVY_DB_SD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRM_SVY_DB_S	CLIENT	JL	EQ				0	0
2	CRM_SVY_DB_SD	CLIENT	JR	EQ			AND	0	0
3	CRM_SVY_DB_S	SURVEYID	JL	EQ				0	0
4	CRM_SVY_DB_SD	SURVEYID	JR	EQ			AND	0	0
5	CRM_SVY_DB_S	SURVEYVERSION	JL	EQ				0	0
6	CRM_SVY_DB_SD	SURVEYVERSION	JR	EQ			AND	0	0
7	CRM_SVY_DB_S	APPLICATIONID		EQ	'CRM_SURVEY_DSM'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRM_SVY_DB_S	CLIENT		☐	MANDT	☐	Client
2	SURVEYID	CRM_SVY_DB_S	SURVEYID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
3	SURVEYVERSION	CRM_SVY_DB_S	SURVEYVERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
4	LANGUAGE	CRM_SVY_DB_SD	LANGUAGE		☐	CRM_SVY_DB_LANGU	☐	CRM Surveys: Language Attribute
5	DESC_SHORT	CRM_SVY_DB_SD	DESC_SHORT		☐	CRM_SVY_DB_SD_SHORT	☐	CRM Surveys: Short Description
6	STATUS	CRM_SVY_DB_SD	STATUS		☐	CRM_SVY_DB_SD_STATUS	☐	CRM Surveys: Translation Status
7	SURVEYGUID	CRM_SVY_DB_S	SURVEYGUID		☐	CRM_SVY_DB_SGUID	☐	CRM Surveys: Survey GUID
8	MASTERLANGUAGE	CRM_SVY_DB_S	MASTERLANGUAGE		☐	LANGU	☐	Language Key

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	N	Display/Maintenance Not Allowed

History

Last changed by/on	SAP	20130605
SAP Release Created in	702