SAP ABAP Table ADR2S2 (Shadow Table 2: Telephone Nos (Business Address Services))
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 ADR2S2   Table Relationship Diagram
Short Description Shadow Table 2: Telephone Nos (Business Address Services)    
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 TABLENAME AD_APPLTAB CHAR10 CHAR 10   0   Application table logical name (address management)  
3 FIELDNAME AD_APPLFLD CHAR10 CHAR 10   0   Application table address where-used list logical field name  
4 OBJKEY AD_OBJKEY SWO_TYPEID CHAR 70   0   Address owner object ID  
5 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
6 CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
7 COUNTRY AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number T005
8 FLGDEFAULT AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
9 FLG_NOUSE AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
10 HOME_FLAG AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
11 TEL_NUMBER AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
12 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
13 TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
14 TELNR_CALL AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
15 DFT_RECEIV AD_FLGSMS AD_FLGSMS CHAR 1   0   Indicator: Telephone is SMS-Enabled  
16 R3_USER AD_FLGMOB AD_FLGMOB CHAR 1   0   Indicator: Telephone is a Mobile Telephone  
17 VALID_FROM AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
18 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 ADR2S2 CLIENT T000 MANDT KEY 1 CN
2 ADR2S2 COUNTRY T005 LAND1 REF C CN
History
Last changed by/on SAP  20130604 
SAP Release Created in