Hierarchy
SAP_BS_FND (Software Component) SAP Business Suite Foundation⤷
CA-EPT-ANL-LST (Application Component) List Reporting⤷
BS_ANLY_LIST_REPORTING (Package) Business Suite Analytics: Simple List Reporting
Basic Data
| Data Element | BS_ANLY_DD_TYPE |
| Short Description | Analytic List UIBB: Drilldown Type |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | BS_ANLY_DD_TYPE | |
| 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 | DD Type |
| Medium | 20 | Drilldown Type |
| Long | 30 | Drilldown Type |
| Heading | 20 | Drilldown Type |
Documentation
Definition
Allows you to change the list by drag and drop.
Use
You can transfer characteristics and key figures to a list either by drag and drop or with the context menu. This changes the drilldown of the list.
You have the following options:
- No Drilldown Allowed
You can only change the list in the Settings Dialog. - Vertical Drilldown Allowed
You can show the Drilldown Settings and change the drilldown of the list using these Drilldown Settings. Initially, the Drilldown Settings show the characteristics contained in the line definition of the analytic query under Vertical Drilldown and the free characteristics of the query under No Drilldown.
When you add a characteristic to the drilldown, then the columns belonging to that characteristic are also included in the list. The key figure values are displayed for each characteristic attribute, which creates additional lines. - Vertical and Horizontal Drilldown Allowed
You can show the Drilldown Settings and change the drilldown of the list using these Drilldown Settings.
Initially, the Drilldown Settings show the characteristics contained in the line definition of the analytic query under Vertical Drilldown, the characteristics contained in the column definition of the query under Horizontal Drilldown, and the free characteristics contained in the query under No Drilldown.
When you add a characteristic to the drilldown, you can decide if the drilldown of the key figure values is to have additional lines (Vertical Drilldown) or additional columns (Horizontal Drilldown).
Note
For this setting, you cannot save the Drilldown Settings and Layout Settings.
Features
The keys, descriptions, and attributes of the characteristics in the drilldown are displayed in the list, as well as the key figures, as defined in the query. The columns belonging to a characteristic are displayed in a block, in other words, in a series of adjoining columns, such as Material Number (key), Material (description), and Material Type (attribute).
The system uses the sequence defined in the query.
In the Drilldown Settings, the characteristics used in the drilldown are displayed. Other characteristics available for the drilldown, but not yet used, are displayed under No Drilldown.
Vertical Drilldown Allowed
When you add a characteristic in the Drilldown Settings under Vertical Drilldown, then the columns belonging to that characteristic are also included in the list. The key figure values are displayed for each characteristic attribute, which creates additional lines. The columns belonging to a characteristic are added to the list as adjoining columns.
You can change the drilldown by adding or removing characteristics, or changing the sequence.
Adding Characteristics
You can add characteristics to the drilldown by dragging and dropping them from No Drilldown to Vertical Drilldown.
When you add an additional characteristic in the Drilldown Settings, the system behaves as follows:
- The system adds the newly added characteristic in the list after the key, description, and attributes of the higher-level drilldown characteristic.
Example
When you add the SD Document characteristic after the Material characteristic, then the SD Document will be added after Material Number, Material (Description), and Material Type. - The system likewise adds all other relevant columns of the new characteristic to the list, such as description and attributes.
- When you add a characteristic to the first position in the drilldown, then the characteristic is included in the list with all its related columns, in front of the drilldown characteristic that was previously in first position.
Removing Characteristics
You can remove characteristics from the drilldown by dragging and dropping them from Vertical Drilldown to No Drilldown.
You cannot use the Drilldown Settings to remove from the list the characteristic structures defined in the query because these do not only represent the drilldown, but they may also contain (complex) filter criteria. If you remove these structures (and consequently also the filter criteria), the displayed values would also change.
Changing Sequence
You can change the drilldown sequence by changing the sequence of the characteristics under Vertical Drilldown by drag and drop.
In the Drilldown Settings, under Vertical Drilldown, Material Type appears in first position and Region in second. This means that the key value figures are first displayed by material type, and then each material type is displayed by region.
If you change the sequence of the drilldown characteristics by dragging and dropping the region to the first position under Vertical Drilldown, the drilldown is first displayed by region and then, under each region, the characteristic values are displayed by material type.
Saving View of List
In the Vertical Drilldown, you can save views of the list. When you call up the view later, the relevant Drilldown Settings are displayed.
Vertical and Horizontal Drilldown Allowed
You can use all the functions of the Vertical Drilldown as well as the Horizontal Drilldown.
When you include a characteristic in the list and add it to Horizontal Drilldown, additional columns are added to the list for the combinations of characteristic attributes and key figure.
Under Horizontal Drilldown, you first see an entry for the key figure. You can move this between the Vertical and Horizontal Drilldown in the same way as the characteristics. You cannot remove key figures from the drilldown with the Drilldown Settings.
Adding Characteristics
When you add a characteristic in the Drilldown Settings under Horizontal Drilldown, the system displays the key figures for the respective characteristic attributes in separate columns. You can see the characteristic values and attributes and the key figure in the column titles.
The position of the key figures and characteristics is relevant for the sequence of columns in the list.
You want to display detailed sales figures for a material. The list contains the key figures Quantity and Value. The list consists of three columns Material, Quantity, and Value.
You add the Country characteristic to the Horizontal Drilldown, after the key figure.
The system displays sales figures for the countries Brazil and Spain. This data is displayed in the newly created columns Quantity Brazil, Quantity Spain, Value Brazil and Value Spain.
You add the Country characteristic to the Horizontal Drilldown, before the key figure.
Removing Characteristics
You can remove characteristics from the drilldown by dragging and dropping them from Horizontal Drilldown to No Drilldown. The key figures are then displayed in the list in aggregated form. This means that the key figures are no longer displayed in detail by country when you remove the country from the Horizontal Drilldown.
Note
You cannot use the Drilldown Settings to remove from the list the structures for characteristics and key figures defined in the query.
Changing Sequence
You can change the drilldown sequence by changing the sequence of characteristics under Horizontal Drilldown by drag and drop.
Example
In the Drilldown Settings, under Horizontal Drilldown Material Type appears in first position and Region in second. This means that the key value figures are first displayed by material type, and then each material type is displayed by region.
If you change the sequence of the drilldown characteristics by dragging and dropping the region to the first position under Vertical Drilldown, the drilldown is first displayed by region and then, under each region, the characteristic values are displayed by material type.
Changing Drilldown Direction
You can change the drilldown direction of a drilldown characteristic by dragging and dropping the characteristic from Horizontal Drilldown to Vertical Drilldown, or vice versa.
Saving View of List
In the Vertical and Horizontal Drilldown, you cannot save views of the list. This is the main difference from the Vertical Drilldown. This means that, each time you call the list, the standard view derived from the analytic query is displayed, and you have to change these settings if required.
Dependencies
You can change the list in the Settings Dialog in detail, for instance by changing the sequence of columns, or adding or removing columns. These settings are merged with the Drilldown Settings.
The following data is displayed in t
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 703 |
