SAP /SYCLO/SD_ADDRESS_TEL_STR table - SD: Telephone Numbers (Business Address Services) details in SAP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Description: Data Filter Value for Data Aging
Field Name: _DATAAGING
Data Element: DATA_TEMPERATURE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATA_TEMPERATURE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field _DATAAGING