Kontakt

Ansicht
Dokumentation

RSORADJV - Display joins of V$-, GV$- and DBA-Views (Owner SYS)

RSORADJV - Display joins of V$-, GV$- and DBA-Views (Owner SYS)

RFUMSV00 - Advance Return for Tax on Sales/Purchases   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Title

Display joins of v$-, gv$- and dba-views.

Purpose

Integration

Prerequisites

Features

Selection

Specify a SELECT statement which reads data of tables / views with owner SYS.

The syntax is as follows:
SELECT [ hint ] [ { DISTINCT | UNIQUE } | ALL ] select_list
FROM table_reference [, table_reference]...
[ WHERE condition ]
[ hierarchical_query_clause ]
[ group_by_clause ]
[ HAVING condition ]
[ { UNION | UNION ALL | INTERSECT | MINUS } ( subquery )]
[ order_by_clause ]

A hintis placed between "/*+" and "*/"

A select listhas the following syntax:
{ * |
{[table_alias.]dbfieldname | expression} alias [,[table_alias.]dbfieldname | expression} alias] ... }

An expressionwithin this select list can be every form of calculation: +, -, *, /, ||. Also unary functions are allowed (LN, MIN, AVG ...)

Syntax for a table reference is:
{(select statement) [table_alias] | table [table_alias]}

All other parts of the syntax are according to the sql standard.

Some conventions and restrictions:

  • Each column that is specified in the select list will be a column in the output list
  • If a select list element is specified with an (column) alias, this alias will be used as header text in the output list. In the other case the program uses the field name of the select list element as header text. If a select list element is an expression (no data base field), the alias is obligatory.
    ==> IMPORTANT: For every expression that is no data base field use a column alias!
  • Every column alias that is specified in the select list of a subquery can be used like a dbfieldname in the select statement.
  • If more than one table is specified in the from clause, the columns are matched to one table for reasons of unique-ness. If a column name occurs in more than one table unique-ness cannot be guaranteed. In this case you have to spacify a table alias before the column name (dbfieldname)!
    ==> IMPORTANT: When more than one table is specified, and column names that have to be outputted occur in more than one table, use a table alias!

Standard Variants

Output

The data is displayed in a table using the standard ALV grid control.

Activities

Edit statement within editor screen.

  • Parse the SELECT statement with "SQL Command -> Parse"
  • Parse and execute the SELECT statement with "SQL Command -> Execute" ==> The statement will be checked and executed; you finally get the result displayed in a ALV grid control as list.
  • Save the current SELECT statement with the button "Save as local file" to your frontend
  • Laod a (previous saved) statement with the button "Load a local file" from your frontend

Example






rdisp/max_wprun_time - Maximum work process run time   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 3437 Date: 20240601 Time: 162631     sap01-206 ( 52 ms )