Hierarchy
⤷ BC-SRV-QUE (Application Component) SAP Query
⤷ SQUE (Package) Application Development R/3 SAP Query
Basic Data
Data Element | AQ_OUTER |
Short Description | SAP Query: Link for table join |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | AQS_C1 | |
Data Type | CHAR | Character String |
Length | 1 | |
Decimal Places | 0 | |
Output Length | 1 | |
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 | 0 | |
Medium | 10 | Outer flag |
Long | 0 | |
Heading | 1 | O |
Supplementary Documentation - AQ_OUTER 0130
Use
If you select this field, you define a left outer join between the two tables.
This means that 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.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_OUTER 1130
Use
If you select this field, you define an inner join between the two tables.
This means that 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.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_OUTER 2130
Use
If you select this field, you define a right outer join between the two tables.
This means that 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.
Procedure
Examples
Dependencies
History
Last changed by/on | SAP | 20010130 |
SAP Release Created in |