back to top

SAP ADR6 Table – E-Mail Addresses (Business Address Services)

The ADR6 table in SAP ERP or S/4HANA stores E-Mail Addresses (Business Address Services) data. There are total 17 fields in ADR6 table. The E-Mail Addresses (Business Address Services) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ADR6 table. It is in SAP Technology – Business Services: Address Management (SZAD) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.

SAP ADR6 Table Fields

Following is the list of fields that are available in SAP ADR6 table. The primary key fields of the table are CLIENT (Client), ADDRNUMBER (Address Number), PERSNUMBER (Person Number), DATE_FROM (Valid-from date – in current Release only 00010101 possible), CONSNUMBER (Sequence Number).

Field Description Data Element Check Table Data Type
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)
SMTP_ADDR E-Mail Address AD_SMTPADR CHAR (241)
SMTP_SRCH E-Mail Address Search Field AD_SMTPAD2 CHAR (20)
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)
ENCODE Required Data Encoding (E-Mail) AD_ENCODE CHAR (1)
TNEF Flag: Receiver can receive TNEF encoding by SMTP AD_TNEF6 CHAR (1)
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)