SAP PIQ_ADTEL table - Telephone Numbers (Auxiliary Structure) details in SAP

SAP PIQ_ADTEL table summary

Object Name: PIQ_ADTEL
Dictionary Type: Structure
Description: Telephone Numbers (Auxiliary Structure)

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

Details

PIQ_ADTEL-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

PIQ_ADTEL-STD_NO table field - Standard Sender Address in this Communication Type ▼

Description: Standard Sender Address in this Communication Type
Field Name: STD_NO
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 STD_NO

PIQ_ADTEL-TELEPHONE table field - Telephone no.: dialling code+number ▼

Description: Telephone no.: dialling code+number
Field Name: TELEPHONE
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 TELEPHONE

PIQ_ADTEL-EXTENSION table field - Telephone no.: Extension ▼

Description: Telephone no.: Extension
Field Name: EXTENSION
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 EXTENSION

PIQ_ADTEL-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

PIQ_ADTEL-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

PIQ_ADTEL-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

PIQ_ADTEL-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

PIQ_ADTEL-ADDRESSID table field - Address Identification Number (ISR) ▼

Description: Address Identification Number (ISR)
Field Name: ADDRESSID
Data Element: PIQADDRESSID
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESSID

View list of all SAP tables(S4H/ECC)

Select data from SAP table