SAP ABAP View USS_JOIN_STH_INF (Tables USS_STH_STH_GRP, USS_STH_INFL, BUT000)

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_INF
Short Description	Tables USS_STH_STH_GRP, USS_STH_INFL, BUT000
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	BUT000

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	BUT000	CLIENT	JR	EQ			AND	0	0
3	USS_STH_INFL	SRM_PARTNER	JL	EQ				0	0
4	BUT000	PARTNER	JR	EQ			AND	0	0
5	USS_STH_STH_GRP	MANDT	JL	EQ				0	0
6	BUT000	CLIENT	JR	EQ			AND	0	0
7	USS_STH_STH_GRP	SRM_PARTNER	JL	EQ				0	0
8	BUT000	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'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	BUT000	CLIENT		☐	MANDT	☐	Client
2	PARTNER	BUT000	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
3	TYPE	BUT000	TYPE		☐	BU_TYPE	☐	Business partner category
4	INFLUENCE	USS_STH_INFL	INFLUENCE		☐	USS_Y_INFLUENCE	☐	Stakeholder Influence
5	INFLUENCE_DT_FR	USS_STH_INFL	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
6	INFLUENCE_DT_TO	USS_STH_INFL	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
7	STH_GRP	USS_STH_STH_GRP	STH_GRP		☐	USS_Y_STH_GRP	☐	Stakeholder Group
8	STH_GRP_DT_FR	USS_STH_STH_GRP	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
9	STH_GRP_DT_TO	USS_STH_STH_GRP	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
10	LEAD_GR	USS_STH_STH_GRP	LEAD_GR		☐	USS_Y_LEAD_GR	☐	Primary Stakeholder Group
11	NAME_ORG1	BUT000	NAME_ORG1		☐	BU_NAMEOR1	☐	Name 1 of organization
12	NAME_ORG2	BUT000	NAME_ORG2		☐	BU_NAMEOR2	☐	Name 2 of organization
13	NAME_LAST	BUT000	NAME_LAST		☐	BU_NAMEP_L	☐	Last name of business partner (person)
14	NAME_FIRST	BUT000	NAME_FIRST		☐	BU_NAMEP_F	☐	First name of business partner (person)
15	TITLE_ACA1	BUT000	TITLE_ACA1		☐	AD_TITLE1	☐	Academic Title: Key
16	TITLE_ACA2	BUT000	TITLE_ACA2		☐	AD_TITLE2	☐	Second academic title (key)
17	NAME_GRP1	BUT000	NAME_GRP1		☐	BU_NAMEGR1	☐	Name 1 (group)
18	NAME_GRP2	BUT000	NAME_GRP2		☐	BU_NAMEGR2	☐	Name 2 (group)
19	MC_NAME1	BUT000	MC_NAME1		☐	BU_MCNAME1	☐	Search Help Field 1 (Name 1/Last Name)
20	MC_NAME2	BUT000	MC_NAME2		☐	BU_MCNAME2	☐	Search Help Field 2 (Name 2/First Name)

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	3.1A