SAP SPH_USNOLI table - SAPphone: Telephone number list for each user details in SAP


SAP SPH_USNOLI table summary

Object Name: SPH_USNOLI
Dictionary Type: Transparent table
Description: SAPphone: Telephone number list for each user


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

Details
SPH_USNOLI-CLIENT table field - Client ID

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

See all SAP tables containing field CLIENT

SPH_USNOLI-USERNAME table field - User Name in User Master Record

Description: User Name in User Master Record
Field Name: USERNAME
Data Element: XUBNAME
Data Type: CHAR
length (Dec): 12(0)
Check table: *
Conversion Routine:
Domain Name: XUBNAME
MemoryID: XUS
AppClass: SUSR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

SPH_USNOLI-COUNTER table field - SAPphone: Counter for number list

Description: SAPphone: Counter for number list
Field Name: COUNTER
Data Element: SP_COUNTER
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC02
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTER

SPH_USNOLI-TELNO table field - Telephone number

Description: Telephone number
Field Name: TELNO
Data Element: SP_TELNO
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TDTELENUM
MemoryID:
AppClass: STXD
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELNO

SPH_USNOLI-COUNTRY table field - Country/Region Key

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

SPH_USNOLI-NAME table field - SAPphone: Name of a person

Description: SAPphone: Name of a person
Field Name: NAME
Data Element: SP_PRSNAME
Data Type: CHAR
length (Dec): 55(0)
Check table:
Conversion Routine:
Domain Name: TEXT55
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

SPH_USNOLI-COMPANY table field - SAPphone: Company

Description: SAPphone: Company
Field Name: COMPANY
Data Element: SP_COMPANY
Data Type: CHAR
length (Dec): 55(0)
Check table:
Conversion Routine:
Domain Name: TEXT55
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPANY

SPH_USNOLI-REMARK table field - SAPphone: Comments

Description: SAPphone: Comments
Field Name: REMARK
Data Element: SP_REMARK
Data Type: CHAR
length (Dec): 55(0)
Check table:
Conversion Routine:
Domain Name: TEXT55
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REMARK

SPH_USNOLI-ADDRNUMBER table field - Address Number

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

See all SAP tables containing field ADDRNUMBER

SPH_USNOLI-PERSNUMBER table field - Person Number

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

See all SAP tables containing field PERSNUMBER

SPH_USNOLI-ADDR_TYPE table field - Address type (1=Organization, 2=Person, 3=Contact person)

Description: Address type (1=Organization, 2=Person, 3=Contact person)
Field Name: ADDR_TYPE
Data Element: AD_ADRTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_ADRTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDR_TYPE

SPH_USNOLI-ADDRHANDLE table field - Handle for Creating Addresses/Persons (Bus. Addr. Services)

Description: Handle for Creating Addresses/Persons (Bus. Addr. Services)
Field Name: ADDRHANDLE
Data Element: AD_HANDLE
Data Type: CHAR
length (Dec): 140(0)
Check table:
Conversion Routine:
Domain Name: TEXT140
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRHANDLE

SPH_USNOLI-PERSHANDLE table field - Handle for Creating Addresses/Persons (Bus. Addr. Services)

Description: Handle for Creating Addresses/Persons (Bus. Addr. Services)
Field Name: PERSHANDLE
Data Element: AD_HANDLE
Data Type: CHAR
length (Dec): 140(0)
Check table:
Conversion Routine:
Domain Name: TEXT140
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSHANDLE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table