SDB_ER_PARAMETER SAP (Services Registery parameters (New world)) Table details

Dictionary Type: Table
Description: Services Registery parameters (New world)




ABAP Code to SELECT data from SDB_ER_PARAMETER
Related tables to SDB_ER_PARAMETER
Access table SDB_ER_PARAMETER




Table field list including key, data, relationships and ABAP select examples

SDB_ER_PARAMETER is a standard SAP Table which is used to store Services Registery parameters (New world) data and is available within R/3 SAP systems depending on the version and release level.

The SDB_ER_PARAMETER table consists of various fields, each holding specific information or linking keys about Services Registery parameters (New world) data available in SAP. These include REGISTRY (Services Registry), VERSION (Services Registry Version), PROXY_CLASS (Services Registry Proxy Class), LOGICAL_PORT (Logical Port Name).. 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: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP SDB_ER_PARAMETER 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
REGISTRYServices Registry SDEL_REGISTRYCHAR30SDOM_REGISTRY
VERSIONServices Registry Version SDEL_REGISTRY_VERSIONCHAR3
PROXY_CLASSServices Registry Proxy Class SDEL_SR_PROXY_CLASSCHAR30SDOM_SR_PROXY_CLASS
LOGICAL_PORTLogical Port Name SRT_LP_NAMECHAR60SRT_LP_CHAR60
SLD_IDSLD ID SDEL_ER_SLD_IDCHAR255
SYTEM_IDSAP system identification RSPO_SYSCHAR8SYCHAR08
DB_HOST_NAMEDB Host Name SDEL_ER_DB_HOST_NAMECHAR32HOST_ID
CLIENT_NUMBERClient number used to track client copy process SDEL_ER_CLIENT_NUMBERCHAR3CHAR3
PRIMARY_REGPrimary Services Registry SDEL_ER_PRIMARY_REGISTRYCHAR1SDOM_ER_BOOLEAN
ALT_HOST_NAMEAlternative Host Name for publication SDEL_ER_ALTERNATIVE_HOSTCHAR120SDOM_ER_ALTERNATIVE_HOST
ALT_PORTAlternative port to be used during service publication SDEL_ER_ALTERNATIVE_PORT_NAMECHAR32SDOM_ER_ALTERNATIVE_PORT_NAME
ALT_PORT_HTTPSAlternative Port https during service publication SDEL_ER_ALTERNATIVE_PORT_HTTPSCHAR32SDOM_ER_ALTERNATIVE_PORT_NAME
REVERSE_PROXYReverse proxy name SRT_REV_PRX_PROXY_NAMECHAR30SRT_REV_PROXYSRT_REV_PRX_PROXY_NAME
PUB_SCHEDULESchedule Publication of web services SDEL_SCHEDULE_PUBLICATIONCHAR3SDOM_SCHEDULE_PUBLICATION
PUB_START_DATEPublication planned date SDEL_PUBLICATION_DATEDATS8SYDATS
PUB_START_TIMEPlanned Publication time SDEL_PUBLICATION_TIMETIMS6SYTIME
PUB_FREQUENCYPublication Frequency SDTE_PUBLICATION_FREQUENCYCHAR7SDOM_PUBLICATION_FREQUENCY
PUB_JOB_IDJob ID BTCJOBCNTCHAR8CHAR8
APPL_KEYServices Registry: Client Application Key SDTE_SRT_WSP_SR_APP_KEYCHAR32SYSUUID_C
CONNECTION_TYPEConnection Type SDTE_SRT_WSP_SR_CONNECT_TYPECHAR3SDOM_SRT_WSP_SR_CONNECT_TYPE
CREATED_BYUser Name UNAMECHAR12UNAME
CREATED_ONDate of Last Change UDATUMDATS8SYDATS
CREATED_ATTime UZEITTIMS6UZEIT
CREATED_TCTransaction Code TCODECHAR20Assigned to domainTCODETCD
CREATED_CPABAP Program Name PROGRAMMCHAR40Assigned to domainPROGRAMMRID
CHANGED_BYUser Name UNAMECHAR12UNAME
CHANGED_ONDate of Last Change UDATUMDATS8SYDATS
CHANGED_ATTime UZEITTIMS6UZEIT
CHANGED_TCTransaction Code TCODECHAR20Assigned to domainTCODETCD
CHANGED_CPABAP Program Name PROGRAMMCHAR40Assigned to domainPROGRAMMRID
PRIORITY Priority for processing0

Key field Non-key field



How do I retrieve data from SAP table SDB_ER_PARAMETER using ABAP code

The following ABAP code Example will allow you to do a basic selection on SDB_ER_PARAMETER to SELECT all data from the table
DATA: WA_SDB_ER_PARAMETER TYPE SDB_ER_PARAMETER.

SELECT SINGLE *
FROM SDB_ER_PARAMETER
INTO CORRESPONDING FIELDS OF WA_SDB_ER_PARAMETER
WHERE...

How to access SAP table SDB_ER_PARAMETER

Within an ECC or HANA version of SAP you can also view further information about SDB_ER_PARAMETER and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!