SAP table BP030 (BP: Business partner - address)
SAP table BP030 has 4 primary key fields being MANDT,PARTNR,ADR_REF_K,ADR_DAT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PARTNR | Business Partner Number | CHAR | 10 | 0 | BP000 | BP_PARTNR_OLD | |
| ADR_REF_K | Address ID | CHAR | 10 | 0 | TP14 | BP_ADR_REF_OLD | |
| ADR_DAT | Valid-From Date of Business Partner Address Relationship | DATS | 8 | 0 | BP_ADR_DAT | ||
| 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 |
BP030 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BP030 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | DATE_FROM |
| 0 BP030 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | NATION |
| 1 BP030 | ADRNR | SANS1 | Address table | MANDT |
| 0 BP030 | ADR_REF_K | TP14 | Business Partner: Address ID | MANDT |
| 0 BP030 | ADR_REF_K | TP14 | Business Partner: Address ID | ADR_REF |
| 1 BP030 | MANDT | T000 | Clients | MANDT |
| 0 BP030 | PARTNR | BP000 | Business Partner Master (General Data) | PARTNR |