Addresses (Business Address Services) — the central address table every ADRNR/ADDRNUMBER field in the model resolves to. ADRC holds the postal name, street, city, region, country, and default-communication-method data for every business partner, customer, vendor, company code, plant, and personnel address in the system; ADR2 (telephone), ADR3 (fax), and ADR6 (e-mail) are its per-communication-type child tables, all keyed on ADDRNUMBER back to this header. SAP's real ADRC carries roughly 95 fields covering city/street-file validation, PO-box handling, and township/county extensions; this definition carries the full postal identity, key/organizational fields, language, region/country linkage, default communication flags, and the UUID/error-status fields — the set any address resolution or downstream ESG/interaction-record join actually consumes, not every not-supported legacy field.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| DML_NUM_CLV key | domicilium numerus clavis | Address number — the key every ADRNR field elsewhere in the model points to | AD_ADDRNUM | CHAR 10 | — |
| VLA_DIE_EMS key | validus ab dies emissio | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS 8 | — |
| VRS key | versio | Version ID for International Addresses | AD_NATION | CHAR 1 | TSADV |
| VLD_DIE_EMS | validus ad dies emissio | Valid-to date - in current Release only 99991231 possible | AD_DATE_TO | DATS 8 | — |
| FRM_DML_CLV | forma domicilium clavis | Form-of-Address Key | AD_TITLE | CHAR 4 | TSAD3 |
| NOM | nomen | Name 1 | AD_NAME1 | CHAR 40 | — |
| NOM2 | nomen | Name 2 | AD_NAME2 | CHAR 40 | — |
| NOM3 | nomen | Name 3 | AD_NAME3 | CHAR 40 | — |
| NOM4 | nomen | Name 4 | AD_NAME4 | CHAR 40 | — |
| NOM_CMP_FRM | nomen campus forma | Converted name field (with form of address) | AD_NAMETXT | CHAR 50 | — |
| NOM5 | nomen | c/o name | AD_NAME_CO | CHAR 40 | — |
| URB | urbs | City | AD_CITY1 | CHAR 40 | — |
| CITY2 | District | AD_CITY2 | CHAR 40 | — | |
| URB_COD | urbs codex | City postal code | AD_PSTCD1 | CHAR 10 | — |
| PO_BOX | PO Box | AD_POBX | CHAR 10 | — | |
| STREET | Street | AD_STREET | CHAR 60 | — | |
| NUM | numerus | House Number | AD_HSNM1 | CHAR 10 | — |
| STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR 40 | — | |
| LOCATION | Street 5 | AD_LCTN | CHAR 40 | — | |
| NUM_COD | numerus codex | Building (Number or Code) | AD_BLDNG | CHAR 20 | — |
| PTR_CLV | patria clavis | Country Key | LAND1 | CHAR 3 | T005 |
| LNG_CLV | lingua clavis | Language Key | SPRAS | LANG 1 | T002 |
| REG | regio | Region (State, Province, County) | REGIO | CHAR 3 | T005S |
| DML_CTS_CLV | domicilium coetus clavis | Address Group (Key) (Business Address Services) | AD_GROUP | CHAR 4 | TSAD7 |
| SORT1 | Search Term 1 | AD_SORT1 | CHAR 20 | — | |
| SORT2 | Search Term 2 | AD_SORT2 | CHAR 20 | — | |
| CLV_DML_CNL | clavis domicilium canalis | Communication Method (Key) (Business Address Services) — which of ADR2/ADR3/ADR6 etc. is the default channel | AD_COMM | CHAR 3 | TSAC |
| PRI_TEL_COD | primus telephonum codex | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR 30 | — |
| PRI_COD_NUM | primus codex numerus | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR 30 | — |
| SGN_TEL_NUM | signum telephonum numerus | Flag: Telephone number(s) maintained — points at ADR2 | AD_FLGCM02 | CHAR 1 | — |
| SGN_NUM | signum numerus | Flag: Fax number(s) maintained — points at ADR3 | AD_FLGCM03 | CHAR 1 | — |
| IDX_DML | index domicilium | Indicator: E-Mail Address(es) Maintained — points at ADR6 | AD_FLGCM06 | CHAR 1 | — |
| DML_ZTM | domicilium zona temporis | Address time zone | AD_TZONE | CHAR 6 | TTZZ |
| TRB | tributum | Tax Jurisdiction | AD_TXJCD | CHAR 15 | — |
| DML | domicilium | UUID Used in the Address | AD_UUID | RAW 16 | — |
| STA_DML | status domicilium | Error Status of Address | AD_ERR_STATUS | CHAR 1 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
CLIENT | T000 | MANDT |
COUNTRY | T005 | LAND1 |
LANGU | T002 | SPRAS |
REGION | T005S | BLAND |
TITLE | TSAD3 | TITLE |
ADDR_GROUP | TSAD7 | ADDR_GROUP |
DEFLT_COMM | TSAC | COMM_TYPE |
TIME_ZONE | TTZZ | TZONE |