1. Home
  2. Resources
  3. SAP Tables
  4. ADR8 - X.400 Numbers (Business Address Services)

SAP Table ADR8

X.400 Numbers (Business Address Services)

ADR8 (X.400 Numbers (Business Address Services)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADR8 to other SAP tables.

ADR8 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ADDRNUMBER Address number AD_ADDRNUM ADRC CHAR 10 0
PERSNUMBER Person number AD_PERSNUM ADRP CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
CONSNUMBER Sequence Number AD_CONSNUM NUMC 3 0
FLGDEFAULT Flag: this address is the default address AD_FLGDFAD CHAR 1 0
X Yes
NULL No
FLG_NOUSE Flag: This Communication Number is Not Used AD_FLNOUSE CHAR 1 0
X Yes
NULL No
HOME_FLAG Recipient address in this communication type (mail sys.grp) AD_FLGHOME CHAR 1 0
X Yes
NULL No
DFT_RECEIV Flag: Recipient is standard recipient for this address AD_DFTRCAD CHAR 1 0
X Yes
NULL No
R3_USER Flag: Connected to an SAP System AD_R3_USER CHAR 1 0
X Yes
NULL No
TXT_ENCODE Desired text data coding (X.400) AD_TENCODE CHAR 1 0
0 NONE
1 T61
TNEF Flag: Receiver can receive TNEF coding via X.400 AD_TNEF8 CHAR 1 0
X Yes
NULL No
X4COUNTRY X.400 country code AD_X4CNTRY CHAR 3 0
X4ADMIN X.400 administration domain AD_X4ADMIN CHAR 16 0
X4PRIVD X.400 private domain AD_X4PRIVD CHAR 16 0
X4ORG X.400 organization AD_X4ORG CHAR 64 0
X4ORG1 X.400 organizational unit 1 AD_X4ORG1 CHAR 32 0
X4ORG2 X.400 organizational unit 2 AD_X4ORG2 CHAR 32 0
X4ORG3 X.400 organizational unit 3 AD_X4ORG3 CHAR 32 0
X4ORG4 X.400 organizational unit 4 AD_X4ORG4 CHAR 32 0
X4LNAME X.400 last name AD_X4LNAME CHAR 40 0
X4FNAME X.400 first name AD_X4FNAME CHAR 16 0
X4INI X.400 Initials AD_X4INI CHAR 5 0
X4GENER X.400 generation AD_X4GENER CHAR 3 0
X4X121 X.400 X.121 network address AD_X4X121 CHAR 15 0
X4TERMID X.400 Terminal ID AD_X4TRMID CHAR 24 0
X4TERMTP X.400 terminal type AD_X4TRMTP CHAR 1 0
X4UANUMID X.400 user agent numeric ID AD_X4UANID CHAR 32 0
DDA_TYPE1 X.400 domain defined attribute, type 1 AD_X4DDAT1 CHAR 8 0
DDA_VALUE1 X.400 domain defined attribute, value 1 AD_X4DDAV1 CHAR 128 0
DDA_TYPE2 X.400 domain defined attribute, type 2 AD_X4DDAT2 CHAR 8 0
DDA_VALUE2 X.400 domain defined attribute, value 2 AD_X4DDAV2 CHAR 128 0
DDA_TYPE3 X.400 domain defined attribute, type 3 AD_X4DDAT3 CHAR 8 0
DDA_VALUE3 X.400 domain defined attribute, value 3 AD_X4DDAV3 CHAR 128 0
DDA_TYPE4 X.400 domain defined attribute, type 4 AD_X4DDAT4 CHAR 8 0
DDA_VALUE4 X.400 domain defined attribute, value 4 AD_X4DDAV4 CHAR 128 0
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) AD_VALFROM CHAR 14 0
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) AD_VALTO CHAR 14 0

ADR8 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADR8 ADDRNUMBER * ADRC Addresses (Business Address Services) NATION
ADR8 ADDRNUMBER ADR8 CLIENT ADRC Addresses (Business Address Services) CLIENT
ADR8 ADDRNUMBER ADR8 ADDRNUMBER ADRC Addresses (Business Address Services) ADDRNUMBER
ADR8 ADDRNUMBER * ADRC Addresses (Business Address Services) DATE_FROM
ADR8 CLIENT ADR8 CLIENT T000 Clients MANDT
ADR8 PERSNUMBER ADR8 CLIENT ADRP Persons (Business Address Services) CLIENT
ADR8 PERSNUMBER ADR8 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
ADR8 PERSNUMBER * ADRP Persons (Business Address Services) DATE_FROM
ADR8 PERSNUMBER * ADRP Persons (Business Address Services) NATION