Hierarchy
⤷ BC-SRV-QUE (Application Component) SAP Query
⤷ SQUE (Package) Application Development R/3 SAP Query
Basic Data
Data Element | AQ_SEG |
Short Description | SAP Query: Logical database table |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | AQT_TNAME | |
Data Type | CHAR | Character String |
Length | 30 | |
Decimal Places | 0 | |
Output Length | 30 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | DB table |
Medium | 15 | Database table |
Long | 15 | Database table |
Heading | 35 | Logical database table |
Documentation
Definition
Logical database table name; name of a table defined in the ABAP/4 Dictionary.
Supplementary Documentation - AQ_SEG 0051
For a functional area defined using a logical database, you can change the current database segment by overwriting the segment name.
Supplementary Documentation - AQ_SEG 0070
The additional table is assinged to the table of the logical database specified here.
In query reports, the SELECT statement to the additional table is placed at the GET date of this table in the code. The position within the code at the GET date is determined by specifying the sequence.
Supplementary Documentation - AQ_SEG 0090
The ABAP/4 code for GET / GET LATE is assigned to the logical database table specified here.
In query reports, the code is placed in the GET or GET LATE event for this table. The position within the code is determined by specifying the sequence.
Supplementary Documentation - AQ_SEG 0100
The additional field is allocated to the logical database table specified here.
In query reports, the code for the additional field is placed in the GET code for this table. The position in the code is determined by specifying the sequence.
Supplementary Documentation - AQ_SEGNAME0052
Use
The current table is highlighted in the display.
Procedure
By clicking or by choosing Choose, you can switch to another table.
Examples
Dependencies
Supplementary Documentation - AQ_SEGNAME0130
Use
A table join always covers several tables. Enter here the names of the tables you want to belong to the join.
Procedure
You must define a link type (left outer, inner, right outer) between two consecutive tables in the join as follows:
- Left outer
Each data record in the first (left) table is included in the result set, even if no record exists in the second (right) table according to the link conditions. In this case, the fields in the right table are set to their initial values. - Inner:
A data record in the first (left) table is included in the result set only if a record exists in the second (right) table according to the link conditions. - Right outer:
Each data record in the second (right) table is included in the result set, even if no record exists in the first (left) table according to the link conditions. In this case, the fields in the left table are set to their initial values.
You can also define link conditions between every pair of tables involved in the table join. To do this, use the Define condition and Specify condition functions. The Define condition function defines only between which tables you want to formulate link conditions. The Sepcify condition function allows you to perform this formulation explicitly for a condition.
Note that link conditions are not absolutely necessary. In such cases, however, the Cartesian product is formed, i.e. each record in a table is combined with all records of the other table.
Examples
Dependencies
Note that the result of a table join is a sequence of records with a flat structure, although several tables make up such a join. You cannot form hierarchies with a table join. The structure of the records read correspond to a field string where the fields of the tables involved in the join are listed one after the other.
History
Last changed by/on | SAP | 20010130 |
SAP Release Created in |