SAP ABAP Table BUT050 (BP relationships/role definitions: General data)

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	BUT050	Table Relationship Diagram
Short Description	BP relationships/role definitions: General data

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
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	.INCLUDE	☐				0	0	SAB BP: General Management Data for BP Relationship
7	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
8	RELTYP	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category	*
9	XRF	☐	BU_XRF	XFELD	CHAR	1	0	Business partner role definition instead of BP relationship
10	DFTVAL	☐	BU_DFTVAL	CHAR20	CHAR	20	0	BP: Differentiation type characteristic (change doc.-rel.)
11	RLTYP	☐	BU_RLTYPE	BU_ROLE	CHAR	6	0	Business partner role (change doc.-relevant)	*
12	RELKIND	☐	BU_RELKIND	BU_RELKIND	CHAR	4	0	Business partner relationship type	*
13	CRUSR	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
14	CRDAT	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
15	CRTIM	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
16	CHUSR	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
17	CHDAT	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
18	CHTIM	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed
19	.INCLUDE	☐				0	0	BP Relationships: Time-Dependent Attributes
20	XDFREL	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
21	XDFREL2	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
22	.INCLUDE	☐				0	0	BPR: SETGUIDs for Identifying Relationship Data Records
23	DB_KEY	☐	BUP_SETGUID	SYSUUID	RAW	16	0	GP: UUID for Identifying the Data Record (SETGUID)
24	DB_KEY_TD	☐	BUP_SETGUID	SYSUUID	RAW	16	0	GP: UUID for Identifying the Data Record (SETGUID)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BUT050	CLIENT	T000	MANDT	KEY	1	CN
2	BUT050	PARTNER1	BUT000	PARTNER	KEY	1	CN
3	BUT050	PARTNER2	BUT000	PARTNER	KEY	1	CN

History

Last changed by/on	SAP	20131122
SAP Release Created in