SAP ADR8S Shadow Table: X.400 Numbers (Business Address Services) Table
Overview
ADR8S is a standard SAP S/4HANA table that stores Shadow Table: X.400 Numbers (Business Address Services) data. There are total 39 fields in the ADR8S table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADR8S 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 ADR8S to other SAP tables and standard CDS views available based on ADR8S table in S/4HANA 2020.
Techincal Settings of ADR8S
Below are technical details of the table ADR8S
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADR8S Fields
The following table gives you an overview of the fields available in ADR8S
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| TRKORR | Request/Task | TRKORR | * | CHAR | 20 |
| 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 |
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 ADR8S
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ADR8S | ADDRNUMBER | C: CN | ADRC |
| ADR8S | CLIENT | 1: CN | T000 |
| ADR8S | PERSNUMBER | C: CN | ADRP |