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

  • Enhance 0VENDOR_ATTR with e-mail address from ADR6 | SCN

    I need to enhance 0VENDOR_ATTR with e-mail address of the vendor. Email address can be obtained from ADR6 table.

    http://scn.sap.com/message/9413906

  • Fix E-MAIL data (table ADRP or ADR6) | SCN

    We work with a Z transaction called ZSOST (copy from SOST) which sends e-mail via internet for a user e-mail address.

    http://scn.sap.com/message/3813214

  • Vendor replication error (ADRCOMC<->ADR6) | SCN

    We have schedule so that the vendor replication (bbpupdvd) should run every night. At the initial load we did not make any entries for the e-mail for some of the vendors. When looking in SE16 and ADRCOMC I miss an entry for INT (e-mail) on the vendor, BUT in adrc6 there is an e-mail on the same adress-nr? When I manuelly try to insert an entry in BP I get an error message: "Database error changing ...

    http://scn.sap.com/thread/303015

  • Relation between knb1 and ADR6 | SCN

    I´m searching for the relation between the table KNB1 and the ADR6 to find the email of a customer, but I´m having serious problems.

    http://scn.sap.com/message/3642454

  • Innner join among ekko,usr21 and ADR6 | SCN

    Hi all,

    I have to join ekko,usr21 and ADR6 table.

    i want ernam from ekko, PERSNUMBER/ADDRNUMBER from table USR21

    SMTP_ADDR from ADR6.

    Can any one help me for writing inner join qureey for this.

    thanks in advance.

    Best Regards,

    oorvi

    http://scn.sap.com/message/7036862

  • ADR6 table | SCN

    I have a requirement to save the e-mail of a partner, but this needs to be sales order dependent address.

    http://scn.sap.com/message/4567647

  • How to update the email address of the vendor in ADR6 table

    Hi All, We are trying to update the email address of the vendor and for this we have written the following code... but somehow it's not working.. I went to FK03 but the email address is still the old one... can you please suggest if I am missing something:

    http://scn.sap.com/message/8202952

  • SQVI - Table join bet KNA1, ADRC and ADR6 | SCN

    I have created a query using SQVI and using the table join of KNA1, ADRC and ADR6. The connecting point between KNA! and ADRC is KUNNR and ADDR. And the connetion between ADRC and ADR6 is between ADDR and ADDR.

    http://scn.sap.com/message/6236217

  • With which transation can we maintain table ADR6 | SCN

    do you mean SAP user? in this case try transaction SU01. If you mean employee, as HR master data, then you can try PA30.

    http://scn.sap.com/message/5614223

  • Impact from delete record from ADR6 | SCN

    Hello Friends,

    Have requierment to delete the record from ADR6 table. If i use query

    Delete * table ADR6 where PERSNUMBER = i_ PERSNUMBER.

    then is there any impact on other table or some where else.

    http://scn.sap.com/message/6860342

  • Link between LFA1 and ADR6 - Toolbox for IT Groups

    Have you searched for the strings ADR or ADDR? They may be called Address or Address number.

    http://sap.ittoolbox.com/groups/technical-functional/sap-dev/link-between-lfa1-and-adr6-3096184


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
CONVERT_ABAPSPOOLJOB_2_PDF Basis - SAPscript
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

Most searched SAP Basis Components Tables