SAP ABAP View USS_JOIN_STH_07 (Tables USS_STH_INFL, USS_STH_STH_GRP, USS_STH_SHARE)

Hierarchy

☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-SEM-SRM (Application Component) Stakeholder Relationship Management
     ⤷ USS (Package) SEM-SRM: Stakeholder Relationship Management

Basic Data

View Type	D	Database View
Database View	USS_JOIN_STH_07
Short Description	Tables USS_STH_INFL, USS_STH_STH_GRP, USS_STH_SHARE
Root table	USS_STH_INFL	SEM-SRM: Influence of Stakeholders

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	USS_STH_INFL	USS_STH_INFL
2	USS_STH_STH_GRP
3	USS_STH_SHARE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	USS_STH_INFL	MANDT	JL	EQ				0	0
2	USS_STH_SHARE	MANDT	JR	EQ			AND	0	0
3	USS_STH_INFL	SRM_PARTNER	JL	EQ				0	0
4	USS_STH_SHARE	SRM_PARTNER	JR	EQ			AND	0	0
5	USS_STH_STH_GRP	MANDT	JL	EQ				0	0
6	USS_STH_SHARE	MANDT	JR	EQ			AND	0	0
7	USS_STH_STH_GRP	SRM_PARTNER	JL	EQ				0	0
8	USS_STH_SHARE	SRM_PARTNER	JR	EQ			AND	0	0
9	USS_STH_INFL	SYS_STATUS		NE	'D'		AND	0	0
10	USS_STH_STH_GRP	SYS_STATUS		NE	'D'		AND	0	0
11	USS_STH_SHARE	SYS_STATUS		NE	'D'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	USS_STH_INFL	MANDT		☐	MANDT	☐	Client
2	SRM_PARTNER	USS_STH_INFL	SRM_PARTNER		☐	USS_Y_SRM_PARTNER	☐	Stakeholder
3	INFLUENCE	USS_STH_INFL	INFLUENCE		☐	USS_Y_INFLUENCE	☐	Stakeholder Influence
4	INFLUENCE_DT_FR	USS_STH_INFL	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
5	INFLUENCE_DT_TO	USS_STH_INFL	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
6	STH_GRP	USS_STH_STH_GRP	STH_GRP		☐	USS_Y_STH_GRP	☐	Stakeholder Group
7	STH_GRP_DT_FR	USS_STH_STH_GRP	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
8	STH_GRP_DT_TO	USS_STH_STH_GRP	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
9	LEAD_GR	USS_STH_STH_GRP	LEAD_GR		☐	USS_Y_LEAD_GR	☐	Primary Stakeholder Group
10	SHARE_DT_FR	USS_STH_SHARE	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
11	SHARE_DT_TO	USS_STH_SHARE	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
12	NUMSHARES	USS_STH_SHARE	NUMSHARES		☐	USS_Y_NUMSHARES_PART	☐	Number of Company Shares Held
13	SID	USS_STH_SHARE	SID		☐	USS_Y_SID	☐	Security ID Number

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	20140121
SAP Release Created in	31A