SAP Knowledge Base Article - Public

1975471 - Example on how to Add Fields (Characteristic or Key Figure) to a report

Symptom

While working with report XYZ you want to know if additional fields, available from the respective data source, can be displayed to the desired report.

For this example, we will use the Material Inventories - Balance History report, which is based on the Material Ledger Account Aggregated data source, and will show how the following Characteristics and Key Figures can be added to it.

Characteristics

  • G/L Account
  • Material
  • Business Transaction Type

Key Figure

  • Valuation Quantity
  • Amount Company Currency

Resolution

In order to display the desired fields on the report you may use the Add Fields functionality which is available from the report menu.

In this case you open the Material Inventories - Balance History report, click Add Fields and depending of what field type you want to display you may choose the Characteristics or Key Figure tab and proceed as follow.

Select the Characteristics tab

  1. Depending on the field you would like to display select the respective Dimension.
    • For G/L Account choose Dimension: Accounting
    • For Material choose Dimension: Material Details
    • For Business Transaction Type choose Dimension: Journal Entry
  2. Tick the respective box depending on where you want to display the field. For example, Display in Report or Display in Selection Area.
  3. Click Ok and you'll see the following:
    • Display in Report: the characteristic attributes are then available from the Not Currently Shown list.
    • Display in Selection Area:  the characteristic attributes are then available from the Selection Screen.
  4. You can then drag them to rows or column and they will be displayed on the report.

 Select the Key Figure tab

  1. Expand the Key Figure list and select the Display in Report checkbox to make the key figures available from the Select Key Figures dialog box.
    • Valuation Quantity
    • Amount Company Currency
  2. Click Ok
  3. Select Settings button then Key Figure and will open the Key Figure Settings dialog box.
  4. Move the desired key figures (Valuation Quantity and Amount Company Currency) from Available to Selected and click OK.
  5. The Valuation Quantity and Amount Company Currency Key figure are now displayed on the Material Inventories - Balance History report.

Note:

  • Changes made by standard Users will be visible only to their own User.
  • Changes made by the Administrators via the Business analytics work center will be visible to all Users.
  • Changes made by the Administrators cannot be override by a Business User.

Keywords

KBA , AP-CI , Customer Invoice Processing , How To

Product

SAP Business ByDesign all versions