SAP table BPI030 (BP: Business Partner - Address Data)

Field Description Data Type Length Decimals Checktable Data Element
ADRNR Address Number CHAR 10 0 SANS1 BP_ADRNR_OLD
ADDRNUMBER Address Number CHAR 10 0 ADRC AD_ADDRNUM
ADDRESS_ID (Not supported) Physical address ID CHAR 10 0 AD_ADDR_ID
ADR_D_E Valid-To Date of Business Partner Address Relationship DATS 8 0 BP_ADR_D_E
ADR_LOC Building CHAR 20 0 BP_ADR_LOC
FLOOR Floor CHAR 10 0 BP_FLOOR
ROOM_NR Room Number CHAR 10 0 BP_ROOM_NR
NAME3 Name 3 CHAR 40 0 BP_NAME3
NAME4 Name 4 CHAR 40 0 BP_NAME4
NAME_CO c/o Name CHAR 40 0 BP_NAME_CO
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
TELF1 First telephone number CHAR 16 0 TELF1
TELF2 Second telephone number CHAR 16 0 TELF2
TELFX1 Fax Number CHAR 31 0 TELFX
TELFX2 Fax Number CHAR 31 0 TELFX
TELBX Telebox number CHAR 15 0 TELBX
TELX1 Telex number CHAR 30 0 TELX1
DATLT Data communication line no. CHAR 14 0 DATLT
TELTX Teletex number CHAR 30 0 TELTX
ADSMTP E-Mail Address CHAR 241 0 AD_SMTPADR
TELNR_CALL1 Telephone number for determining caller CHAR 30 0 AD_TELNRCL
TELNR_CALL2 Telephone number for determining caller CHAR 30 0 AD_TELNRCL

BPI030 foreign key relationships

Table Field Check Table Check Field
0 BPI030 ADDRNUMBER ADRC Addresses (Business Address Services) DATE_FROM
0 BPI030 ADDRNUMBER ADRC Addresses (Business Address Services) NATION
1 BPI030 ADRNR SANS1 Address table MANDT