SAP ABAP Table BUT051 (BP Relationship: Contact Person Relationship)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-BP (Application Component) Business Partner Foundation
     ⤷ S_BUPA_GENERAL (Package) SAP Business Partner: Basic Components

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BUT051	Table Relationship Diagram
Short Description	BP Relationship: Contact Person Relationship

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	BUT050
3	PARTNER1	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	PARTNER2	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	DATE_TO	☑	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
6	.INCLUDE	☐				0	0	BPR: General Data in Relationship/Role Definition Tables
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	.INCLUDE	☐				0	0	BP Relationship: Contact Person: General Data
10	FNCTN	☐	BU_FNCTN	TEXT40	CHAR	40	0	Function name of partner
11	PAFKT	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	TB912
12	DPRTMNT	☐	BU_DPRTMNT	TEXT40	CHAR	40	0	Department at business partner
13	ABTNR	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department	TB910
14	PAAUTH	☐	BU_PAAUTH	BU_PAAUTH	CHAR	1	0	Partner's Authority	TB914
15	PAVIP	☐	BU_PAVIP	BU_PAVIP	CHAR	1	0	VIP Partner	TB916
16	PAREM	☐	BU_PAREM	TEXT40	CHAR	40	0	Notes for Partner
17	.INCLUDE	☐				0	0	BP rel.: contact person: address data
18	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
19	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
20	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
21	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
22	SMTP_ADDRESS	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
23	.INCLUDE	☐				0	0	BP Relationship: Shareholding Data
24	REL_PER	☐	BU_REL_PER	DEC3_7	DEC	10	7	Obsolete: Percentage of Capital Interest
25	REL_AMO	☐	BU_REL_AMO	WERT7V	CURR	13	2	Obsolete: Amount of Capital Interest
26	REL_CUR	☐	BU_CURRID	WAERS	CUKY	5	0	Currency Key	*
27	.INCLUDE	☐				0	0	BPR: Rule IDs for Calling Rules
28	CALL_RULEID	☐	BU_RULEID_C	BU_SC_RULEID	CHAR	25	0	Identification Rule for Periodic Appointments: Calling Hours
29	VISIT_RULEID	☐	BU_RULEID_V	BU_SC_RULEID	CHAR	25	0	Identification Rule for Periodic Appointments:Visiting Hours
30	CALL_GUID	☐	BU_CALENDAR_SCHEME_CALL_GUID	SYSUUID	RAW	16	0	SAP BP: Calendar Schema GUID, Calling Hours
31	VISIT_GUID	☐	BU_CALENDAR_SCHEME_VISIT_GUID	SYSUUID	RAW	16	0	SAP BP: Calendar Schema GUID, Visiting Hours
32	.INCLUDE	☐				0	0	Extensions of Contact Person Relationship (See Note 807493)
33	BP_EEW_BUT051	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
34	.INCLUDE	☐				0	0	EEW
35	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	BUT051	ABTNR	TB910	ABTNR	REF	1	CN
2	BUT051	CLIENT	T000	MANDT	KEY	1	CN
3	BUT051	PAAUTH	TB914	PAAUTH	REF	1	CN
4	BUT051	PAFKT	TB912	PAFKT	REF	1	CN
5	BUT051	PAVIP	TB916	PAVIP	REF	1	CN
6	BUT051	RELNR	BUT050	RELNR	KEY	1	C
7	BUT051	RELTYP	TBZ9	RELTYP	KEY	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in