SAP ABAP Table SPH_USNOLI (SAPphone: Telephone number list for each user)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     ⤷ SPHO (Package) SAPphone: Telephone Integration in R/3

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SPH_USNOLI	Table Relationship Diagram
Short Description	SAPphone: Telephone number list for each user

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	SYMANDT	MANDT	CLNT	3	0	Client ID	*
2	USERNAME	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
3	COUNTER	☑	SP_COUNTER	NUMC02	NUMC	2	0	SAPphone: Counter for number list
4	.INCLUDE	☐				0	0	SAPphone: Telephone numbers with name and description
5	TELNO	☐	SP_TELNO	TDTELENUM	CHAR	30	0	Telephone number
6	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
7	NAME	☐	SP_PRSNAME	TEXT55	CHAR	55	0	SAPphone: Name of a person
8	COMPANY	☐	SP_COMPANY	TEXT55	CHAR	55	0	SAPphone: Company
9	REMARK	☐	SP_REMARK	TEXT55	CHAR	55	0	SAPphone: Comments
10	.INCLUDE	☐				0	0	Structure with reference key fields and address type
11	.INCLUDE	☐				0	0	Structure with reference key fields and address type
12	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
13	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
14	ADDR_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
15	.INCLUDE	☐				0	0	Reference handle field structure
16	ADDRHANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
17	PERSHANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)

History

Last changed by/on	SAP	20130604
SAP Release Created in