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
- Business Partner Tables
- Roles Tables
- Users List Tables
- Transport Requests Tables
- Unit Of Measure Tables
- Partner Functions Tables
- Address Tables
- Authorization Objects Tables
- Background Job Tables
- Idoc Tables
- Exchange Rate Tables
- User Name Tables
- Workflow Tables
- Email Address Tables
- User Groups Tables
- Task List Tables
- Su01 Tables
- Idoc Segment Tables
- Rfc Tables
- Language Tables
- Table Name Tables
- Change Log Tables