SAP Function Modules
STUO_GET_ORA_SYS_TABLE SAP Function module
STUO_GET_ORA_SYS_TABLE 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 STUO_GET_ORA_SYS_TABLE into the relevant SAP transaction such as SE37 or SE80.
Associated Function Group:
STUO
Released Date:
Not Released
Processing type: Remote-Enabled
Pattern for FM STUO_GET_ORA_SYS_TABLE - STUO GET ORA SYS TABLE
CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE' "
EXPORTING
orasystabn = " extents_ti-db_object
* wclause = " tst04help-wclause
IMPORTING
curr_time = " sy-uzeit
curr_date = " sy-datum
curr_system = " tst04inst-db_instanc
TABLES
orasystab = " liste
orasystabhead = " orasystabh
* tab_sel = " orasystabh Oracle System Table (V$ table)
EXCEPTIONS
TABLE_NOT_FOUND = 1 "
REPORT_GENERATION_ERROR = 2 "
STATEMENT_NOT_EXECUTABLE = 3 "
WRONG_DATABASE = 4 "
. " STUO_GET_ORA_SYS_TABLE
ABAP code example for Function Module STUO_GET_ORA_SYS_TABLE
The ABAP code below is a full code listing to execute function module STUO_GET_ORA_SYS_TABLE 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).
| ld_curr_time | TYPE SY-UZEIT , |
| ld_curr_date | TYPE SY-DATUM , |
| ld_curr_system | TYPE TST04INST-DB_INSTANC , |
| it_orasystab | TYPE STANDARD TABLE OF LISTE,"TABLES PARAM |
| wa_orasystab | LIKE LINE OF it_orasystab , |
| it_orasystabhead | TYPE STANDARD TABLE OF ORASYSTABH,"TABLES PARAM |
| wa_orasystabhead | LIKE LINE OF it_orasystabhead , |
| it_tab_sel | TYPE STANDARD TABLE OF ORASYSTABH,"TABLES PARAM |
| wa_tab_sel | LIKE LINE OF it_tab_sel . |
DATA(ld_orasystabn) = some text here
DATA(ld_wclause) = some text here
"populate fields of struture and append to itab
append wa_orasystab to it_orasystab.
"populate fields of struture and append to itab
append wa_orasystabhead to it_orasystabhead.
"populate fields of struture and append to itab
append wa_tab_sel to it_tab_sel. . CALL FUNCTION 'STUO_GET_ORA_SYS_TABLE' EXPORTING orasystabn = ld_orasystabn * wclause = ld_wclause IMPORTING curr_time = ld_curr_time curr_date = ld_curr_date curr_system = ld_curr_system TABLES orasystab = it_orasystab orasystabhead = it_orasystabhead * tab_sel = it_tab_sel EXCEPTIONS TABLE_NOT_FOUND = 1 REPORT_GENERATION_ERROR = 2 STATEMENT_NOT_EXECUTABLE = 3 WRONG_DATABASE = 4 . " STUO_GET_ORA_SYS_TABLE
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 ELSEIF SY-SUBRC EQ 4. "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_curr_time | TYPE SY-UZEIT , |
| ld_orasystabn | TYPE EXTENTS_TI-DB_OBJECT , |
| it_orasystab | TYPE STANDARD TABLE OF LISTE , |
| wa_orasystab | LIKE LINE OF it_orasystab, |
| ld_curr_date | TYPE SY-DATUM , |
| ld_wclause | TYPE TST04HELP-WCLAUSE , |
| it_orasystabhead | TYPE STANDARD TABLE OF ORASYSTABH , |
| wa_orasystabhead | LIKE LINE OF it_orasystabhead, |
| ld_curr_system | TYPE TST04INST-DB_INSTANC , |
| it_tab_sel | TYPE STANDARD TABLE OF ORASYSTABH , |
| wa_tab_sel | LIKE LINE OF it_tab_sel. |
ld_orasystabn = some text here
"populate fields of struture and append to itab
append wa_orasystab to it_orasystab.
ld_wclause = some text here
"populate fields of struture and append to itab
append wa_orasystabhead to it_orasystabhead.
"populate fields of struture and append to itab
append wa_tab_sel to it_tab_sel.
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 STUO_GET_ORA_SYS_TABLE or its description.