*SELECT 
The special instruction *SELECT allows the user to retrieve a list of elements from a dimension and save it in a user-defined variable for later use anywhere else in the logic.
*SELECT ({variable}, {[What]}, {From dimension}, {Where})
Example
With the following instruction, the user can retrieve the ID of all members in the CURRENCY dimension where the property CURRENCY TYPE has the value R.
*SELECT(%CURRSET%, "[ID]", RPTCURRENCY, "[REPORTING]='Y'")*XDIM_MEMBERSET RPTCURRENCY = %CURRSET%
The *SELECT statement fills the variable %CURRSET% with the list of reporting currencies defined in the current application. The content of the resulting variable is then used in the XDIM_MEMBERSET statment.
The SELECT instruction is not specific to a given logic section, but it can be written once anywhere in the logic and used across multiple commit sections.
The SELECT statement is fairly limited, as it only supports the equal sign (=) , not equal to (<>) and cannot be used to combine multiple filter criteria with AND or OR keywords.
Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.