SAP ABAP View SEPM_SDDL_REV_J (Erzeugt aus Ddl Source SEPM_SDDL_REVIEW_JOIN)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_EPM_CDS_TEST (Package) Package for CDS test objects and demo examples

Basic Data

View Type	D	Database View
Database View	SEPM_SDDL_REV_J
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_REVIEW_JOIN
Root table	SEPM_SDDL_REV_HD	Generated Table for View

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SEPM_SDDL_REV_HD	SEPM_SDDL_REV_HD
2	SEPM_SDDL_PROD
3	SEPM_SDDL_REV_I
4	SEPM_V_CONTACT
5	DDDDLCHARTYPES
6	DDDDLCURRTYPES

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SEPM_SDDL_REV_HD	MANDT	JL	EQ				0	0
2	SEPM_SDDL_PROD	MANDT	JR	EQ			AND	0	0
3	SEPM_SDDL_REV_HD	RELATED_ENTITY_KEY	JL	EQ				0	0
4	SEPM_SDDL_PROD	PRODUCT_KEY	JR	EQ			AND	0	0
5	SEPM_SDDL_REV_HD	MANDT	JL	EQ				0	0
6	SEPM_SDDL_REV_I	MANDT	JR	EQ			AND	0	0
7	SEPM_SDDL_REV_HD	REVIEW_KEY	JL	EQ				0	0
8	SEPM_SDDL_REV_I	REVIEW_HEADER_KEY	JR	EQ			AND	0	0
9	SEPM_SDDL_REV_HD	MANDT	JL	EQ				0	0
10	SEPM_V_CONTACT	MANDT	JR	EQ			AND	0	0
11	SEPM_SDDL_REV_I	RATED_BY_CONTACT_KEY	JL	EQ				0	0
12	SEPM_V_CONTACT	CONTACT_KEY	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SEPM_SDDL_REV_HD	MANDT		☐	MANDT	☐	Client
2	REVIEW_KEY	SEPM_SDDL_REV_HD	REVIEW_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	AVERAGE_RATING	SEPM_SDDL_REV_HD	AVERAGE_RATING		☐	SNWD_RATING	☐	EPM: Review Rating
4	RELATED_ENTITY_KEY	SEPM_SDDL_REV_HD	RELATED_ENTITY_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
5	RELATED_BUSINESS_OBJECT_NAME	SEPM_SDDL_REV_HD	RELATED_BUSINESS_OBJECT_NAME		☐	SNWD_BO_NAME	☐	EPM: Business Object Name
6	NUMBER_OF_REVIEWS	SEPM_SDDL_REV_HD	NUMBER_OF_REVIEWS		☐		☐
7	ENTITY_IS_PRODUCT	SEPM_SDDL_REV_HD	ENTITY_IS_PRODUCT		☐		☐
8	PRODUCT_ID	DDDDLCHARTYPES	CCHAR10		☐		☐
9	PRODUCT_PRICE	DDDDLCURRTYPES	CURR15_2		☐		☐
10	PRODUCT_CURRENCY	DDDDLCHARTYPES	CCUKY		☐		☐
11	REVIEW_ITEM_KEY	SEPM_SDDL_REV_I	REVIEW_ITEM_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
12	RATED_BY_LOGIN_NAME	SEPM_V_CONTACT	LOGIN_NAME		☐	SYUNAME	☐	User Name
13	RATED_BY_CONTACT_KEY	SEPM_SDDL_REV_I	RATED_BY_CONTACT_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
14	RATING_TITLE	SEPM_SDDL_REV_I	RATING_TITLE		☐	SNWD_RATING_TITLE	☐	EPM: Rating Title
15	RATING_TEXT	SEPM_SDDL_REV_I	RATING_TEXT		☐	SNWD_RATING_TEXT	☐	EPM: Rating Text
16	RATING	SEPM_SDDL_REV_I	RATING		☐	SNWD_RATING	☐	EPM: Review Rating
17	NUMBER_OF_MARKED_AS_HELPFUL	SEPM_SDDL_REV_I	NUMBER_OF_MARKED_AS_HELPFUL		☐		☐
18	NUMBER_OF_MARKED_TOTAL	SEPM_SDDL_REV_I	NUMBER_OF_MARKED_TOTAL		☐		☐

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	DDIC	20150523
SAP Release Created in	740