Display Extraction Views - Data Retention
Application component: DART (Data Retention Tool)
App type: SAP GUI
Description:  You can use this function to execute views for evaluation purposes. For more information, see Data Extract View .  
Key features:  Selection You can select one or more DART extracts (by means of multiple selection in the Source Extract field) for evaluation in a view. As an example, in this way, you could create an annual report out of four quarterly extracts.  As the selection criteria, you can enter values and value ranges to restrict the search in the extract. For example, you can specify the individual value1000.00(including with a minus sign) for an amount field. The system determines the search results with exactly this amount.   Note: DART always uses a period as the decimal separator in extracts. A selection value entered during view execution (FTWH) overrides the selection value determined in the view definition (FTWY). You can specify whether and how the system displays, prints or exports the identified data. To export the view file, you have to give it a name.   We recommend using a standardized notation or descriptive names for view files. The following characteristics should be easily identifiable: Client Company code Fiscal year Period from (…) to Module indicator or view name  Merging Extract Data Using the Append to file function, you can merge DART data from different DART extracts into one view file. This can be useful, for example, if the DART extracts are created quarterly, but you want the evaluation to be cumulative for the year. You can therefore only read from the DART extract for each new quarter and append it to the existing view file. When appending view files, the system does not add the header lines again.   Selecting Additional DART Extracts You can specify a separate DART extract for each master data segment included in the view. You can do this on the selection screen under DART Extracts . In the standard system, you do not need to enter anything under Additional DART Extracts and the system uses the DART extract specified above as the data source. However, if you enter another DART extract under Additional DART Extracts , the system uses it as the data source for master data segments.  You can restrict each segment, for example by period. This can be useful if you want to display the master data for an entire year (from period 1-12, for example) and the transaction data for one period of the view only.   You could proceed as follows: In the mid-year runs of the Extract data transaction (FTW1A), you exclude the master data.  In a separate extraction run at the end of the year, you create an extract dataset with the master data only. When evaluating the transaction data, you then assign the extract dataset with the master data and tables using Additional DART Extracts .   Output The line-by-line display of the search results corresponds to the definition of the view. You can use the functions of the SAP List Viewer (ALV) to format the search results. You can use layouts for the output option Display/Print .   Metadata The system reads the data specified in a view from the DART extract and stores it in a view data area for further evaluation. The system creates a file with descriptive data for each view file created in this way. It is available for later evaluations via ALV. The file name ends in_MT. The metadata is also stored in the first eight records of the view file, to enable outputting in SAP audit format.  Totals Formation The system outputs totals lines in the display list, in accordance with the totals and group specifications in the view definition. So if you set totals display when configuring the view (FTWY), no single records can be output when the view is executed (FTWH). If you did not set totals display when configuring the view, you can decide whether to output totals or single records when the view is executed.   Note for output options: Display If you calculate and group totals with a view, it is not useful to calculate totals, mean values or subtotals again in the SAP List Viewer (ALV), as the ALV display mixes the values from line items and totals records. Export The system transfers the totals records to the exported data.