SAP Knowledge Base Article - Public

2052832 - No Data Displayed in the Profitability Reports

Symptom

The Profit Detail by Contribution Margin Scheme report or Profit Overview by Key Figure report doesn't display any data although there are financial postings relevant for selection parameters.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Cost and Revenue work center.
  2. Go to the Reports view, List subview.
  3. Select the report Profit Detail by Contribution Margin Scheme or Profit Overview by Key Figure.
  4. Enter the selection parameters and click Go.
  5. You get an information message that: No report data available to display; check selection for the report 'Profit detail by contribution margin scheme'.

Cause

The contribution margin scheme maintained in the Set of books specifies the structure of the Profit Detail by Contribution Margin Scheme report. SAP delivers templates for contribution margin schemes (structure type Income Statement by Function of Expense) as financial reporting structures for every template chart of accounts. You can copy a template and adapt it to your needs or create a contribution margin scheme from scratch. In the customized reporting structure, you have not maintained all the Fixed Structure Items.

Resolution

Find the Reporting Structure setup as the Contribution margin scheme in the Set of Books.

  • Go to the Business Configuration work center.
  • Go to the Implementation Projects view.
  • Select the fine tuning activity Settings for Earned Profit Analysis.
  • Select the link Edit Financial Reporting Structure.
  • Select the appropriate reporting structure and click Edit.

You need to assign all the fixed structure items in the Income Statement by Function of Expense reporting structure:

  • Operating Profit— displayed as Income From Operations.
  • Gross Profit— displayed as Gross Profit on Sales.
  • Net Revenue—displayed as Net Sales Revenues.
  • Gross Revenue— displayed as Sales Revenues.
  • Cost of Sales— displayed as Cost of Goods Sold.

Additionally assign the following fixed structure items to nodes of the contribution margin scheme:

  • Income Statement — add to the root node of the contribution margin scheme.
  • Income Statement Result— add to the node displaying the net income or net loss of the income statement.
  • Returns— add to the node displaying the sales returns.

Make sure that data exists for the selection parameters in the report. In case you are still unable to see any data in the report, then Report an case to SAP.

Kindly refer to the attached screenshot and refer to the help document "Settings for Earned Profit Analysis – Configuration Guide".

Function of Expense.png

Keywords

Contribution margin scheme; reporting structure; fixed structure item , KBA , profit detail report no data shown , profit overview , AP-ODP-ODR , Outbound Delivery Request , How To

Product

SAP Business ByDesign all versions