SAP ABAP Table BUT020 (BP: Addresses)

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	BUT020	Table Relationship Diagram
Short Description	BP: Addresses

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	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
3	ADDRNUMBER	☑	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
4	.INCLUDE	☐				0	0	BP: Addresses (Data Fields Ext.)
5	.INCLUDE	☐				0	0	BP: Addresses (CHAR Data Fields External)
6	XDFADR	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
7	ADEXT	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
8	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
9	GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
10	MOVE_ADDR	☐	BU_MOVE_ADDR	AD_ADDRNUM	CHAR	10	0	Number of Move Target Address for Address Moves	*
11	.INCLUDE	☐				0	0	BP: Addresses (Non-CHAR Data Fields External)
12	DATE_FROM	☐	BU_DATE_OBSOLETE	DATUM	DATS	8	0	Date Obsolete
13	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
14	ADDR_VALID_FROM	☐	BU_ADDR_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of a Business Partner Address
15	ADDR_VALID_TO	☐	BU_ADDR_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of a Business Partner Address
16	ADDR_MOVE_DATE	☐	BU_ADDR_MOVE_DATE	TZNTSTMPS	DEC	15	0	Date of Move for Address Moves

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BUT020	ADDRNUMBER	ADRC	ADDRNUMBER	KEY	1	C
2	BUT020	CLIENT	T000	MANDT	KEY	1	CN
3	BUT020	NATION	TSADV	NATION	REF	1	CN
4	BUT020	PARTNER	BUT000	PARTNER	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in