Show TOC

SAPListOfLocate this document in the navigation structure

This function returns a list of available objects for a specific object type. The list contains two columns for every entry (Alias and Description). For object type CROSSTABS, the function returns a list with three columns (Alias, Description and data source Alias).

This formula consists of 3 parameters and is made up of the following arguments:
  • Object Type
    You can enter the following object types:
    • DATASOURCES
    • CROSSTABS
    • PLANNINGFUNCTIONS
    • PLANNINGSEQUENCES
  • Search

    You can enter a search string. Note that the search is case sensitive. If you do not enter a search string, all available objects of the selected object type will be listed.

  • Search in

    You can search in ALIAS or DESCRIPTION. This parameter is optional. The default value is ALIAS.

Example

Cell G15: =SAPListOf("CROSSTABS";"Cross")

Starting in Cell G15, a list with three columns (crosstab Alias, crosstab Description, data source alias) is displayed with all crosstabs that contain the search string Cross in their Alias.