SAP Table BP030
BP: Business partner - address
BP030 (BP: Business partner - address) 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 BP030 to other SAP tables.
BP030 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| PARTNR | Business Partner Number | BP_PARTNR_OLD | BP000 | CHAR | 10 | 0 | ||
| ADR_REF_K | Address ID | BP_ADR_REF_OLD | TP14 | CHAR | 10 | 0 | ||
| ADR_DAT | Business partner address relationship valid from | BP_ADR_DAT | DATS | 8 | 0 | |||
| 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 | |||
BP030 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BP030 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| BP030 | ADDRNUMBER | SYST | MANDT | ADRC | Addresses (Business Address Services) | CLIENT |
| BP030 | ADDRNUMBER | BP030 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| BP030 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| BP030 | ADRNR | BP030 | MANDT | SANS1 | Address table | MANDT |
| BP030 | ADRNR | BP030 | ADRNR | SANS1 | Address table | ADRNR |
| BP030 | ADR_REF_K | BP030 | MANDT | TP14 | Business Partner: Address ID | MANDT |
| BP030 | ADR_REF_K | BP030 | ADR_REF_K | TP14 | Business Partner: Address ID | ADR_REF |
| BP030 | MANDT | BP030 | MANDT | T000 | Clients | MANDT |
| BP030 | PARTNR | BP030 | MANDT | BP000 | Business Partner Master (General Data) | MANDT |
| BP030 | PARTNR | BP030 | PARTNR | BP000 | Business Partner Master (General Data) | PARTNR |
