Define Selections
Application component: Master Data
App type: Transactional
Description:  With this app, you define selections that consist of one or more filters for restricting the data range for relevant master data fields, for example, financial statement (FS) items, subitems, document types, and posting levels. 
Key features: This app provides the following key features: Create Selection When creating selections, you first enter a selection ID and a short description, and then set the filter fields in the Selection Expression section as follows:  In the Field column, select a master data type whose values you want to restrict. Depending on the master data type you select, value range, hierarchy node, or attribute can be used as a criterion. In the Operator column, first select Include or Exclude, then a comparison operator such as Equal to or Greater than. In the Value column, specify a value range, an attribute value or a hierarchy node depending on your choice in step 1.  Important Considerations   Using multiple filters for a same field: Multiple filters for a same field have an OR logic between each other, provided they all use the same Include or Exclude operator. However, if both Include and Exclude operators are used in different filters for the same field, the AND logic is applied. For example, the following selection expression restricts to the dataset whose document type ID is either within the scope of 00~1Z or equal to 2H, but excluding 0F:   Field Operator Value    ConsolidationDocumentType Incl.Between 00 And 1Z   ConsolidationDocumentType Incl.Equal to 2H   ConsolidationDocumentType Excl.Equal to 0F  The logic is shown more clearly if you choose the Selection Condition Details button to convert the filter conditions to SQL WHERE clauses: Sample Code WHERE ((CONSOLIDATIONDOCUMENTTYPE BETWEEN '00' AND '1Z' OR CONSOLIDATIONDOCUMENTTYPE = '2H') AND NOT (CONSOLIDATIONDOCUMENTTYPE = '0F'))This logic also applies if for a same field, you define filters using both value range and hierarchy node (and attribute for some fields such as FinancialStementmentItem). For example, the following selection expression restricts to the dataset whose consolidation unit ID is either under the unit hierarchy REGION/ASIA or equal to 1000, but not within the scope 2010~2200:  Field Operator Value    ConsolidationUnit.Hierarchy Node Incl.Equal to REGION/ASIA   ConsolidationUnit Incl.Equal to 1000   ConsolidationUnit Excl.Between 2010 And 2200   Using filters for different fields: Filters for different fields have an AND logic between each other. For example, the following selection expression restricts to the dataset that meets the both requirements: partner unit ID falls within the scope of 0~ZZZZZZ and subitem ID within 901~998:   Field Operator Value    PartnerConsolidationUnit Incl.Between 0 And ZZZZZZ   Subitem Incl.Between 901 And 998   Using hierarchy node: For the master data types that have hierarchies enabled and maintained, you can use Hierarchy Node to restrict their values. Some hierarchies, for example those for consolidation unit, profit center, and segment, have time dependency, meaning they are valid within the periods you specify in the Manage Global Hierarchies app. When defining a selection using Hierarchy Node for these master data types, you additionally need to specify a Valid From/To timeframe so that the system retrieves the corresponding hierarchy nodes. Note that when using the selection at run time, for example, when executing validation, reclassification, or currency translation, the selected hierarchy node selects master data in the hierarchy that is valid for the execution period/year. Using superordinate field: The following fields have superordinate fields:  Field Superordinate Field    FS Item Consolidation Chart of Accounts (COA)   General Ledger (G/L) Account Chart of Accounts   Cost Center/Partner Cost Center Controlling Area   Profit Center/Partner Profit Center Controlling Area  When defining filters using Hierarchy Node for a field that has a superordinate field, you need to specify the value for the superordinate field. However, the superordinate field value doesn't act as an additional filter criterion unless you explicitly add a filter row using the superordinate field in Selection Expression. For example, if you specify a hierarchy node for FS item by using FinancialStatementItem  Hierarchy Node, you are prompted to choose an FS item hierarchy node from a consolidation COA. If you choose the hierarchy Y1/BS in Consolidation COA/FS Item Hierarchy and then the node TAC000 (Current assets) underneath Y1/BS, the consolidation COA Y1 merely acts as a selection criterion for locating the right hierarchy node, but does not restrict the data for the whole selection expression. That is, the following selection expression doesn't restrict FS items to those only belong to consolidation COA Y1:    However, by explicitly adding a filter row using the ConsolidationChartOfAccounts superordinate field and the exact same consolidation COA value Y1, you restrict to the FS items that only belong to Y1. Using operator Between: Numeric and alphanumeric value ranges need to be defined in separate filter rows if you use the Between. For example, to include all 6-character FS items that start with 1, you need to define the following two filter rows:  FinancialStatementItem Between 100000 And 199999   FinancialStatementItem Between 10000A And 1ZZZZZ  Or you can simply use the operator Like, that is, FinancialStatementItem Like 1*.  Custom fields supported: When defining selections, you can also include custom fields that are created by using the Custom Fields and Logic app. The selections defined with custom fields are supported in reclassification and data validation settings and tasks. For more information about extensibility in Group Reporting, see Custom Field Extensibility for Group Journal.    Edit or Copy Selection You can make changes to existing selections or you can copy an existing selection to create a similar one with a new selection ID.  Activate or Deactivate Selection After a selection is created, you can choose to save the selection as a draft or an active version. For an active selection, you can choose to deactivate it as long as it's not being used in any configuration or settings, such as validation rules, breakdown categories, currency translation methods, and reclassification methods. A selection can have one of the following statuses: Draft: The selection is saved as a draft version. It cannot be used in any configuration or settings, and can be deleted.  Active: The selection is saved as an active version. It can be used in any relevant configuration and settings. Active selections cannot be deleted. Inactive: The selection was active and is now deactivated. Note that the selections that have been used in any configuration or settings cannot be set to inactive.  You can also choose Mass Activation to schedule background jobs to activate your selections in bulk immediately or at a later point in time.  Show Value List After editing a selection expression, you can view the filtered values by choosing Show Value List.  The value list displays the fields and their values, such as FS items, that meet the criteria you specified for the current selection. When the Show Details checkbox is selected, values are listed under Include and Exclude sections respectively by each master data type. When the checkbox is deselected, only the values that meet the defined filter conditions for each field are listed.  Note If a selection contains filters for hierarchy-type fields and the relevant hierarchies are time-dependent (such as consolidation unit hierarchy), you additionally need to specify a validity date so that the system retrieves the valid hierarchies.   Show Where-Used List For an active selection, you can choose Show Where-Used List in display mode. The list displays the IDs and descriptions of the currency translation methods, reclassification methods, validation rules, and breakdown categories that use the selection. 
Business roles: Group Accountant| External Auditor - Group Reporting| General Ledger Accountant - Group Reporting| Administrator - Group Reporting
General Ledger Accountant - Group Reporting : 
Ensures adherence of local data to group quality standards.

Administrator - Group Reporting : 
Performs business oriented parts of configuration, such as  master data maintenance, universal hierarchy maintenance, reporting items table, exchange rate, rule definition.

Consolidation Specialist : 
Is responsible for the Consolidation setting, processing for the FI or other business data from subsidiaries. Generates the legal & management consolidated reports.

External Auditor - Group Reporting : 
Ensures adherence of group data to legal accounting standard and process governance standards.

Group Accountant : 
Executes and monitors group processing tasks, such as data adjustment, and inter-company elimination.