Kontakt

Ansicht
Dokumentation

RTC_DEFSELECTIONS - Define Selections

RTC_DEFSELECTIONS - Define Selections

General Material Data   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

In this Customizing activity, you define selections to further filter data in a consolidation view.

A selection is a model-dependent object. With it, you can add filter conditions on the fields of a consolidation view. The filter conditions are then compiled into a SQL WHERE clause, which can be applied during running consolidation tasks.

The filter conditions can be either direct selection options or based on sets. You can also combine multiple selections into a composite selection to form a more complex filter option.

Selection in Currency Translation

In currency translation method definition, you can use selections for translation entries and rounding entries to select source data on fields like accounts, transition types, and other characteristics. In this way, you define reusable selections.

  1. Enter the model name and a name for your selection, and choose Create.
  2. In the dialog box, choose the type of selection you wish to create.
  3. Specify a base view on which the selection is to be made. Currently, only one base view is supported, i.e. the generated "_U" view.
  4. Add a description for the selection.
  5. In Filtertab, create filters by adding characteristic to be filtered and a filter expression. For example, you could create a filter for G/L account numbers within a specified range.
  6. Activate the selection to make it effective.

The Where String tab contains the SQL WHERE clause that is generated based on your created filters.

Note

  • When entering a filter expression, From is mandatory, while To is optional.
  • Expressions of different fields relate to the 'OR' operator.
  • In a single field, different from-to rows relate to the 'AND' operator.
  • For Boolean values in your selection expression, use ‘!’ for false, and ‘X’ for true.

Note

  • If you already have G/L accounting and subitem SETs, you can reuse these SETs as selection. In this case, you create selection with type "1 (based on SET)".






rdisp/max_wprun_time - Maximum work process run time   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 2590 Date: 20240523 Time: 185827     sap01-206 ( 41 ms )