SAP ABAP View USS_BPSONST_VIEW (BuPa Role SRM: Values in Connected Tables)

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_BPSONST_VIEW
Short Description	BuPa Role SRM: Values in Connected Tables
Root table	BUT000	BP: General data I

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BUT000	BUT000
2	USS_STAKEHOLDER
3	USS_STH_STH_GRP
4	USS_STH_INFL
5	USS_STH_COVER
6	BUT100

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	USS_STAKEHOLDER	MANDT	JL	EQ				0	0
2	BUT000	CLIENT	JR	EQ			AND	0	0
3	USS_STAKEHOLDER	SRM_PARTNER	JL	EQ				0	0
4	BUT000	PARTNER	JR	EQ			AND	0	0
5	USS_STAKEHOLDER	MANDT	JL	EQ				0	0
6	USS_STH_STH_GRP	MANDT	JR	EQ			AND	0	0
7	USS_STAKEHOLDER	SRM_PARTNER	JL	EQ				0	0
8	USS_STH_STH_GRP	SRM_PARTNER	JR	EQ			AND	0	0
9	USS_STAKEHOLDER	MANDT	JL	EQ				0	0
10	USS_STH_INFL	MANDT	JR	EQ			AND	0	0
11	USS_STAKEHOLDER	SRM_PARTNER	JL	EQ				0	0
12	USS_STH_INFL	SRM_PARTNER	JR	EQ			AND	0	0
13	USS_STAKEHOLDER	MANDT	JL	EQ				0	0
14	USS_STH_COVER	MANDT	JR	EQ			AND	0	0
15	USS_STAKEHOLDER	SRM_PARTNER	JL	EQ				0	0
16	USS_STH_COVER	SRM_PARTNER	JR	EQ			AND	0	0
17	USS_STAKEHOLDER	MANDT	JL	EQ				0	0
18	BUT100	MANDT	JR	EQ			AND	0	0
19	USS_STAKEHOLDER	SRM_PARTNER	JL	EQ				0	0
20	BUT100	PARTNER	JR	EQ			AND	0	0
21	BUT000	XDELE		EQ	' '		AND	0	0
22	BUT100	RLTYP		EQ	'SRM000'		AND	0	0
23	USS_STAKEHOLDER	SYS_STATUS		NE	'D'		AND	0	0
24	USS_STH_STH_GRP	SYS_STATUS		NE	'D'		AND	0	0
25	USS_STH_INFL	SYS_STATUS		NE	'D'		AND	0	0
26	USS_STH_COVER	SYS_STATUS		NE	'D'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	USS_STAKEHOLDER	MANDT		☐	MANDT	☐	Client
2	SRM_PARTNER	USS_STAKEHOLDER	SRM_PARTNER		☐	USS_Y_SRM_PARTNER	☐	Stakeholder
3	SRM_POSIT	USS_STAKEHOLDER	SRM_POSIT		☐	USS_Y_SRM_POSIT	☐	Position of Stakeholder
4	FIN_CENTER	USS_STAKEHOLDER	FIN_CENTER		☐	USS_Y_FIN_CENTER	☐	Financial Center
5	SYS_STATUS_STAKE	USS_STAKEHOLDER	SYS_STATUS		☐	USS_Y_SYS_STATUS	☐	SRM: Status of Tables
6	TYPE	BUT000	TYPE		☐	BU_TYPE	☐	Business partner category
7	MC_NAME1	BUT000	MC_NAME1		☐	BU_MCNAME1	☐	Search Help Field 1 (Name 1/Last Name)
8	MC_NAME2	BUT000	MC_NAME2		☐	BU_MCNAME2	☐	Search Help Field 2 (Name 2/First Name)
9	BU_SORT1	BUT000	BU_SORT1		☐	BU_SORT1	☐	Search term 1 for business partner
10	BU_SORT2	BUT000	BU_SORT2		☐	BU_SORT2	☐	Search term 2 for business partner
11	RLTYP	BUT100	RLTYP		☐	BU_PARTNERROLE	☐	BP Role
12	DFVAL	BUT100	DFVAL		☐	BU_DFVAL	☐	BP: Differentiation type value
13	COVERAGE	USS_STH_COVER	COVERAGE		☐	USS_Y_COVERAGE	☐	Coverage of the Stakeholder
14	SYS_STATUS_COVER	USS_STH_COVER	SYS_STATUS		☐	USS_Y_SYS_STATUS	☐	SRM: Status of Tables
15	INFLUENCE	USS_STH_INFL	INFLUENCE		☐	USS_Y_INFLUENCE	☐	Stakeholder Influence
16	VALID_DT_FR_INFL	USS_STH_INFL	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
17	VALID_DT_TO_INFL	USS_STH_INFL	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
18	SYS_STATUS_INFL	USS_STH_INFL	SYS_STATUS		☐	USS_Y_SYS_STATUS	☐	SRM: Status of Tables
19	STH_GRP	USS_STH_STH_GRP	STH_GRP		☐	USS_Y_STH_GRP	☐	Stakeholder Group
20	VALID_DT_FR_GRP	USS_STH_STH_GRP	VALID_DT_FR		☐	USS_Y_DATEFROM	☐	Validity Date From
21	VALID_DT_TO_GRP	USS_STH_STH_GRP	VALID_DT_TO		☐	USS_Y_DATETO	☐	Validity Date To
22	LEAD_GR	USS_STH_STH_GRP	LEAD_GR		☐	USS_Y_LEAD_GR	☐	Primary Stakeholder Group
23	SYS_STATUS_GRP	USS_STH_STH_GRP	SYS_STATUS		☐	USS_Y_SYS_STATUS	☐	SRM: Status of Tables

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