ADR6 is a standard Address Management/Business Address Transparent Table in SAP Basis application, which stores E-Mail Addresses (Business Address Services) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for ADR6. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

ADR6 — Meta Data

Description: E-Mail Addresses (Business Address Services)
Main Category: Basis
Sub Category: Address Management/Business Address
Table type: Transparent Table (TRANSP)

ADR6 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 CLIENT Client X CLNT 3 T000
    2 ADDRNUMBER Address number X CHAR 10 ADRC
    3 PERSNUMBER Person number X CHAR 10 ADRP
    4 DATE_FROM From Date X DATS 8
    5 CONSNUMBER Sequence number X NUMC 3
    6 FLGDEFAULT Standard Sender Address in this Communication Type CHAR 1
    7 FLG_NOUSE Flag: This Communication Number is Not Used CHAR 1
    8 HOME_FLAG Flag: This communication address is the home address CHAR 1
    9 SMTP_ADDR Internet mail (SMTP) address CHAR 241
    10 SMTP_SRCH E-Mail Address Search Field CHAR 20
    11 DFT_RECEIV Flag: Recipient is standard recipient for this number CHAR 1
    12 R3_USER Flag: Connected to an SAP System CHAR 1
    13 ENCODE FALSE | TRUE, Default Coding CHAR 1
    14 TNEF Flag: Receiver can receive TNEF coding via SMTP CHAR 1
    15 VALID_FROM User Valid From CHAR 14
    16 VALID_TO User Valid To CHAR 14
    17 _DATAAGING Data Filter Value for Data Aging DATS 8

SAP Help, Wiki Resources, and Forum Discussions on ADR6

Click the above link for the full list of resources and help pages, only the first few are posted below

Related Tables

TABLE Description Functional Area
ADRC Addresses (Business Address Services) Basis - Address Management/Business Address
REC_TYPE Structure with Instantiated Recipient Types 30A - Communication Services: Mail
USR21 Assign user name address key Basis - User and Authorization Management
SOMLRECI1 SAPoffice: Structure of the API Recipient List 30A - Communication Services: Mail
SODOCCHGI1 Data of an object which can be changed 30A - Communication Services: Mail
SOLISTI1 SAPoffice: Single List with Column Length 255 30A - Communication Services: Mail
SOPCKLSTI1 SAPoffice: Description of Imported Object Components 30A - Communication Services: Mail

Transaction Codes for SAP Table ADR6

TCODE Description Functional Area
SU01 User Maintenance Basis - User and Authorization Management
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SCOT SAPconnect - Administration Basis - Communication Services: Mail, Fax, SMS, Telephony
SOST SAPconnect Send Requests Basis - Use Subcomponents
SE16 Data Browser Basis - Workbench Utilities
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SE38 ABAP Editor Basis - ABAP Editor
SE37 ABAP Function Modules Basis - Function Builder

FMs for SAP Table ADR6

FM Description Functional Area
SO_NEW_DOCUMENT_ATT_SEND_API1 SAPoffice: Send new document with attachments using RFC Basis - Use Subcomponents
CONVERT_OTF Basis - SAPscript
BAPI_USER_GET_DETAIL Read User Details Basis - User and Authorization Management
SO_DOCUMENT_SEND_API1 SAPoffice: Send new document with attachments using RFC Basis - Use Subcomponents
SO_NEW_DOCUMENT_SEND_API1 SAPoffice: Send new document Basis - Use Subcomponents
SET_DOCUMENT Dokumentenattribute setzten Service - Solution Manager Implementation
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface

ABAP Reports for SAP Table ADR6

ABAP REPORT Description Functional Area
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
MAILDATA WFMC: Data Definitions for Mail SD - Output Determination
RSTXPDFT4 Converting SAPscript (OTF) or ABAP List Spool Job to PDF Basis - SAPscript
SAPMF02D Customer Master Data Logistics - Customer Master
SAPMV45A Sales Order Processing SD - Sales
SAPFM06P Print Program for Purchasing Documents MM - Purchasing
RVADOPFO INCLUDE for OPEN_FORM for SD Print Programs SD - Word Processing
RVADTABL INCLUDE for General Table Descriptions for Print Programs SD - Output Determination

BW Datasources for SAP Table ADR6

BW DATASOURCE Description Functional Area
0VENDOR_ATTR Vendor Number MM - Materials Management
2LIS_12_VCITM Delivery Item Data SD - Sales and Distribution
0FI_AR_5 Customers: Payment History FI - Accounts Receivable
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
2LIS_08TRTLP Shipment: Delivery Item Data by Section SD - Sales and Distribution
2LIS_12_VCSCL Sales-Shipping Schedule Line Delivery SD - Sales and Distribution
0FI_AR_1 Customers: Transaction figures FI - Accounts Receivable

Authorization Objects for SAP Table ADR6

AUTHORIZATION OBJECT Description Functional Area
P_PERNR HR: Master Data - Personnel Number Check
CMS_CAG Authorization object for CAG
CMS_RBL Authorization object for receivable in CMS
S_CARRID Authorization Object for Airlines
S_DATASET Authorization for file access
A_S_WERK Asset Master Data Maintenance: Company Code/Plant
S_TABU_DIS Table Maintenance (via standard tools such as SM30)
J_1IEWT_HC health check for Migration to EWT