ADR8 is a standard SAP table in SAP ECC (or) S/4HANA which stores X.400 Numbers (Business Address Services) data. There are total 39 fields in ADR8 table.This blog post provides key technical details of SAP table ADR8, including its availability across SAP S/4HANA versions and the list of CDS views for ADR8 table in SAP.
SAP HANA Table Type | Column Store |
---|---|
Buffering Permission | Buffering not allowed |
Buffering Type | No buffering |
Package | SAP Technology – Business Services: Address Management (SZAD) |
Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADR8 Table Fields
The following is the list of fields that are available in SAP ADR8 table. The key fields of the table are highlighted in color.
Field | Description | Data Element | Domain | Check Table | Data Type |
---|---|---|---|---|---|
CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
ADDRNUMBER | Address Number | AD_ADDRNUM | AD_ADDRNUM | ADRC | CHAR (10) |
PERSNUMBER | Person Number | AD_PERSNUM | AD_PERSNUM | ADRP | CHAR (10) |
DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATUM | DATS (8) | |
CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC3 | NUMC (3) | |
FLGDEFAULT | Flag: this address is the default address | AD_FLGDFAD | XFELD | CHAR (1) | |
FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | XFELD | CHAR (1) | |
HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | XFELD | CHAR (1) | |
DFT_RECEIV | Flag: Recipient is standard recipient for this address | AD_DFTRCAD | XFELD | CHAR (1) | |
R3_USER | Flag: Connected to an SAP System | AD_R3_USER | XFELD | CHAR (1) | |
TXT_ENCODE | Required Text Data Encoding (X.400) | AD_TENCODE | AD_TENCODE | CHAR (1) | |
TNEF | Flag: Receiver can receive TNEF encoding by X.400 | AD_TNEF8 | XFELD | CHAR (1) | |
X4COUNTRY | X.400 country code | AD_X4CNTRY | LAND1 | CHAR (3) | |
X4ADMIN | X.400 administration domain | AD_X4ADMIN | CHAR16 | CHAR (16) | |
X4PRIVD | X.400 private domain | AD_X4PRIVD | CHAR16 | CHAR (16) | |
X4ORG | X.400 organization | AD_X4ORG | CHAR64 | CHAR (64) | |
X4ORG1 | X.400 organizational unit 1 | AD_X4ORG1 | CHAR32 | CHAR (32) | |
X4ORG2 | X.400 organizational unit 2 | AD_X4ORG2 | CHAR32 | CHAR (32) | |
X4ORG3 | X.400 organizational unit 3 | AD_X4ORG3 | CHAR32 | CHAR (32) | |
X4ORG4 | X.400 organizational unit 4 | AD_X4ORG4 | CHAR32 | CHAR (32) | |
X4LNAME | X.400 last name | AD_X4LNAME | CHAR40 | CHAR (40) | |
X4FNAME | X.400 first name | AD_X4FNAME | CHAR16 | CHAR (16) | |
X4INI | X.400 Initials | AD_X4INI | CHAR5 | CHAR (5) | |
X4GENER | X.400 generation | AD_X4GENER | CHAR3 | CHAR (3) | |
X4X121 | X.400 X.121 network address | AD_X4X121 | CHAR15 | CHAR (15) | |
X4TERMID | X.400 Terminal ID | AD_X4TRMID | CHAR24 | CHAR (24) | |
X4TERMTP | X.400 terminal type | AD_X4TRMTP | CHAR1 | CHAR (1) | |
X4UANUMID | X.400 user agent numeric ID | AD_X4UANID | CHAR32 | CHAR (32) | |
DDA_TYPE1 | X.400 domain defined attribute, type 1 | AD_X4DDAT1 | TEXT8 | CHAR (8) | |
DDA_VALUE1 | X.400 domain defined attribute, value 1 | AD_X4DDAV1 | TEXT128 | CHAR (128) | |
DDA_TYPE2 | X.400 domain defined attribute, type 2 | AD_X4DDAT2 | TEXT8 | CHAR (8) | |
DDA_VALUE2 | X.400 domain defined attribute, value 2 | AD_X4DDAV2 | TEXT128 | CHAR (128) | |
DDA_TYPE3 | X.400 domain defined attribute, type 3 | AD_X4DDAT3 | TEXT8 | CHAR (8) | |
DDA_VALUE3 | X.400 domain defined attribute, value 3 | AD_X4DDAV3 | TEXT128 | CHAR (128) | |
DDA_TYPE4 | X.400 domain defined attribute, type 4 | AD_X4DDAT4 | TEXT8 | CHAR (8) | |
DDA_VALUE4 | X.400 domain defined attribute, value 4 | AD_X4DDAV4 | TEXT128 | CHAR (128) | |
VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | TIMESTMP | CHAR (14) | |
VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | TIMESTAMP | CHAR (14) | |
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATA_TEMPERATURE | DATS (8) |
Availability
The SAP table ADR8 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
SAP S/4HANA Version | Available? |
---|---|
1909 | Yes |
2020 | Yes |
2021 | Yes |
2022 | Yes |
2023 | Yes |
CDS Views for ADR8 table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.