SAP ADR2S table - Shadow Table: Telephone Numbers (Business Address Services) details in SAP

SAP ADR2S table summary

Object Name: ADR2S
Dictionary Type: Transparent table
Description: Shadow Table: Telephone Numbers (Business Address Services)

Field list for ADR2S table on an S/4 SAP system

Details

ADR2S-CLIENT table field - Client ▼

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

ADR2S-TRKORR table field - Request/Task ▼

Description: Request/Task
Field Name: TRKORR
Data Element: TRKORR
Data Type: CHAR
length (Dec): 20(0)
Check table: *
Conversion Routine:
Domain Name: TRKORR
MemoryID:
AppClass: STRW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRKORR

ADR2S-ADDRNUMBER table field - Address Number ▼

Description: Address Number
Field Name: ADDRNUMBER
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRC
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRNUMBER

ADR2S-PERSNUMBER table field - Person Number ▼

Description: Person Number
Field Name: PERSNUMBER
Data Element: AD_PERSNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRP
Conversion Routine: ALPHA
Domain Name: AD_PERSNUM
MemoryID: CDT
AppClass:
SHLP: ADDRESS
SHLP Field: PERSNUMBER
ConvExit: ALPHA

See all SAP tables containing field PERSNUMBER

ADR2S-DATE_FROM table field - Valid-from date - in current Release only 00010101 possible ▼

Description: Valid-from date - in current Release only 00010101 possible
Field Name: DATE_FROM
Data Element: AD_DATE_FR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_FROM

ADR2S-CONSNUMBER table field - Sequence Number ▼

Description: Sequence Number
Field Name: CONSNUMBER
Data Element: AD_CONSNUM
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUMC3
MemoryID:
AppClass: QSS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSNUMBER

ADR2S-COUNTRY table field - Country/Region for Telephone/Fax Number ▼

Description: Country/Region for Telephone/Fax Number
Field Name: COUNTRY
Data Element: AD_COMCTRY
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

ADR2S-FLGDEFAULT table field - Standard Sender Address in this Communication Type ▼

Description: Standard Sender Address in this Communication Type
Field Name: FLGDEFAULT
Data Element: AD_FLGDFNR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLGDEFAULT

ADR2S-FLG_NOUSE table field - Flag: This Communication Number is Not Used ▼

Description: Flag: This Communication Number is Not Used
Field Name: FLG_NOUSE
Data Element: AD_FLNOUSE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLG_NOUSE

ADR2S-HOME_FLAG table field - Recipient address in this communication type (mail sys.grp) ▼

Description: Recipient address in this communication type (mail sys.grp)
Field Name: HOME_FLAG
Data Element: AD_FLGHOME
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOME_FLAG

ADR2S-TEL_NUMBER table field - Telephone no.: dialling code+number ▼

Description: Telephone no.: dialling code+number
Field Name: TEL_NUMBER
Data Element: AD_TLNMBR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL_NUMBER

ADR2S-TEL_EXTENS table field - Telephone no.: Extension ▼

Description: Telephone no.: Extension
Field Name: TEL_EXTENS
Data Element: AD_TLXTNS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL_EXTENS

ADR2S-TELNR_LONG table field - Complete Number: Dialling Code+Number+Extension ▼

Description: Complete Number: Dialling Code+Number+Extension
Field Name: TELNR_LONG
Data Element: AD_TELNRLG
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELNR_LONG

ADR2S-TELNR_CALL table field - Telephone number for determining caller ▼

Description: Telephone number for determining caller
Field Name: TELNR_CALL
Data Element: AD_TELNRCL
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELNR_CALL

ADR2S-DFT_RECEIV table field - Indicator: Telephone is SMS-Enabled ▼

Description: Indicator: Telephone is SMS-Enabled
Field Name: DFT_RECEIV
Data Element: AD_FLGSMS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_FLGSMS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DFT_RECEIV

ADR2S-R3_USER table field - Indicator: Telephone is a Mobile Telephone ▼

Description: Indicator: Telephone is a Mobile Telephone
Field Name: R3_USER
Data Element: AD_FLGMOB
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_FLGMOB
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field R3_USER

ADR2S-VALID_FROM table field - Communication Data: Valid From (YYYYMMDDHHMMSS) ▼

Description: Communication Data: Valid From (YYYYMMDDHHMMSS)
Field Name: VALID_FROM
Data Element: AD_VALFROM
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: TIMESTMP
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALID_FROM

ADR2S-VALID_TO table field - Communication Data: Valid To (YYYYMMDDHHMMSS) ▼

Description: Communication Data: Valid To (YYYYMMDDHHMMSS)
Field Name: VALID_TO
Data Element: AD_VALTO
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: TIMESTAMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALID_TO

View list of all SAP tables(S4H/ECC)

Select data from SAP table