SAP ABAP Table ADR7 (Remote Mail Addresses (SAP - SAP - Communication; BAS))
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-SRV-ADR (Application Component) Address Management/Business Address
     SZAD (Package) SAP Technology - Business Services: Address Management
Basic Data
Table Category TRANSP    Transparent table 
Transparent table ADR7   Table Relationship Diagram
Short Description Remote Mail Addresses (SAP - SAP - Communication; BAS)    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
3 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number ADRP
4 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
5 CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
6 FLGDEFAULT AD_FLGDFNM XFELD CHAR 1   0   Flag: this name is the default name  
7 FLG_NOUSE AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
8 HOME_FLAG AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
9 SYMB_DEST AD_SYMBDST CHAR10 CHAR 10   0   Symbolic destination  
10 RECVR_TYPE AD_RCVRTYP CHAR1 CHAR 1   0   Recipient type (not currently used)  
11 UMAND AD_UMAND CHAR3 CHAR 3   0   RML- Client (Remote Mail, SAP - SAP - Communication)  
12 UNAME AD_UNAME CHAR12 CHAR 12   0   RML Name (Remote Mail, SAP - SAP - Communication)  
13 DFT_RECEIV AD_DFTRCNM XFELD CHAR 1   0   Flag: Recipient is the standard recipient for this name  
14 R3_USER AD_R3_USER XFELD CHAR 1   0   Flag: Connected to an SAP System  
15 VALID_FROM AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
16 VALID_TO AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ADR7 ADDRNUMBER ADRC ADDRNUMBER REF C CN
2 ADR7 CLIENT T000 MANDT KEY 1 CN
3 ADR7 PERSNUMBER ADRP PERSNUMBER REF C CN
History
Last changed by/on SAP  20130604 
SAP Release Created in