SAP Table SPH_SRVALL
SAPphone: Server - all attributes
SPH_SRVALL (SAPphone: Server - all attributes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SPH_SRVALL to other SAP tables.
SPH_SRVALL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SERVER | Name of SAPconnect Node or Telephony Server | SX_NODE_ID | SPH_SERVER | CHAR | 6 | 0 | ||||||
| RFC_DEST | RFC destination | SP_RFCDEST | CHAR | 32 | 0 | |||||||
| FLAG_CANON | Processing in Canonical Number Format | SP_CANONIC | CHAR | 1 | 0 |
Possible values
|
||||||
| PRAEFIX | SAPphone: Number Prefix | SP_PRAEFIX | CHAR | 24 | 0 | |||||||
| INTNUMLEN | SAPphone: Number of Digits in Extension | SP_NUMLEN | INT1 | 3 | 0 | |||||||
| LOCALSERV | Telephony Server for Local Work Center | SP_LOCAL | CHAR | 1 | 0 |
Possible values
|
||||||
| WS_VERSION | SAPphone: Version number for work center software | SP_VERSION | CHAR | 8 | 0 | |||||||
| SET_END | SAPphone: Server reports end of incoming call | SP_SET_END | CHAR | 1 | 0 |
Possible values
|
||||||
| LANGU | Language Key | SPRAS | LANG | 1 | 0 | |||||||
| DESCRIPT | SAPphone: Description | SP_DESCRPT | CHAR | 50 | 0 | |||||||
| COUNTRY | Country Key | LAND1 | CHAR | 3 | 0 | |||||||
| ACTIVE | SAPphone: Server is ready for use | SP_ACTIVE | CHAR | 1 | 0 |
Possible values
|
||||||
| FLAG_BATCH | SAPphone: Boolean field ('X' for on, ' ' for off) | SP_BOOLEAN | CHAR | 1 | 0 |
Possible values
|
||||||
| EXTGROUP | SAPphone: Sequential number for extension number groups | SP_EXGRKEY | CHAR | 10 | 0 | |||||||
| EXTGR_DESC | Language-dependent description of an extension number group | SP_EXGRDES | CHAR | 50 | 0 | |||||||
| LSTCHGUSER | Last Changed by | AS4USER | CHAR | 12 | 0 | |||||||
| LSTCHGDATE | Date of Last Change | AS4DATE | DATS | 8 | 0 | |||||||
| F_DO_MON | Node/server is to be monitored by the alert monitor | F_DO_MON | CHAR | 1 | 0 |
Possible values
|
||||||
| SITE | SAPphone: Site Description | SP_SITE | CHAR | 25 | 0 | |||||||
| TYPE | SKSM Entry Type: Dynamic, Static,... | SP_TYPE | CHAR | 1 | 0 | |||||||
| F_PHONE | SAPphone: Server Responsible for Telephony | SP_F_PHONE | CHAR | 1 | 0 |
Possible values
|
||||||
| F_DIALER | SAPphone: Server Contains Dialer Functions | SP_F_DIALR | CHAR | 1 | 0 |
Possible values
|
||||||
| F_STAT | SAPphone: Server Contains Statistic Functions | SP_F_STAT | CHAR | 1 | 0 |
Possible values
|
||||||
| DEL_ZERO | SAPphone: Delete leading '0' of inbound number | SP_DELZERO | CHAR | 1 | 0 |
Possible values
|
||||||
SPH_SRVALL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SPH_SRVALL | SERVER | * | SPH_SERVER | SAPphone: Telephony server settings | CLIENT | |
| SPH_SRVALL | SERVER | SPH_SRVALL | SERVER | SPH_SERVER | SAPphone: Telephony server settings | SERVER |
