SAP ABAP Table JGPVBUT050051 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JGPVBUT050051	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RELNR	☑	BU_RELNR	BU_RELNR	CHAR	12	0	BP Relationship Number
3	PARTNER1	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
4	PARTNER2	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
5	DATE_TO	☑	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
6	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
7	RELTYP	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category	TBZ9
8	XRF	☐	BU_XRF	XFELD	CHAR	1	0	Business partner role definition instead of BP relationship
9	FNCTN	☐	BU_FNCTN	TEXT40	CHAR	40	0	Function name of partner
10	PAFKT	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	TB912
11	DPRTMNT	☐	BU_DPRTMNT	TEXT40	CHAR	40	0	Department at business partner
12	ABTNR	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department	TB910
13	PAAUTH	☐	BU_PAAUTH	BU_PAAUTH	CHAR	1	0	Partner's Authority	TB914
14	PAVIP	☐	BU_PAVIP	BU_PAVIP	CHAR	1	0	VIP Partner	TB916
15	PAREM	☐	BU_PAREM	TEXT40	CHAR	40	0	Notes for Partner
16	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
17	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
18	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
19	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
20	SMTP_ADDRESS	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
21	REL_PER	☐	BU_REL_PER	DEC3_7	DEC	10	7	Obsolete: Percentage of Capital Interest
22	REL_AMO	☐	BU_REL_AMO	WERT7V	CURR	13	2	Obsolete: Amount of Capital Interest
23	REL_CUR	☐	BU_CURRID	WAERS	CUKY	5	0	Currency Key
24	CALL_RULEID	☐	BU_RULEID_C	BU_SC_RULEID	CHAR	25	0	Identification Rule for Periodic Appointments: Calling Hours
25	VISIT_RULEID	☐	BU_RULEID_V	BU_SC_RULEID	CHAR	25	0	Identification Rule for Periodic Appointments:Visiting Hours
26	CALL_GUID	☐	BU_CALENDAR_SCHEME_CALL_GUID	SYSUUID	RAW	16	0	SAP BP: Calendar Schema GUID, Calling Hours
27	VISIT_GUID	☐	BU_CALENDAR_SCHEME_VISIT_GUID	SYSUUID	RAW	16	0	SAP BP: Calendar Schema GUID, Visiting Hours
28	BP_EEW_BUT051	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
29	BP_EEW_BUT051_SP	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JGPVBUT050051	ABTNR	TB910	ABTNR	REF	1	CN
2	JGPVBUT050051	CLIENT	T000	MANDT	KEY	1	CN
3	JGPVBUT050051	PAAUTH	TB914	PAAUTH	REF	1	CN
4	JGPVBUT050051	PAFKT	TB912	PAFKT	REF	1	CN
5	JGPVBUT050051	PARTNER1	BUT000	PARTNER	KEY	1	CN
6	JGPVBUT050051	PARTNER2	BUT000	PARTNER	KEY	1	CN
7	JGPVBUT050051	PAVIP	TB916	PAVIP	REF	1	CN
8	JGPVBUT050051	RELTYP	TBZ9	RELTYP	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in