Ask the SAP Financials Expert: Show the Correct Text in Report Painter/Writer Reports in the Drill-Down Level

  • by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software
  • July 15, 2005
Use a characteristic text variable to drill down in a cost center report and see the text that goes with the new cost center.

Dear SAP Financials Expert,

We are heavy users of Report Painter and Report Writer reports. Cost center reports are widely used in our organization. Many of our reports have selection criteria for cost center and cost center groups. For example, business users can choose the part of the organization for which they want to display overhead. Accordingly, the cost center group is a part of the selection criteria. Users can choose the range of cost centers or cost center groups and drill down to various levels using the variations functionality.

Within the report design, we have used report texts to display various selection parameters on the report header. That way we know with which parameters the report was executed. For our cost center reports, we have a text variable to show the cost center group the users entered.

The specific problem I have is: The report header shows the cost center group chosen at the time of report execution. However, as I just mentioned, many times we drill down to further levels for more analysis. The report totals for drilled-down levels are correct, but it still shows the text of the original cost center group. It does not show the cost center group of the current drill-down level. This is confusing to users, because the text is incorrect.

Is there a way to choose the cost center group dynamically, depending on the current level of drill-down?

—IT Manager, California

I am glad to know that you have been making good use of text variables. Not only do your reports look much more professional, but they are also more informative and useful. It is always a good idea to display basic information on the report, such as the name and description of the report, who ran it, run date, and other information about the selection parameters entered by the user.

Your question refers to the text variables used within Report Painter or Report Writer reports. So that I can explain the solution, let me demonstrate the situation with an example. Say you execute a report with selection criteria for a cost center group and your cost center group is as shown in Figure 1. Cost center groupMFG-GROUP consists of two subgroups, PLANT-1 and PLANT-2. Cost centers 1000, 2000, and 3000 are assigned to PLANT-1, whereas cost centers 7000, 8000, and 9000 are assigned to PLANT- 2.

Mitresh Kundalia

Mitresh Kundalia heads the SAP practice at Quality Systems & Software (www.QSandS.com). QS&S is a leading business and technology consulting firm that specializes in delivering superior IT solutions using SAP products. Mitresh is widely acknowledged as a leading SAP expert and has worked on various SAP assignments, including strategic planning, fresh implementations, upgrades, and post-go-live support projects. With an MBA degree in finance, Mitresh manages SAP projects with a special focus on customer-focused solutions, management reporting, profitability analysis, SAP General Ledger, and business intelligence. He is a regular contributor at SAP events and publications and technical advisor to leading journals.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.