SAP ADR8 X.400 Numbers (Business Address Services) Table
Overview
ADR8 is a standard SAP S/4HANA table that stores X.400 Numbers (Business Address Services) data. There are total 39 fields in the ADR8 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADR8 belongs to Address Management/Business Address (BC-SRV-ADR) module and is located in the package SAP Technology - Business Services: Address Management (SZAD).
In addition, following links provide an overview of foreign key relationships, if any, that link ADR8 to other SAP tables and standard CDS views available based on ADR8 table in S/4HANA 2020.
Techincal Settings of ADR8
Below are technical details of the table ADR8
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADR8 Fields
The following table gives you an overview of the fields available in ADR8
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| ADDRNUMBER | Address Number | AD_ADDRNUM | ADRC | CHAR | 10 |
| PERSNUMBER | Person Number | AD_PERSNUM | ADRP | CHAR | 10 |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | |
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC | 3 | |
| FLGDEFAULT | Flag: this address is the default address | AD_FLGDFAD | CHAR | 1 | |
| FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 1 | |
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR | 1 | |
| DFT_RECEIV | Flag: Recipient is standard recipient for this address | AD_DFTRCAD | CHAR | 1 | |
| R3_USER | Flag: Connected to an SAP System | AD_R3_USER | CHAR | 1 | |
| TXT_ENCODE | Required Text Data Encoding (X.400) | AD_TENCODE | CHAR | 1 | |
| TNEF | Flag: Receiver can receive TNEF encoding by X.400 | AD_TNEF8 | CHAR | 1 | |
| X4COUNTRY | X.400 country code | AD_X4CNTRY | CHAR | 3 | |
| X4ADMIN | X.400 administration domain | AD_X4ADMIN | CHAR | 16 | |
| X4PRIVD | X.400 private domain | AD_X4PRIVD | CHAR | 16 | |
| X4ORG | X.400 organization | AD_X4ORG | CHAR | 64 | |
| X4ORG1 | X.400 organizational unit 1 | AD_X4ORG1 | CHAR | 32 | |
| X4ORG2 | X.400 organizational unit 2 | AD_X4ORG2 | CHAR | 32 | |
| X4ORG3 | X.400 organizational unit 3 | AD_X4ORG3 | CHAR | 32 | |
| X4ORG4 | X.400 organizational unit 4 | AD_X4ORG4 | CHAR | 32 | |
| X4LNAME | X.400 last name | AD_X4LNAME | CHAR | 40 | |
| X4FNAME | X.400 first name | AD_X4FNAME | CHAR | 16 | |
| X4INI | X.400 Initials | AD_X4INI | CHAR | 5 | |
| X4GENER | X.400 generation | AD_X4GENER | CHAR | 3 | |
| X4X121 | X.400 X.121 network address | AD_X4X121 | CHAR | 15 | |
| X4TERMID | X.400 Terminal ID | AD_X4TRMID | CHAR | 24 | |
| X4TERMTP | X.400 terminal type | AD_X4TRMTP | CHAR | 1 | |
| X4UANUMID | X.400 user agent numeric ID | AD_X4UANID | CHAR | 32 | |
| DDA_TYPE1 | X.400 domain defined attribute, type 1 | AD_X4DDAT1 | CHAR | 8 | |
| DDA_VALUE1 | X.400 domain defined attribute, value 1 | AD_X4DDAV1 | CHAR | 128 | |
| DDA_TYPE2 | X.400 domain defined attribute, type 2 | AD_X4DDAT2 | CHAR | 8 | |
| DDA_VALUE2 | X.400 domain defined attribute, value 2 | AD_X4DDAV2 | CHAR | 128 | |
| DDA_TYPE3 | X.400 domain defined attribute, type 3 | AD_X4DDAT3 | CHAR | 8 | |
| DDA_VALUE3 | X.400 domain defined attribute, value 3 | AD_X4DDAV3 | CHAR | 128 | |
| DDA_TYPE4 | X.400 domain defined attribute, type 4 | AD_X4DDAT4 | CHAR | 8 | |
| DDA_VALUE4 | X.400 domain defined attribute, value 4 | AD_X4DDAV4 | CHAR | 128 | |
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR | 14 | |
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR | 14 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADR8
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ADR8 | ADDRNUMBER | C: CN | ADRC |
| ADR8 | CLIENT | 1: CN | T000 |
| ADR8 | PERSNUMBER | C: CN | ADRP |