SAP Table BPI030
BP: Business Partner - Address Data
BPI030 (BP: Business Partner - Address Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BPI030 to other SAP tables.
BPI030 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| ADRNR | Address Number | BP_ADRNR_OLD | SANS1 | CHAR | 10 | 0 | ||
| ADDRNUMBER | Address number | AD_ADDRNUM | ADRC | CHAR | 10 | 0 | ||
| ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | 0 | |||
| ADR_D_E | Business Partner Address Relationship Valid Until | BP_ADR_D_E | DATS | 8 | 0 | |||
| ADR_LOC | Building | BP_ADR_LOC | CHAR | 20 | 0 | |||
| FLOOR | Floor | BP_FLOOR | CHAR | 10 | 0 | |||
| ROOM_NR | Room Number | BP_ROOM_NR | CHAR | 10 | 0 | |||
| NAME3 | Name 3 | BP_NAME3 | CHAR | 40 | 0 | |||
| NAME4 | Name 4 | BP_NAME4 | CHAR | 40 | 0 | |||
| NAME_CO | c/o Name | BP_NAME_CO | CHAR | 40 | 0 | |||
| PFACH | PO Box | PFACH | CHAR | 10 | 0 | |||
| PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | 0 | |||
| TELF1 | First telephone number | TELF1 | CHAR | 16 | 0 | |||
| TELF2 | Second telephone number | TELF2 | CHAR | 16 | 0 | |||
| TELFX1 | Fax Number | TELFX | CHAR | 31 | 0 | |||
| TELFX2 | Fax Number | TELFX | CHAR | 31 | 0 | |||
| TELBX | Telebox number | TELBX | CHAR | 15 | 0 | |||
| TELX1 | Telex number | TELX1 | CHAR | 30 | 0 | |||
| DATLT | Data communication line no. | DATLT | CHAR | 14 | 0 | |||
| TELTX | Teletex number | TELTX | CHAR | 30 | 0 | |||
| ADSMTP | E-Mail Address | AD_SMTPADR | CHAR | 241 | 0 | |||
| TELNR_CALL1 | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | 0 | |||
| TELNR_CALL2 | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | 0 | |||
BPI030 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BPI030 | ADDRNUMBER | SYST | MANDT | ADRC | Addresses (Business Address Services) | CLIENT |
| BPI030 | ADDRNUMBER | BPI030 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| BPI030 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| BPI030 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| BPI030 | ADRNR | BP030 | MANDT | SANS1 | Address table | MANDT |
| BPI030 | ADRNR | BPI030 | ADRNR | SANS1 | Address table | ADRNR |
