SAP ABAP Table BP030 (BP: Business partner - address)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-FS-BP (Application Component) Business Partner Enhancements for Financial Services
     ⤷ FBPAR (Package) Business Partner (Treasury/Real Estate)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BP030	Table Relationship Diagram
Short Description	BP: Business partner - address

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PARTNR	☑	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
3	ADR_REF_K	☑	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
4	ADR_DAT	☑	BP_ADR_DAT	DATUM	DATS	8	0	Business partner address relationship valid from
5	.INCLUDE	☐				0	0	BP: Business Partner - Address Data
6	ADRNR	☐	BP_ADRNR_OLD	SADRNR	CHAR	10	0	Address Number	SANS1
7	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
8	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
9	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
10	ADR_LOC	☐	BP_ADR_LOC	CHAR20	CHAR	20	0	Building
11	FLOOR	☐	BP_FLOOR	CHAR10	CHAR	10	0	Floor
12	ROOM_NR	☐	BP_ROOM_NR	CHAR10	CHAR	10	0	Room Number
13	NAME3	☐	BP_NAME3	TEXT40	CHAR	40	0	Name 3
14	NAME4	☐	BP_NAME4	TEXT40	CHAR	40	0	Name 4
15	NAME_CO	☐	BP_NAME_CO	TEXT40	CHAR	40	0	c/o Name
16	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
17	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
18	.INCLUDE	☐				0	0	BP: Screen Structure Telecommunications Data
19	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
20	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
21	TELFX1	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
22	TELFX2	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
23	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
24	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
25	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
26	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
27	ADSMTP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
28	TELNR_CALL1	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
29	TELNR_CALL2	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BP030	ADDRNUMBER	ADRC	ADDRNUMBER	KEY
2	BP030	ADRNR	SANS1	ADRNR		1	CN
3	BP030	ADR_REF_K	TP14	ADR_REF	KEY	1	CN
4	BP030	MANDT	T000	MANDT	KEY	1	CN
5	BP030	PARTNR	BP000	PARTNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in