Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-SRV-QUE (Application Component) SAP Query⤷
SQUE (Package) Application Development R/3 SAP Query
Basic Data
| Data Element | AQ_SEGNAME |
| Short Description | SAP Query: Table name |
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 | Table |
| Medium | 15 | Table |
| Long | 40 | Table |
| Heading | 55 | Name of a table |
Documentation
Definition
Name of a logical database table, name of a table in a table join, as well as the name of a table defined in the ABAP/4 Dictionary.
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 |
