Hierarchy
⤷ BC-SRV-QUE (Application Component) SAP Query
⤷ SQUE (Package) Application Development R/3 SAP Query
Basic Data
Data Element | AQ_MARK |
Short Description | SAP Query: Checkbox |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | AQT_FLAG | |
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 | 10 | Selection |
Medium | 20 | Checkbox |
Long | 40 | Checkbox |
Heading | 55 | Checkbox |
Documentation
Definition
Switch attributes or functions on/off.
Supplementary Documentation - AQ_MARK 0050
Use
Procedure
If you select this field, the query is executed online.
Examples
Dependencies
If you specify a variant name in the field Variant, this is the report variant executed.
Supplementary Documentation - AQ_MARK 0052
Use
If you select this field, fixed point arithmetic is switched on in all reports generated for queries via this InfoSet. When you define the code in the functional area (additional fields, GET event code, and so on), note that switching fixed point arithmetic on or off can affect your specifications.
The default setting for fixed point arithmetic is switched on.
Procedure
Examples
Dependencies
Note that changing the fixed point arithmetic status can have far-reaching effects for all queries that have already been created using this InfoSet. Therefore, always try to avoid this kind of change.
Supplementary Documentation - AQ_MARK 0053
Use
Only if the graphic Query Painter is not in use.
Procedure
Many screens have several variants. Here, you can define which of these screens you want to be displayed first in the navigation process.
If you select this field, the first screen to be displayed is the screen which contains help texts for the possible entries.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0070
Use
You can use this to stop the summation of these fields for numeric fields in InfoSet Query.
Example
The age of an employee.
Supplementary Documentation - AQ_MARK 0100
Use
Selection of functional groups from which fields are required when defining the query.
Procedure
Select the functional groups from which you want to display or process fields in the basic list, statistics or ranked lists.
Examples
Dependencies
On the next screen, the fields of all selected functional groups are displayed for further selection. If you did not select functional groups, the fields of the functional groups marked in the column Edited are displayed on the following screen. Even if no functional group is selected in this column, the fields of all functional groups are displayed on the next screen.
Supplementary Documentation - AQ_MARK 0101
Use
When you select this field, the field names of the fields in the given functional areas are scanned.
You can thus search for fields that contain specific information.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0110
Use
Selection of fields required when defining the query
Procedure
Select the fields you want to display or process in the basic list, statistics or ranked lists.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0120
Use
Procedure
Select the numeric fields for which you want to output the total at the end of the basic list and, if sort criteria exist, sub-totals at the end of each control level.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0121
Use
Procedure
Select those fields for which you want to define an additional selection criterion.
Examples
Dependencies
Selections already exist for some fields through the database (see the Database structure function in the Environment menu).
Supplementary Documentation - AQ_MARK 0130
Use
Procedure
If you select this field, the line is highlighted. In other cases, it is output normally.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0135
Use
If this option is set, then the displayed selection is a required entry field.
Supplementary Documentation - AQ_MARK 0136
Use
If the option is set, then the displayed selection is a selection from the logical database.
Supplementary Documentation - AQ_MARK 0137
Use
If this option is set, you will automatically see this selection in the selection screen when you call InfoSet Query. The option is automatically set for the required entry fields.
Supplementary Documentation - AQ_MARK 0150
Use
Procedure
If you select this field, you can define special output formats which differ from the output format for the rest of the line.
Examples
Dependencies
You specify the format on a subsequent screen.
Supplementary Documentation - AQ_MARK 0160
Use
Procedure
If you select this field, sorting is performed in descending order. In other cases, it is in ascending order.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0170
Use
You use this option to determine whether a query should access an additional table using a variant at runtime.
If the 'internal buffer' option is not set (this is the default setting) the system uses a SELECT SINGLE statement to read values from the additional table. This statement is only not executed if the previous SELECT SINGLE statement read exactly the same table entry (that is, if the key fields have not changed).
If you have set the 'internal buffer' option, the system creates an internal table with the same structure as the additional table. Then , each time you need a record from the additional table, it looks to see whether that record already exists in the internal table. If it is not, it executes the SELECT SINGLE statement, and places the record that it reads into the internal table. This ensures that each record from the additional table is only read once from the database table. However, this increases the memory requirement, since the system needs to store the records that it reads from the additional table in the internal table.
It will not be appropriate to use the 'internal buffer' option in every case.
- You should use the 'internal buffer' option when you expect that a query will read records from the additional table more than once. A typical example of this are tables containing long texts.
- You should not use the 'internal buffer' option if you expect the entries in an additional table only to be read once during a query.
- If you are using very wide additional tables, you must bear in mind that the records read may be truncated in an internal table.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0180
Use
Procedure
If you select this field, the list is displayed on the screen when you execute the query.
However, you can also pass on a list or the data generated for its creation without displaying the list on the screen beforehand.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0181
Use
You can use this to switch on the automatic text identification. If the option is set, an attempt is made to generate a text for the field using the entered LIKE reference.
The result of the text search is entered in the field "Text field". InfoSet users can then use values as well as field texts in reporting.
Supplementary Documentation - AQ_MARK 0185
Use
During the generation of query reports, access to database tables is optimized by reading from the tables only those fields that the query really needs. Information that enables the system to determine which fields these are, must be stored in the functional areas. If this information is incomplete, the query may return incorrect results. This is because not all of the required fields are recognized, and the values in the fields are not read from the database.
To establish whether all the necessary information is in fact stored in the functional area, you can switch off the access-optimization function. The query reports are then generated by reading the values from all the fields in the database tables.
Procedure
If you suspect that a query is returning inaccurate results, switch off the access-optimization function and restart the query. If the query delivers accurate results once the access-optimization function has been switched off, you need to modify the relevant functional area, because it lacks the information necessary to apply the access-optimization function.
Examples
Dependencies
The only way to switch off the access-optimization function is in the Title, Format screen under Extras -> Optimization On/Off.
Switch off the access-optimization function as described above, for test purposes only. As a rule, each query must be generated using the access optimization function, since this considerably reduces the runtime.
Supplementary Documentation - AQ_MARK 0190
Use
Procedure
If you select this field, the values in the graphic are indicated by different colors.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0200
Use
Procedure
If you select this field, the statistic is sorted by the relevant sort criterion in descending order. In other cases, it is sorted in ascending order.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0210
Use
Procedure
If you select this field, the field specified on the left is chosen as a ranked list criterion. The ranked list is sorted by the ranked list criterion.
Examples
Dependencies
Every ranked list must contain exactly one ranked list criterion. Only one numeric field can be used as a ranked list criterion.
Supplementary Documentation - AQ_MARK 0220
Use
If you select this field, the local field will have the same attributes as the next (reference) field specified. Reference fields are addressed by their short names.
The attributes inherited from the reference field determine the type (non-numeric, numeric, date or time) and length of the field. If the reference field is a currency amount field or a quantity field, this attribute is also passed to the local field. In this case, the local field itself becomes the currency amount field or the quantity field and has the same currency or unit reference as the reference field. If you want to assign the attributes of a currency amount field or a quantity field to a local field, you can do this only as described, i.e. using a reference field.
Fields defined as symbols or icons cannot be used as reference fields.
Procedure
If you select this field, you must also specify a reference field.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 0230
Use
Procedure
If you select this field, the field specified on the left is highlighted in the list.
Examples
Dependencies
If you do not make any specification (i.e. highlighted or otherwise), the intensity attribute of the line applies.
You may only select one of the attributes, not both at the same time.
Supplementary Documentation - AQ_MARK 0240
Use
Selection of fields for which you want to define an additional selection criterion.
Procedure
Select the fields for which you want an additional selection criterion.
Examples
Dependencies
Please note that selections have already been defined for a number of fields through the logical database (see the Database structure function in the Environment menu).
Supplementary Documentation - AQ_MARK 0242
Use
If this checkbox is set, you can only enter one single value for this selection field.
Multiple selection and interval entries are not offered for this field.
Dependencies
Example
Supplementary Documentation - AQ_MARK 0500
Use
Work mode setting.
Procedure
If you select this field, the system performs a complete comparison. This means that all texts are offered for processing, regardless of whether they have already been compared or not.
Examples
Dependencies
For language comparison, you must choose no more (or less) than one mode.
Supplementary Documentation - AQ_MARK 0501
Use
Work mode setting.
Procedure
If you select this field, the only texts you see for comparison are those that have not been processed.
Examples
Dependencies
For language comparison, you must choose no more (or less) than one mode.
Supplementary Documentation - AQ_MARK 0502
Use
Work mode setting.
Procedure
If you select this field, you can define the texts you want to compare yourself. From a list of all texts, you select those you require.
Examples
Dependencies
For language comparison, you must choose no more (or less) than one mode.
Supplementary Documentation - AQ_MARK 0503
Use
Work mode setting.
Procedure
If you select this field, the system checks whether there are texts that have not been compared and outputs an appropriate message.
Examples
Dependencies
For language comparison, you must choose no more (or less) than one mode.
Supplementary Documentation - AQ_MARK 0504
Use
Select type of text to be compared.
Procedure
If you select this field, all texts are processed according to the predefined work mode.
Examples
Dependencies
You can select only one text type.
Supplementary Documentation - AQ_MARK 0505
Use
Select type of text to be compared.
Procedure
If you select this field, you can edit some of the texts according to the predefined work mode. The text to the right of the field describes the text type.
Examples
Dependencies
You can choose only one text type.
Supplementary Documentation - AQ_MARK 1050
Use
Procedure
If you select this field, the query is executed in the background. You branch to the background job request screen where you can schedule your job.
Examples
Dependencies
Background processing always requires a variant. You can specify this either in the field Variant or on the background job request screen. If you have not created a variant and attempt to execute a query in the background, the system requests you to create a variant.
Supplementary Documentation - AQ_MARK 1053
Use
Only if the graphic Query Painter is not in use.
Procedure
Several variants exist for a number of screens. Here, you can define which screen you want to display first in the navigation.
If you are branching to a screen with several variants and you select this field, the first screen you see always omits the help texts for possible entries and the line structure.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1100
Use
Selection of functional groups from which fields for processing in the query have already been chosen.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1101
Use
When you select this field, the names of the tables processed within the given functional areas are scanned. However, related tables are not taken into account, only the tables of the logical databases or the tables or structures for which functional areas have been defined.
You can thus find out in which functional areas certain tables are processed.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1110
Use
Indicates whether this is a local field of the query.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1120
Use
Procedure
If you select this field, the basic list is displayed in a box.
Please remember that the box requires two characters for each line and you should therefore specify your line width accordingly. The box is designed so that it encloses only the filled part of the basic list.
Examples
Dependencies
Please also note that the Separate columns by | and Box options (on the Control Levels screen) are effective only if you have already selected the Basic list with box option. So, if you deselect this field, you also cancel both the above options.
Supplementary Documentation - AQ_MARK 1130
Use
Procedure
If you select this field, column headers are automatically generated for the fields in this line.
Examples
Dependencies
Since no more than four lines can have column headers in a basic list, only four lines are made available. Please note that the column headers for fields can also be double-spaced, so two lines with column headers can be supplied for a line of the basic list.
The automatically generated column headers are displayed on the screen Headers. You can change them, if required.
Supplementary Documentation - AQ_MARK 1150
Use
Procedure
If you select this field, you can define a special output template.
Examples
Dependencies
You define the template on a subsequent screen.
Output templates can only be created for non-numeric fields.
Supplementary Documentation - AQ_MARK 1160
Use
Procedure
If you select this field, a text description of the control level is output at the beginning of the control level, i.e. when the sort criterion changes.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1180
Use
Procedure
If you select this field, the list is not displayed on the screen when you execute the query. Instead, the first sub-list is passed directly to the Executive Information System (EIS).
If it is to be passed on, the sub-list must be a one-line basic list, a statistic or a ranked list. When you select the field, a parameter is predefined on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1185
Use
Procedure
If you select this field, the list is not displayed in the usual way when the query has been processed. Instead, it is passed on directly for word processing.
Word processing requires the list to be a one-line basic list, a statistic or a ranked list. Selecting this field causes a parameter to be set on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1190
Use
Procedure
If you select this field, the alternative text display of SAP Business Graphics is used.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1200
Use
Retrieval of information about processed data records
Procedure
If you select this field, the data records used to determine the line of the statistic are counted.
Examples
Suppose you want to create a country sales statistic and choose the fields "Country UD" and "Sales". If you want to see the total sales for each country, simply select the column Display for the field Sales.
Dependencies
Supplementary Documentation - AQ_MARK 1210
Use
Procedure
If you select this field, the ranked list is sorted by the ranked list criterion in ascending order. Otherwise, the sort is in descending order.
Examples
Dependencies
You can only select this field if the field specified on the left is the ranked list criterion.
Supplementary Documentation - AQ_MARK 1220
Use
If you select this field, the local field will have the attributes of a text field which can contain character strings.
Procedure
If you select this field, you must also specify the number of characters.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1230
Use
Procedure
If you select this field, the field specified on the left is displayed in normal intensity in the list.
Examples
Dependencies
If you do not make any specification (i.e. highlighted or otherwise), the intensity attribute of the line applies.
You can only make one specification at once, not both at the same time.
Supplementary Documentation - AQ_MARK 1240
Use
Dependencies
If you select this field, no parameter IDs (SET/GET parameters) are staged for the selection criteria that have been defined on this screen for the present query. This means that no default values are assigned to any of the selection criteria.
Example
Supplementary Documentation - AQ_MARK 1300
Use
If you want to define a link condition between two tables of a table join, you must selct two tables and choose the Define condition function.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1450
Use
If you select this field, the system searches within the field name and field texts in the left or right table for a character string.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1451
Use
If you select this field, the system searches in the left or right table for a field which belongs to a particular domain in the Dictionary.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 1452
Use
If you select this field, the system searches in the left or right table for a field which has a particular data type in the Dictionary.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2000
Use
If you select this field, the functional area is assigned to the relevant user group.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2050
Use
Procedure
If you select this field, you create a new query with the name specified above.
Examples
Dependencies
In the user group, a query with this name should not already exist.
Supplementary Documentation - AQ_MARK 2053
Use
Only if the graphic Query Painter is not in use.
Procedure
Several variants exist for a number of screens. Here, you can define which screen you want to display first in the navigation.
If you are branching to a screen with several variants and you select this field, the first screen you see always displays the line structure of the sub-list you are editing.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2101
Use
If you select this field, the names of the logical databases are scanned for which the given functional areas have been defined.
You can thus find out which functional areas have been defined for certain logical databases.
A logical database is always defined by a three-character ID 'dda' where 'dd' is the database name and 's' is the application, for example, DDF for the logical database DD in Application F.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2120
Use
Procedure
If you select this field, the following definitions apply for the layout of your basic list:
1. A vertical bar is output after each field on a line except the last
field (however, on the 'Display options List line' screen,
different settings can be made line for line).
2. An underscore is output before and after each control level text.
3. An underscore is output before and after each total.
4. The individual columns in the standard header are separated by
vertical bars in single line basic lists.
In basic lists with multiple lines no vertical lines
are embedded in the column headers.
Examples
Dependencies
Please remember that the Columns separated by | option is effective only if you have already selected the Basic list with box option.
Supplementary Documentation - AQ_MARK 2130
Use
Procedure
If you select this field, the relevant line is output in the page header when you starting a new page and one of the following lines results in a new page.
Examples
If you are outputting address data and item data in a basic list, you can assign items extending beyond a page to the address line without scrolling, if you repeat it in the page header.
Dependencies
Supplementary Documentation - AQ_MARK 2150
Use
Procedure
If you select this field, a value of the field in question is only output if it is not equal to zero.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2160
Use
Procedure
If you select this field, sub-totals are output for all fields summed for a control break.
Examples
Dependencies
You specify the fields to be summed on the preceding screen for the line structure of the basic list.
Supplementary Documentation - AQ_MARK 2180
Use
Procedure
If you select this field, the list is not displayed on the screen when you execute the query, but the first sub-list is passed directly to EXCEL (via the XXL interface).
The first sub-list must be a one-line basic list, a statistic or a ranked list). When you select the field, a parameter is predefined on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2185
Use
Procedure
If you select this field, the list is not displayed in the usual way when the query has been processed. Instead, it is passed on directly for ABC analysis.
ABC analysis requires the list to be a one-line basic list, a statistic or a ranked list. Selecting this field causes a parameter to be set on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2190
Use
If you select this field, you can define the number of values to be displayed at runtime of the query.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2200
Use
Retrieval of information about the processed data records
Procedure
If you select this field, an average value is calculated for the field entered on the left for the individual summands.
Examples
Dependencies
The field specified on the left is a numeric field. In the statistic, a total is always output for this field.
Supplementary Documentation - AQ_MARK 2220
Use
If you select this field, the local field will have the attributes of a field that can contain numbers.
Procedure
When selecting the field, you must specify the maximum number that the local field can accept, as well as the number of decimal places.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 2240
Use
If you put a checkmark in this checkbox, only one entry field is prepared on the selection field. The pushbutton for choosing the "Multiple Selection" additional field, is available, enabling you to use this function to make multiple selections.
Dependencies
If you want to deactivate the multiple selection function, put a checkmark in the next checkbox.
Example
Supplementary Documentation - AQ_MARK 3050
Use
Procedure
If you select this field, the query is displayed. This display contains all the essential information about defining this query (the types of lists defined, the fields displayed in these lists, the fields used for sorting, etc.).
Examples
Dependencies
The query must exist in the user group.
Supplementary Documentation - AQ_MARK 3053
Use
Procedure
If you select this field, then the graphical Query Painter is used to construct the sublists for a query (basic list, statistics, ranking list).
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3120
Use
Procedure
If you select this field, your basic list is displayed in compressed format, provided compressed display is possible.
Examples
Dependencies
At processing time, you can choose to switch between a compressed and an expanded basic list display. With this option, you define which display should appear first.
Supplementary Documentation - AQ_MARK 3130
Use
Procedure
If you select this field, a new page is started before the line is output.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3150
Use
If you select this field, the relevant currency or unit is output in the basic list before the currency amount or quantity.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3160
Use
Procedure
If you select this field, each new group starts on a new page.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3180
Use
Procedure
If you select this field, the list is not displayed on the screen when processing the query, but the first sub-list is passed directly to the graphic.
The first sub-list must be a one-line basic list, a statistic or a ranked list). The first numeric field in the first line of the list is used as a reference point for the graphic display. When this field is selected, a parameter is predefined on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3185
Use
Procedure
If you select this field, your list will not be displayed on the screen in the normal form when the query is processed. Instead, the first sub- list is transfered to the ABAP List Viewer directly.
You must be able to transfer this first sub-list (it must be either a single line basic list, a statistic, or a ranked list). Selecting the field leads to it being set as a default parameter for the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3200
Use
Calculation of the percentage of numeric fields
Procedure
If you select this field, the percentage of the field of the sum total is output.
Examples
Dependencies
The field specified on the left is a numeric field. In the statistic, a total is always output for this field. Normally, an overall total is also determined.
Supplementary Documentation - AQ_MARK 3220
Use
If you select this field, the local field will have the attributes of a field that can contain a date (day, month, year).
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 3240
Use
If you select this checkbox, you are able to specify a single value or an interval on the selection screen. The pushbutton for selecting the extra screen "Multiple Selection" is not available, effectively preventing you from making multiple selections.
Dependencies
If you want to restrict the selection so that you are permitted to only select single values, also put a checkmark in the first checkbox.
Example
Supplementary Documentation - AQ_MARK 4050
Use
Procedure
If you select this field, you can modify the selected query.
Examples
Dependencies
The selected query must exist in the user group.
Supplementary Documentation - AQ_MARK 4053
Use
Procedure
When you select this field, the system displays system objects in all query maintenance components. You can make changes to these objects.
System object names begin with SYST (user groups and InfoSets). Queries from user groups that begin with SYST are also system objects, even though their names do not necessarily begin with SYST.
System objects are created by the QuickViewer and by generation modules.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 4120
Use
Procedure
For each of the fields you want to count, select how often they should be read while the query is getting data. The total is displayed at the end of the list. If you have specified sort criteria, you can also display how often a field has been read within a group level at the end of each group level (subtotal).
Examples
Dependencies
Supplementary Documentation - AQ_MARK 4130
Use
If you select this field, a slash is displayed before the rest of your line is displayed.
Procedure
Examples
Dependencies
Be aware that the option 'Slash' can only be used if you have chosen the option 'Basic list with frame' as well (from the preceding 'Basic list line structure' screen). Hence, whenever you choose this option, the option 'Basic list with frame' is automatically selected as well.
Supplementary Documentation - AQ_MARK 4150
Use
If you select this field, the currency amount or quantity is output in the basic list without the relevant currency or unit.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 4160
Use
Procedure
If you select this field, a blank line is output before every new group.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 4180
Use
Procedure
If you select this field, you can only execute the query with a variant.
Examples
Dependencies
Please note that you can only create variants from the initial screen.
Supplementary Documentation - AQ_MARK 4185
Use
When generating the query report, the system checked to see if it was possible to use a new structure to genreate the report. In this case, only the SAP List Viewer (ALV) is used to display the report. Reports with new structures work more effectively than reports with old structures.
Reports with new structures cannot be generated for all queries. For this type of query, existing reports (with old structures) are generated. The result is a list, which in turn can be sent to other display tools, such as the SAP List Viewer,
Usually, a report with a new structure is also generated whenever possible. If you select this field, only reports with old structures are generated for the current query.
Dependencies
Example
Supplementary Documentation - AQ_MARK 4200
Use
Retrieval of texts for SAP Business Graphics
Procedure
If you select this field, the values of the field specified on the left are used to generate the texts for the SAP Business Graphics. If you select several fields, their values are used in the sequence they occur.
Examples
Dependencies
SAP Business Graphics processes up to 30 characters text per value.
Supplementary Documentation - AQ_MARK 4220
Use
If you select this field, the local field will have the attributes of a field that can contain time specifications (hours, minutes, seconds).
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 5050
Use
Procedure
If you select this field, the query is deleted. However, you always get a prompt asking you to confirm the action or to cancel.
Examples
Dependencies
The query must exist in the user group.
Supplementary Documentation - AQ_MARK 5053
Use
Dependencies
When you select this fiels, a graphical table join definition tool is made available to the user.
Example
Supplementary Documentation - AQ_MARK 5120
Use
If you select this field, you get an additional function that counts the number of rows in the list when it is displayed with the SAP List Viewer (ALV). A prerequisite for this function provided by the List Viewer, is that the staged dataset must contain a special column for the number of rows. This is why the basic list contains a counter field internally, even though this field is not shown directly in the query definition. This counter field belongs to the dataset and must therefore also be referred to when you use certain interactive functions (file storage).
It is important that you do not confuse the type of row counting in the SAP List Viewer with the count that results from the query being displayed as an ABAP list. The count in the ABAP List counts the number of times a field occurs in the data source, whereas the SAP List Viewer counts only the number of rows in the dataset that you want to display. If the data source is a logical database (a hierarchical dataset) the results of the two different kinds of count can be very different.
Dependencies
Example
Supplementary Documentation - AQ_MARK 5130
Use
If you select this field, a slash is displayed after the rest of your line is displayed.
Procedure
Examples
Dependencies
Be aware that the option 'Slash' can only be used if you have chosen the option 'Basic list with frame' as well (from the preceding 'Basic list line structure' screen). Hence, whenever you choose this option, the option 'Basic list with frame' is automatically selected as well.
Supplementary Documentation - AQ_MARK 5150
Use
If you select this field, the relevant currency or unit is output in the basic list after the currency amount or quantity.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 5160
Use
Procedure
If you select this field, the relevant control level is displayed in a box.
Examples
Dependencies
Please note that this option is effective only if you have already selected Basic list with box on the previous Basic List Line Structure screen.
Supplementary Documentation - AQ_MARK 5180
Use
Procedure
If you select this field, the list is not displayed on the screen when you execute the query, but the first sub-list is passed directly to the download interface and stored as a file.
The first sub-list must be a one-line basic list, a statistic or a ranked list). When you select the field, a parameter is predefined on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 5185
Use
This attribute is used only in special cases.
If you select this field, the query you defined is always treated as a single-row query during the generation of the report belonging to it. This corresponds to the classic query definition, whereby the same number (1) is always used as the row number in the screen Row Construction Basic List.
This attribute is used only if you are using the Query Painter to construct a query, and are working with an InfoSet that has been defined using a logical database. You may have to distribute fields over several rows, even though you really want a single-row display, such as you would get as standard if you used the SAP List Viewer (ALV) as the display medium. The hierarchical structure of the logical database means that, depending on how the individual fields are distributed among the rows, it is possible to generate a list with several rows (in the list there are several rows with the number y,y > x that belong to a row with the number x).
Lists with several rows can usually be displayed flat (for example, using the SAP List Viewer). However, in the data staging process, a distinction is made between single-row and multi-row lists. It is therefore possible for two queries to have different results, even though the only difference between them is that one has been defined as single-row and the other as multi-row.
Dependencies
Example
Supplementary Documentation - AQ_MARK 5200
Use
If you select this field, ABAP/4 Query generates sub-totals for the sort criterion in the statistic, i.e. whenever the sort criterion changes, a line containing the relevant sub-totals is output.
Procedure
Examples
Dependencies
If you want to calculate sub-totals for a field (sort criterion) in a statistic, you should be aware of three conditions.
1. You can only use sort fields.
2. You must already have defined a sort for fields in the statistic
and the sort sequence must be in ascending order.
3. The sort number of any fields following a field defined for sorting
cannot be smaller than the sort number of the field itself.
Thus, if you want to generate a sub-total for the third field (sequence number 3), you must sort by this field and by both preceding fields. Since the sort sequence must also be in ascending order, the first field must have the sort number 1, the second field the sort number 2 and the third field the sort number 3.
For example, you cannot calculate sub-totals if the first field (sequence number 1) of a statistic has the sort number 2 and one of the following fields has the sort number 1. In this case, no sub-totals can be calculated for any of the fields, not even the first.
Supplementary Documentation - AQ_MARK 5220
Use
If you select this field, the value of the local field is determined by specifying one or more formulae and conditions.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 6050
Use
Procedure
If you select this field, you can copy a query.
Examples
Dependencies
You always copy into the selected user group.
You can copy all existing queries in the user group under a new name.
You can also copy queries from other user groups, provided they belong to a functional area, which is also assigned to the user group.
Supplementary Documentation - AQ_MARK 6053
Use
Dependencies
If you select this field, the tables and fields are given technical names taken from the dictionary.
Example
Supplementary Documentation - AQ_MARK 6054
Use
Dependencies
If you choose this option, a simplified version of the catalog for all the InfoSets (initial screen of the InfoSet maintenance) is displayed (information on the status, author, and the date the InfoSet was last changed is not displayed). As a result, database access is optimized and the screen is displayed much more quickly, which is particularly significant when you are reading a large number of InfoSets.
Supplementary Documentation - AQ_MARK 6130
Use
If this field is selected, the individual fields of your line are separated by a vertical line (|).
This field is only ready for input (and set to default), if you have chosen the option 'Separate columns with |' (from the preceding 'Basic list line structure' screen). Deselecting this field disables column separation using | .
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 6160
Use
Procedure
If you select this field, the system outputs subtotals for each field that you are counting at the end of each control level.
Examples
Dependencies
You specify the fields for which you want to count on the previous screen (line construction of the basic list).
Supplementary Documentation - AQ_MARK 6180
Use
Procedure
If you select this field, the list is not displayed on the screen when you execute the query, but the sub-list is passed directly to a function module which is an SAP enhancement and must be implemented by the customer.
The first sub-list must be a one-line basic list, a statistic or a ranked list). When you select the field, a parameter is predefined on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 6200
Use
When you select this field, page breaks are inserted in your statisitic for each sort string, that is, each time the sort string changes, a new page is displayed.
Procedure
Examples
Dependencies
If you want to use this page break function for a particular field, three conditions must be met.
First, page breaks can only be generated for sort fields.
Second, page breaks can only be created for a field if its preceding fields in the statistic are also sort fields and the sort order of these fields is ascending.
Third, no sort fields with a sort number smaller than the sort number of the field in question may follow a field for which page breaks have been set.
If, for example, you want to insert page breaks for field number three (position 3 in the sort sequence), this field and both of the fields preceding it must be sort fields (the system must sort according to them). Since the sort order has to be ascending, the first field must have sort number 1, the second field sort number 2, and the third field sort number 3.
In the following example, you may not display with page breaks. If the first field contained in the statistic (sequence number 1) has sort number 2 and on of its subsequent fields has been assigned sort number 1. In this case, page breaks may not be displayed for any of these fields, not even for the first one.
Supplementary Documentation - AQ_MARK 6220
Use
If you select this field, the value of the local field is determined by an entry on the selection screen. You then get a field where you can enter the desired value.
The values of fields defined as symbols or icons cannot be determined in this way.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 7053
Use
Dependencies
If you select this field, no live data is used within the InfoSet Query for the preview.
This is set across the system for all queries, which are processed using the InfoSet Query.
Example
Supplementary Documentation - AQ_MARK 7180
Use
Procedure
If you select this field, you lock the query and prevent other users from making any changes. Only you are then authorized to carry out any modifications.
When you deselect the field, any user in the same user group can change the query.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 7220
Use
If you select this field, the local field has the attributes of a symbol. This means that, on output to the list, the contents of the local field are interpreted as a symbol and displayed accordingly. The standard output length for these symbol fields is 2, but you can modify this when defining individual sub-lists.
Procedure
Examples
Dependencies
Only symbols can be assigned to a symbol field. You can deterine the symbols available with the Symbols function.
A calculation formula for a symbol field can consist only of a symbol (the name begins with SYM_) or a symbol field. However, you can specify conditions as with all other fields.
Supplementary Documentation - AQ_MARK 8053
Use
Dependencies
If you select this field, query reports are generated using the process used for generating reports up to Release 4.6D. In Releases after 4.6D, reports are generatred using different structures, in many cases.
This applies to all queries and across the whole system.
Example
Supplementary Documentation - AQ_MARK 8180
Use
If you select this field, the standard title appears at the top of every page when you print the list. This standard title consists of two lines. The first line contains the date, the query title and the page number, while the second line is an underscore line.
The standard title is output only if you print the list using the Exeute and print function on the selection screen, or process the query in the background.
Procedure
Examples
Dependencies
Supplementary Documentation - AQ_MARK 8220
Use
If you select this field, the attributes of the local field are those of an icon. When you output the list, this means that the contents of the local field are interpreted as an icon and output accordingly. The output length for such icon fields is usually 4 bytes, but you can change this length when defining the individual sub-lists.
Procedure
Examples
Dependencies
Only icons can be assigned to an icon field. You can obtain a list of available icons using the Icons function.
A caculation formula for an icon field can consist only of an icon (the name begins with ICON_) or an icon field, but you can also specify conditions as with all other fields.
Supplementary Documentation - AQ_MARK 9053
Use
Dependencies
If you select this field, no parameter IDs (SET/GET parameters) are prepared on the selection screens for the selection criteria that have been defined in queries. This means that no default values are assigned to any of these selection criteria.
This applies to all queries and across the whole system.
Example
Supplementary Documentation - AQ_MARK 9140
Use
If you select this field, all values in the selected column that are not within the range selected for display are summated and passed to the graphic as an extra value in the 'other' section.
Procedure
Examples
Dependencies
This sum is not displayed if
- the number of values to be displayed is 32 (you can only pass 32 text-value pairs to the graphic) or
- you call the graphic from the table display and there is a total line beneath the selected line.
Supplementary Documentation - AQ_MARK 9180
Use
Procedure
If you select this field, the list is not displayed in the usual form when you execute the query. Instead, the format of the first sub-list depends on a table view control.
The first sub-list must be a one-line basic list, a statistic or a ranked list. When you select the field, a parameter is predefined on the selection screen.
Examples
Dependencies
Supplementary Documentation - AQ_MARK 9220
Use
If you select this field, you have to enter a value for the local field on the selection screen. You cannot execute the query until you have entered a value.
Procedure
Examples
Dependencies
This field is of significance only if you want the value to be defined by an entry on the selection screen.
History
Last changed by/on | SAP | 20010130 |
SAP Release Created in |