Tab Page: Data Selection 

Use

Determine the selection values for the InfoPackage in the Data Selection tab page.

You can determine selection boundaries not only for InfoObjects mapped in the transfer structure, but also for unmapped fields in the source system. The fields are displayed in the Technical Name in Source System Displayed column in the selection table. To tell the difference between InfoObjects and fields when the selections are displayed, the fields are shown in brackets (for example, with the initialization selection for source systems in the Scheduler).

You can either enter single values or intervals directly in the from value and to value fields or set the selections as variable.  You can find additional information under Variable Change of Selections with Background Processing.

When using selection criteria, InfoObject or field data corresponding to the selection limit is requested from the source system. With InfoObjects or fields for which no variable selections were determined, all available data is requested from the source system.

You can specify several selections for an InfoObject/field in which you insert duplicate rows. Additional rows for entries in this InfoObject/field are then inserted into the selection table.  When selecting individual value- or interval selections and not confirming them, you can select an additional variable selection type in the same row of the InfoObject/field. The system automatically adds an additional row in the selection table for this selection. Thus, your selections for an InfoObject or field are displayed in a clear way.

Selection Options for DataSource from SAP Source Systems

When using a DataSource from an SAP source system, the DataSource determines which selection options are possible. All DataSources permit

...

·        Single value selections (l_t_range-sign = 'I' and l_t_range-option = 'EQ')

·        Intervals (l_t_range-sign = 'I' and l_t_range-option = 'BT').

Note that additional selection options are only possible if they are supported by the respective DataSource.

You can specify model selections (l_t_range-option = 'CP'), such as ABC*, in the field From Valueas a single value. Note the following:

·        As a model, only use the character *.

·        Use the character * only once in the field From Value.

·        Use the character * only at the end of the value.

If you execute a selection with * in the From Value field, and the To Value field is not filled, check the scheduler to see if the DataSource allows the selection option CP. If this is the case, the l_t_range-option is changed from EQ to CP. If this is not the case, the scheduler returns an info message and passes the data request with the selection option EQ to the source system. If you fill the field To Value, the scheduler always passes the data request with the selection option BT to the source system and does not execute any check. The request is not cancelled in these cases.

You can also specify selection options for the data request by means of a routine or a variable. If a selection that is not supported by the DataSource is transferred from a routine or variable to the scheduler, the entire request is cancelled.

You can find additional information about selection options with routines and variables under Variable Changes for Selections in the Background Processing.

You can display the selection options supported by your DataSource in the source system in the data browser (SE16). Specify the ROOSFIELD table and choose Table  → Table Contents. The SELOPTS field includes the value that the combination of selection options supported by the DataSource characterizes.  For more information, see the F1 help for SELOPTS.

Selection Limits for Data from File- and External- Systems.

It is also possible to determine selection criteria for data from files and external systems. Only records that meet the selection criteria are loaded.

To determine field selections in the Scheduler, firstly highlight them in the transfer structure maintenance in the column Selection and save and activate the transfer structure.

By determining the selection criteria, you can carry out the functions Automatic Deletion and Checking Data Consistency of the Requests in the InfoCube for data from files and external systems.

Selection Limits for Updating from an ODS Object

When wanting to update data from an ODS object into additional data targets using full-update, you can set selection criteria for this schedule.

You can find additional information under Update ODS Object.

Conversion Exits

When entering the selection, the conversion exits displayed in the selection table are executed in the OLTP and the results are temporarily saved in the BW. If a selection has already been converted, it is in the BW; if it is not yet in the BW, conversion takes place in the OLTP.

If conversion cannot take place in the OLTP, because the system cannot be accessed or the OLTP conversion exit is not running properly, conversion takes place in the BW. If this is not possible either, the Conversion Exit field is ignored, meaning that the selections must be entered in an internal format. In this case, entering in external format will lead to errors in the load process.

If you have set the Use Conversion Exit option, the system adds two spaces to the length of each input field that has a conversion exit (except ALPHA exit). You can then use the external format (which is usually longer than the internal) in these fields.

If you want to deactivate the conversion exit in general, remove the Use Conversion Exit selection. Here, enter the selections in an internal format too. The system then takes the two additional spaces, that would have been needed for the external format, away from the length of the input field..

Archive Selections

If you reload data from an archive file, select your archive file by using the pushbutton Archive Selection. For the time being, you can only load archive data within the BW.

Notes

·        If a DataSource field is assigned to the InfoObject 0LANGU, the field does not appear as a selection field in the Scheduler, despite being available for selection. In this case, the source system implicitly requests all languages from the language vector active in BW.

·        If time-dependent data is loaded, the time interval is determined in the scheduler in the update tab page. The DATETO and DATEFROM fields, as well as the fields that are assigned to the 0DATETO and 0DATEFROM InfoObjects, are therefore not available as selection fields on the Data Selection tab page.

·        In the selection criteria for the scheduler, only upper case letters are permitted. If you enter a value in lower case letters and confirm this entry, the value is converted into upper case letters. Also, you can only make selections according to lower case letters if you make the selection with the help of a routine