SAP ABAP Table SPH_EXTNSN (SAPphone: Extensions per Work Center)

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_EXTNSN	Table Relationship Diagram
Short Description	SAPphone: Extensions per Work Center

Delivery and Maintenance

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

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	TERMINAL	☑	SP_TERMKEY	NUM20	NUMC	20	0	SAPphone: Work center ID	SPH_TERMNL
3	TELNO	☑	SP_OWNTEL	CHAR10	CHAR	10	0	SAPphone: Extension (Part of a Telephone Number)
4	SERVER	☑	SX_NODE_ID	SX_NODE_ID	CHAR	6	0	Name of SAPconnect Node or Telephony Server	SPH_SERVER
5	TYPE	☐	SP_DNTYPE	SP_DNTYPE	CHAR	1	0	SAPphone: DN type
6	IN_USE	☐	SP_BOOLEAN	SP_BOOLEAN	CHAR	1	0	SAPphone: Boolean field ('X' for on, ' ' for off)
7	DEFAULT_NO	☐	SP_BOOLEAN	SP_BOOLEAN	CHAR	1	0	SAPphone: Boolean field ('X' for on, ' ' for off)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPH_EXTNSN	SERVER	SPH_SERVER	SERVER
2	SPH_EXTNSN	TERMINAL	SPH_TERMNL	TERMINAL	KEY	1	N

History

Last changed by/on	SAP	20130604
SAP Release Created in