Using Data Extract View Query to Display Views (SAP Library - Data Retention Tool (DART) (CA-GTF-DRT))

Using Data Extract View Query to Display Views

Use

This utility executes the report defined by the view, displaying data from the fields and segments defined by the view.

This graphic is explained in the accompanying text

Prerequisites

You must have the appropriate authorization to display data views.

Procedure

In the main DART screen, choose Information system ® Data extract views. The system displays the list of available views.

At the Data view queries screen, mark the view name or description and choose Execute report.

At the Data file view screen, enter the following data:

At the Field/Group…	Specify…
Data extract	The details of the data extract: its file name and directory set This should be the data extract containing the extracted data. Note that it is possible to apply a view to any data extract that contains the data defined by the view. If you specify a data extract that does not contain the data as specified in the view, the system displays an error message.
Data view selection criteria	Selection criteria for any of the fields listed in this group Amount fields are also supported. Enter amounts in dollars and cents without any formatting characters (example: 10000.00). The sign of amounts is ignored. If only positive or negative amounts should be selected, add a condition for the debit/credit indicator if available. When entering ranges, add leading zeros to make the length of the lower and upper values equal (example: 0500 to 1000). The reason for this is that DART stores numbers in character fields.
Output options	Whether to display/print the resulting report, or to save it into a file If you choose Export to file, the system saves the data, as defined by the view, into a file. If you choose Export to file, then enter the following data in the Options for exporting to file fields: Specify the name of the file in which to save the data, and the directory set for this file. You may add a description for this file. This description only appears in the view log. If you specify an existing export file name, then specify whether to overwrite or append the data in it. You can also insert a header line, if you overwrite the file. Specify either semicolon separated columns or fixed-length columns as your preferred format. If you do not choose Export to file option, that is, if you choose Display/print, then the system ignores any entries at the Options for exporting to file fields.
Max query buffer size	Maximum buffer size to use when creating the report We recommend that you use the default buffer size The buffer size you specify may affect the performance of executing the view report. It does not limit the amount of data that is included in the report. When a query is executed, the required master data segments are buffered in memory to speed up processing. If a master data segment does not fit within the maximum query buffer size, it is not buffered. Increasing the buffer size can improve performance.
Apply file size limit	Splits view files into multiple files. These multiple files are the same size as the maximum size specified in the extract configuration.
Data segment access sequence	How the system accesses the segments included in the view If you accept the default, the system accesses the segments in the order they have been defined in the view. If you choose Optimize access sequence, the system attempts to optimize the access to the segments. If you wish to control the order in which the system accesses the segments, enter numbers next to the segment name in that field group.

Choose Execute.

Result

The system displays (or exports to a file) the data as selected by the definition of the view.

You can doubleclick a line in the report to view that line as a single record on a separate screen. At the record screen you can display the originating segments and fields, by choosing Show technical names.

If you elect to export the view data into a file, you can view the resulting file by using the display data extract log utility.