SODSPROF SAP (Presettings for access to LDAP service) Table details
Dictionary Type: Table
Description: Presettings for access to LDAP service
Description: Presettings for access to LDAP service
Table field list including key, data, relationships and ABAP select examples
SODSPROF is a standard SAP Table which is used to store Presettings for access to LDAP service data and is available within R/3 SAP systems depending on the version and release level.
The SODSPROF table consists of various fields, each holding specific information or linking keys about Presettings for access to LDAP service data available in SAP. These include RFC_DEST (Specify RFC destination for SAP LDAP gateway), HOST (Host name of LDAP service), PORT (Port number of LDAP service), BASE_DN (Basic node for LDAP directory service).. 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: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SODSPROF 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
RFC_DEST | Specify RFC destination for SAP LDAP gateway | SODSDEST | CHAR | 255 | SOC255 | ||||
HOST | Host name of LDAP service | SODSHOST | CHAR | 255 | SOC255 | ||||
PORT | Port number of LDAP service | SODSPORT | INT4 | 10 | SOI | ||||
BASE_DN | Basic node for LDAP directory service | SODSBASEDN | CHAR | 255 | SOC255 | ||||
BIND_DN | Logon name for LDAP service | SODSBINDDN | CHAR | 255 | SOC255 | ||||
BIND_PW | Password for access to LDAP service | SODSBINDPW | CHAR | 255 | SOC255 | ||||
TIME_LIMIT | Time limit for search in LDAP service | SODSTIME | INT4 | 10 | SOI | ||||
SIZE_LIMIT | Max. no. of hits for search in LDAP service | SODSSIZE | INT4 | 10 | SOI | ||||
DEREFNEVER | No dereferencing of LDAP alias nodes | SODSDRFN | CHAR | 1 | SOC1 | ||||
DEREFBASE | Dereference LDAP alias nodes only for basic nodes | SODSDRFB | CHAR | 1 | SOC1 | ||||
DEREFOTHER | Dereference all LDAP nodes except basic nodes | SODSDRFO | CHAR | 1 | SOC1 | ||||
DEREFALWAY | Dereference all LDAP alias nodes | SODSDRFA | CHAR | 1 | SOC1 | ||||
BINDATONCE | Immediate logon to LDAP directory service | SODSATONCE | CHAR | 1 | SOC1 | ||||
BINDDIALOG | Logon dialog for call to LDAP service | SODSDIALOG | CHAR | 1 | SOC1 | ||||
ALL_ATTRS | All LDAP attributes should be read | SODSALLATT | CHAR | 1 | SOC1 | ||||
TYPES_ONLY | Only read attribute types (w/o value) from LDAP service | SODSTYPONL | CHAR | 1 | SOC1 | ||||
REFERRALS | Links to other LDAP services should be followed | SODSRFRLS | CHAR | 1 | SOC1 | ||||
HOP_LIMIT | Maximum no. of LDAP services to be followed | SODSHPLIM | INT4 | 10 | SOI | ||||
LDAP_VRSN | LDAP version number | SODSVRSN | INT4 | 10 | SOI | ||||
REBIND0 | Execute new logon anonymously | SODSRBND0 | CHAR | 1 | SOC1 | ||||
REBIND1 | Retain logon data | SODSRBND1 | CHAR | 1 | SOC1 |
Key field | Non-key field |
How do I retrieve data from SAP table SODSPROF using ABAP code
The following ABAP code Example will allow you to do a basic selection on SODSPROF to SELECT all data from the tableDATA: WA_SODSPROF TYPE SODSPROF.
SELECT SINGLE *
FROM SODSPROF
INTO CORRESPONDING FIELDS OF WA_SODSPROF
WHERE...
How to access SAP table SODSPROF
Within an ECC or HANA version of SAP you can also view further information about SODSPROF 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