Information About the Origin of Data (SAP Library

Information About the Origin of Data

Use

This function provides you with important information regarding the current status and the origin of data in a data matrix, pivot table, or individual cell on a worksheet.

Features

Origin of Data in a Matrix

You can display and, if required, insert the following information into the worksheet at the cursor position:

The characteristics used in the matrix and their values
The logon user name with which data was imported
The database from which data was imported
The date on which report data was last refreshed
The scaling factor
Further technical information

The following functions are also available in the documentation dialog box:

Highlighting of cells blocked for data entry

The blocked cells are marked with a color.

Demarcation of the data matrix definition

The various elements in the matrix definition are highlighted on the worksheet.

The relevant cells are marked until you choose another function. However, you can print out a copy of the sheet with this information displayed before you continue.

Origin of Data in a Cell

You can display and, if required, print information about the parameters for the data in a cell. You may want to do this, for example, if you cannot establish the origin or data in a cell from the characteristic values that appear in the sheet.

If data has been calculated using an Excel formula, the formula is displayed.

Data that has been typed directly into the sheet is identified as a constant.

Activities

To display information about the origin of data, choose SAP ® Origin of data ® Current matrix or Cell.

Alternatively you can get information about the origin of data by using the context menu SAP ® Origin of Data.