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

History

Last changed by/on	SAP	20110908
SAP Release Created in	710