1982957 - How the Show Master Data Value Selection affects the Report Content

SAP Knowledge Base Article - Public

1982957 - How the Show Master Data Value Selection affects the Report Content

Symptom

You have created a custom report and selected the option Show Master Data Value for a specific characteristics and would like to know how this selection affects the report content.

In this example, we use the Account Details report and the Sales Organization characteristic.

Reproducing the Issue

  1. You have created a copy of the Account Details report and called it XYZ.
  2. For the custom report (XYZ) you have selected the option Show Master Data Value for the Sales Organization characteristicas follow:
    • Report wizard then Characteristic Properties (Step 4)
    • Highlight Sales Organization characteristic
    • From the Details: Sales Organization select the Display tab and tick the Show Master Data Value box.
    • Save the report
  3. When you open the custom report (XYZ) and select a Sales Organization, for example 123, from the value help list, you notice that in some cases no data is associated to specific organizations while there is for others.
  4. If you perform the same steps with the standard report (Account Details) and search for the same Sales Organization (123) from the value help you are not able to find it on the list and add it to the report content.    
  5. When you check the details of the mentioned Sales Organization (123) in respect to the available Accounts you find out that are yet to be referenced to an Account.

Cause

The system behaviour is as designed.

Resolution

The reason why the Sales Organization characteristic, from the custom report (XYZ), shows Sales Organization even if no Sales data is associated to it is because with the Show Master Data Value Selection the report is modelled to display all master data values without any restriction; consequently the Sale Organization characteristic will get all the value available from the system, as per the Org Structures, irrespectively if the Sales Organization is used in the Account as part of Sales Data or not. On the other hand, the Sales Organization characteristic which doesn't have the Show Master Data Value selection ticked, like in the Account Details (standard report) it will restrict the Sales Organizations which are used in the Accounts as part of Sales Data.

Note: The above selection may also affect the result of the value help when similar characteristics are used from the Selection/Filter screen. for example Sales Organization and Functional Unit ID (Sales Organization) where the first will show a Sales Organization while the second won't.

Keywords

KBA , AP-PRO , Project Processing , How To

Product

SAP Business ByDesign all versions ; SAP Hybris Cloud for Customer all versions