SAP Function Modules
SDOK_FIND_BY_QUERY SAP Function module
SDOK_FIND_BY_QUERY is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.
See here to view full function module documentation and code listing, simply by entering the name SDOK_FIND_BY_QUERY into the relevant SAP transaction such as SE37 or SE80.
Associated Function Group:
SDCL2
Released Date:
Not Released
Processing type: Remote-Enabled
Pattern for FM SDOK_FIND_BY_QUERY - SDOK FIND BY QUERY
CALL FUNCTION 'SDOK_FIND_BY_QUERY' "
* EXPORTING
* client = SY-MANDT " sy-mandt Client
* docuspace = " sdokdocsph-docuspace Document Area
TABLES
query = " sdokquprop
* classes = " sdokclass
* result_phios = " sdokobject
* result_loios = " sdokobject
* result_relas = " sdokobject
* properties_request = " sdokproptn
* properties_result = " sdokproptl
EXCEPTIONS
BAD_CLASS = 1 " Object Class Unknown
BAD_QUERY = 2 " Incorrect Search Query
NOT_AUTHORIZED = 3 " No Authorization
. " SDOK_FIND_BY_QUERY
ABAP code example for Function Module SDOK_FIND_BY_QUERY
The ABAP code below is a full code listing to execute function module SDOK_FIND_BY_QUERY including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).
| it_query | TYPE STANDARD TABLE OF SDOKQUPROP,"TABLES PARAM |
| wa_query | LIKE LINE OF it_query , |
| it_classes | TYPE STANDARD TABLE OF SDOKCLASS,"TABLES PARAM |
| wa_classes | LIKE LINE OF it_classes , |
| it_result_phios | TYPE STANDARD TABLE OF SDOKOBJECT,"TABLES PARAM |
| wa_result_phios | LIKE LINE OF it_result_phios , |
| it_result_loios | TYPE STANDARD TABLE OF SDOKOBJECT,"TABLES PARAM |
| wa_result_loios | LIKE LINE OF it_result_loios , |
| it_result_relas | TYPE STANDARD TABLE OF SDOKOBJECT,"TABLES PARAM |
| wa_result_relas | LIKE LINE OF it_result_relas , |
| it_properties_request | TYPE STANDARD TABLE OF SDOKPROPTN,"TABLES PARAM |
| wa_properties_request | LIKE LINE OF it_properties_request , |
| it_properties_result | TYPE STANDARD TABLE OF SDOKPROPTL,"TABLES PARAM |
| wa_properties_result | LIKE LINE OF it_properties_result . |
DATA(ld_client) = 'Check type of data required'.
SELECT single DOCUSPACE
FROM SDOKDOCSPH
INTO @DATA(ld_docuspace).
"populate fields of struture and append to itab
append wa_query to it_query.
"populate fields of struture and append to itab
append wa_classes to it_classes.
"populate fields of struture and append to itab
append wa_result_phios to it_result_phios.
"populate fields of struture and append to itab
append wa_result_loios to it_result_loios.
"populate fields of struture and append to itab
append wa_result_relas to it_result_relas.
"populate fields of struture and append to itab
append wa_properties_request to it_properties_request.
"populate fields of struture and append to itab
append wa_properties_result to it_properties_result. . CALL FUNCTION 'SDOK_FIND_BY_QUERY' * EXPORTING * client = ld_client * docuspace = ld_docuspace TABLES query = it_query * classes = it_classes * result_phios = it_result_phios * result_loios = it_result_loios * result_relas = it_result_relas * properties_request = it_properties_request * properties_result = it_properties_result EXCEPTIONS BAD_CLASS = 1 BAD_QUERY = 2 NOT_AUTHORIZED = 3 . " SDOK_FIND_BY_QUERY
IF SY-SUBRC EQ 0. "All OK ELSEIF SY-SUBRC EQ 1. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 2. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 3. "Exception "Add code for exception here ENDIF.
ABAP code to compare 7.40 inline data declaration with original syntax
The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.
DATA:
| ld_client | TYPE SY-MANDT , |
| it_query | TYPE STANDARD TABLE OF SDOKQUPROP , |
| wa_query | LIKE LINE OF it_query, |
| ld_docuspace | TYPE SDOKDOCSPH-DOCUSPACE , |
| it_classes | TYPE STANDARD TABLE OF SDOKCLASS , |
| wa_classes | LIKE LINE OF it_classes, |
| it_result_phios | TYPE STANDARD TABLE OF SDOKOBJECT , |
| wa_result_phios | LIKE LINE OF it_result_phios, |
| it_result_loios | TYPE STANDARD TABLE OF SDOKOBJECT , |
| wa_result_loios | LIKE LINE OF it_result_loios, |
| it_result_relas | TYPE STANDARD TABLE OF SDOKOBJECT , |
| wa_result_relas | LIKE LINE OF it_result_relas, |
| it_properties_request | TYPE STANDARD TABLE OF SDOKPROPTN , |
| wa_properties_request | LIKE LINE OF it_properties_request, |
| it_properties_result | TYPE STANDARD TABLE OF SDOKPROPTL , |
| wa_properties_result | LIKE LINE OF it_properties_result. |
ld_client = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_query to it_query.
SELECT single DOCUSPACE
FROM SDOKDOCSPH
INTO ld_docuspace.
"populate fields of struture and append to itab
append wa_classes to it_classes.
"populate fields of struture and append to itab
append wa_result_phios to it_result_phios.
"populate fields of struture and append to itab
append wa_result_loios to it_result_loios.
"populate fields of struture and append to itab
append wa_result_relas to it_result_relas.
"populate fields of struture and append to itab
append wa_properties_request to it_properties_request.
"populate fields of struture and append to itab
append wa_properties_result to it_properties_result.
Contribute (Add Comments)
Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name SDOK_FIND_BY_QUERY or its description.