Show TOC

SAPGetSourceInfoLocate this document in the navigation structure

This function returns an info field value for a data source. The info field label can be inserted using the SAPGetInfoLabel function. The property names correspond to the info field values that are available for data sources on the Information tab in the design panel.

The formula consists of 2 parameters and is made up of the following arguments:
  • Data Source

    Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel.

  • Property Name
    You can enter the following property names:
    • DataSourceName
    • LastDataUpdate
    • LastDataUpdateMaximum

      This property is related to MulitProviders. It returns the date of the last update of all InfoProviders in a MultiProvider.

      Example: A MultiProvider contains three InfoProviders. The date when all three InfoProviders were updated succesfully for the last time, is the LastDataUpdateMaximum.

    • KeyDate
    • QueryTechName
    • QueryCreatedBy
    • QueryLastChangedBy
    • QueryLastChangedAt
    • QueryLastRefreshedAt
    • InfoProviderTechName
    • InfoProviderName
    • System
    • LogonUser

Example

Cell D20: =SAPGetInfoLabel("DataSourceName")

Cell E20: =SAPGetSourceInfo("DS_1";"DataSourceName")

In cell D20, the Data Source Name label is displayed. In cell E20, the name of the data source with alias DS_1 is displayed, for example Sales Volume Europe.