SAP ABAP View JGPVBUT050051000 (IS-M: Selection View for Contact Person Relationships)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

View Type	D	Database View
Database View	JGPVBUT050051000
Short Description	IS-M: Selection View for Contact Person Relationships
Root table	BUT050	BP relationships/role definitions: General data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BUT050	BUT050
2	BUT051
3	BUT000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BUT050	CLIENT	JL	EQ				0	0
2	BUT051	CLIENT	JR	EQ			AND	0	0
3	BUT050	RELNR	JL	EQ				0	0
4	BUT051	RELNR	JR	EQ			AND	0	0
5	BUT050	PARTNER1	JL	EQ				0	0
6	BUT051	PARTNER1	JR	EQ			AND	0	0
7	BUT050	PARTNER2	JL	EQ				0	0
8	BUT051	PARTNER2	JR	EQ			AND	0	0
9	BUT050	DATE_TO	JL	EQ				0	0
10	BUT051	DATE_TO	JR	EQ			AND	0	0
11	BUT000	CLIENT	JL	EQ				0	0
12	BUT050	CLIENT	JR	EQ			AND	0	0
13	BUT000	PARTNER	JL	EQ				0	0
14	BUT050	PARTNER2	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	BUT050	CLIENT		☐	MANDT	☐	Client
2	RELNR	BUT050	RELNR		☐	BU_RELNR	☐	BP Relationship Number
3	PARTNER1	BUT050	PARTNER1		☐	BU_PARTNER	☐	Business Partner Number
4	PARTNER2	BUT050	PARTNER2		☐	BU_PARTNER	☐	Business Partner Number
5	DATE_TO	BUT050	DATE_TO		☐	BU_DATTO	☐	Validity Date (Valid To)
6	DATE_FROM	BUT050	DATE_FROM		☐	BU_DATFROM	☐	Validity Date (Valid From)
7	*	BUT051	*		☐		☐
8	-	BUT051	CLIENT		☐	MANDT	☐	Client
9	-	BUT051	RELNR		☐	BU_RELNR	☐	BP Relationship Number
10	-	BUT051	PARTNER1		☐	BU_PARTNER	☐	Business Partner Number
11	-	BUT051	PARTNER2		☐	BU_PARTNER	☐	Business Partner Number
12	-	BUT051	DATE_TO		☐	BU_DATTO	☐	Validity Date (Valid To)
13	RELTYP	BUT051	RELTYP		☐	BU_RELTYP	☐	Business Partner Relationship Category
14	XRF	BUT051	XRF		☐	BU_XRF	☐	Business partner role definition instead of BP relationship
15	FNCTN	BUT051	FNCTN		☐	BU_FNCTN	☐	Function name of partner
16	PAFKT	BUT051	PAFKT		☐	BU_PAFKT	☐	Function of partner
17	DPRTMNT	BUT051	DPRTMNT		☐	BU_DPRTMNT	☐	Department at business partner
18	ABTNR	BUT051	ABTNR		☐	BU_ABTNR	☐	Department
19	PAAUTH	BUT051	PAAUTH		☐	BU_PAAUTH	☐	Partner's Authority
20	PAVIP	BUT051	PAVIP		☐	BU_PAVIP	☐	VIP Partner
21	PAREM	BUT051	PAREM		☐	BU_PAREM	☐	Notes for Partner
22	TEL_NUMBER	BUT051	TEL_NUMBER		☐	AD_TLNMBR	☐	Telephone no.: dialling code+number
23	TEL_EXTENS	BUT051	TEL_EXTENS		☐	AD_TLXTNS	☐	Telephone no.: Extension
24	FAX_NUMBER	BUT051	FAX_NUMBER		☐	AD_FXNMBR	☐	Fax number: dialling code+number
25	FAX_EXTENS	BUT051	FAX_EXTENS		☐	AD_FXXTNS	☐	Fax no.: Extension
26	SMTP_ADDRESS	BUT051	SMTP_ADDRESS		☐	AD_SMTPADR	☐	E-Mail Address
27	REL_PER	BUT051	REL_PER		☐	BU_REL_PER	☐	Obsolete: Percentage of Capital Interest
28	REL_AMO	BUT051	REL_AMO		☐	BU_REL_AMO	☐	Obsolete: Amount of Capital Interest
29	REL_CUR	BUT051	REL_CUR		☐	BU_CURRID	☐	Currency Key
30	CALL_RULEID	BUT051	CALL_RULEID		☐	BU_RULEID_C	☐	Identification Rule for Periodic Appointments: Calling Hours
31	VISIT_RULEID	BUT051	VISIT_RULEID		☐	BU_RULEID_V	☐	Identification Rule for Periodic Appointments:Visiting Hours
32	CALL_GUID	BUT051	CALL_GUID		☐	BU_CALENDAR_SCHEME_CALL_GUID	☐	SAP BP: Calendar Schema GUID, Calling Hours
33	VISIT_GUID	BUT051	VISIT_GUID		☐	BU_CALENDAR_SCHEME_VISIT_GUID	☐	SAP BP: Calendar Schema GUID, Visiting Hours
34	BP_EEW_BUT051	BUT051	BP_EEW_BUT051		☐	DUMMY	☐	Dummy function in length 1
35	BP_EEW_BUT051_SP	BUT051	BP_EEW_BUT051_SP		☐	DUMMY	☐	Dummy function in length 1
36	BIRTHDT	BUT000	BIRTHDT		☐	BU_BIRTHDT	☐	Date of Birth of Business Partner

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	471