SAP Function Module GET_ORA_SYS_TABLE
Get Information about the V$-Tables
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The Function Module GET_ORA_SYS_TABLE (Get Information about the V$-Tables) is a standard Function Module in SAP ERP and is part of the function group SADV within the package STUN.
Technical Information
| Function Module | GET_ORA_SYS_TABLE |
| Short Text | Get Information about the V$-Tables |
| Function Group | SADV |
| Package | STUN |
| Module Type | Remote-Enabled |
Importing Parameters
These are the IMPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| NO_ROWS | TYPE | DBMSGORA-LINE | 100 | Anzahl der anzuzeigenden Zeilen |
| SELECT_COLUMNS1 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS2 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS3 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS4 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS5 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS6 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS7 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SELECT_COLUMNS8 | TYPE | DBMSGORA-MSGDESC | Verkettung aller zu selektierenden Spaltennamen | |
| SORT_COLUMN | TYPE | DBMSGORA-MSGDESC | Spalte, nach der sortiert werden soll | |
| SORT_DATA_TYPE | TYPE | DBMSGORA-SEVERITY | 'C' | Datentyp der 'SORT_COLUMN': C oder P |
| SORT_ORDER | TYPE | DBMSGORA-SEVERITY | Sortierungstyp: aufsteigend(A) - absteigend(D) | |
| TABLE_NAME | TYPE | EXTENTS_TI-DB_OBJECT | Tabellenname | |
| WCLAUSE1 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE10 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE2 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE3 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE4 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE5 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE6 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE7 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE8 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause | |
| WCLAUSE9 | LIKE | TST04HELP-WCLAUSE | Verkettung der Where clause |
Exporting Parameters
These are the EXPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| CURR_DATE | LIKE | SY-DATUM | Datum und Zeit, aktuelles (Applikationsserver-)Datum | |
| CURR_SYSTEM | LIKE | TST04INST-DB_INSTANC | Datenbank-Instanz (OPS) | |
| CURR_TIME | LIKE | SY-UZEIT | Datum und Zeit, aktuelle (Applikationsserver-) Uhrzeit |
Changing Parameters
This function module does not define any CHANGING parameters.
Table Parameters
These are the TABLE parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| ORASYSTAB | LIKE | LISTE | List structur for transferring Log informations | |
| ORASYSTABHEAD | LIKE | ORASYSTABH | Oracle System Table (V$-Table) | |
| SEL_FIELDS | LIKE | ORASYSTABH | Oracle System Table (V$-Table) |
Exceptions
This function module does not define any Exceptions.