SAP ABAP Table BUS051___I (BPR: Attribute table (w/o diff.type) with status information)

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	INTTAB	Structure
Structure	BUS051___I	Table Relationship Diagram
Short Description	BPR: Attribute table (w/o diff.type) with status information

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	.INCLUDE	☐				0	0	BP Relationship: Contact Person Relationship
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
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
35	.INCLUDE	☐				0	0	EEW
36	BP_EEW_BUT051_SP	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
37	ACTION	☐	BU_ACTION	BU_ACTION	CHAR	1	0	Action
38	XCHNG	☐	BU_XCHNG	XFELD	CHAR	1	0	Indicator: Data has been changed
39	LFDNR	☐	BU_LFDNR		INT4	10	0	Internal counter

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BUS051___I	ABTNR	TB910	ABTNR	REF	1	CN
2	BUS051___I	CLIENT	T000	MANDT
3	BUS051___I	PAAUTH	TB914	PAAUTH	REF	1	CN
4	BUS051___I	PAFKT	TB912	PAFKT	REF	1	CN
5	BUS051___I	PAVIP	TB916	PAVIP	REF	1	CN
6	BUS051___I	RELNR	BUT050	RELNR	KEY	1	CN
7	BUS051___I	RELTYP	TBZ9	RELTYP	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in