SPH_EXTNSN SAP (SAPphone: Extensions per Work Center) Table details
Dictionary Type: Table
Description: SAPphone: Extensions per Work Center
Description: SAPphone: Extensions per Work Center
Table field list including key, data, relationships and ABAP select examples
SPH_EXTNSN is a standard SAP Table which is used to store SAPphone: Extensions per Work Center data and is available within R/3 SAP systems depending on the version and release level.
The SPH_EXTNSN table consists of various fields, each holding specific information or linking keys about SAPphone: Extensions per Work Center data available in SAP. These include TERMINAL (SAPphone: Work center ID), TELNO (SAPphone: Extension (Part of a Telephone Number)), SERVER (Name of SAPconnect Node or Telephony Server), TYPE (SAPphone: DN type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SPH_EXTNSN table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| CLIENT | Client ID | SYMANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| TERMINAL | SAPphone: Work center ID | SP_TERMKEY | NUMC | 20 | SPH_TERMNL | NUM20 | |||
| TELNO | SAPphone: Extension (Part of a Telephone Number) | SP_OWNTEL | CHAR | 10 | CHAR10 | ||||
| SERVER | Name of SAPconnect Node or Telephony Server | SX_NODE_ID | CHAR | 6 | SPH_SERVER | SX_NODE_ID | SXN | SX_NODE_ID | |
| TYPE | SAPphone: DN type | SP_DNTYPE | CHAR | 1 | SP_DNTYPE | ||||
| IN_USE | SAPphone: Boolean field ('X' for on, ' ' for off) | SP_BOOLEAN | CHAR | 1 | SP_BOOLEAN | ||||
| DEFAULT_NO | SAPphone: Boolean field ('X' for on, ' ' for off) | SP_BOOLEAN | CHAR | 1 | SP_BOOLEAN |
| Key field | Non-key field |
How do I retrieve data from SAP table SPH_EXTNSN using ABAP code
The following ABAP code Example will allow you to do a basic selection on SPH_EXTNSN to SELECT all data from the tableDATA: WA_SPH_EXTNSN TYPE SPH_EXTNSN.
SELECT SINGLE *
FROM SPH_EXTNSN
INTO CORRESPONDING FIELDS OF WA_SPH_EXTNSN
WHERE...
How to access SAP table SPH_EXTNSN
Within an ECC or HANA version of SAP you can also view further information about SPH_EXTNSN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects