SAP TABLES | Basis Components | Basis Services / Communication Interfaces | Address Management/Business Address(BC-SRV-ADR) SAP BC

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







ADR6 is a standard SAP Table which is used to store E-Mail Addresses (Business Address Services) data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP ADR6 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type)
See here for more information about this and other SAP enhancement categories


SAP ADR6 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
CLIENTMANDTCLNT3 T000Client
ADDRNUMBERAD_ADDRNUMCHAR10 ADRCAddress numberALPHA
PERSNUMBERAD_PERSNUMCHAR10 ADRPPerson numberALPHA
DATE_FROMAD_DATE_FRDATS8 Valid-from date - in current Release only 00010101 possible
CONSNUMBERAD_CONSNUMNUMC3 Sequence Number
FLGDEFAULTAD_FLGDFADCHAR1 Flag: this address is the default address
FLG_NOUSEAD_FLNOUSECHAR1 Flag: This Communication Number is Not Used
HOME_FLAGAD_FLGHOMECHAR1 Recipient address in this communication type (mail sys.grp)
SMTP_ADDRAD_SMTPADRCHAR241 E-Mail AddressSXIDN
SMTP_SRCHAD_SMTPAD2CHAR20 E-Mail Address Search Field
DFT_RECEIVAD_DFTRCADCHAR1 Flag: Recipient is standard recipient for this address
R3_USERAD_R3_USERCHAR1 Flag: Connected to an SAP System
ENCODEAD_ENCODECHAR1 Desired Data Coding (E-Mail)
TNEFAD_TNEF6CHAR1 Flag: Receiver can receive TNEF coding via SMTP
VALID_FROMAD_VALFROMCHAR14 Communication Data: Valid From (YYYYMMDDHHMMSS)
VALID_TOAD_VALTOCHAR14 Communication Data: Valid To (YYYYMMDDHHMMSS)



Key field
Non-key field