SAP Knowledge Base Article - Public

3273797 - Unable to Generate Full Report of Supplier Data hence want to identify which Suppliers are missing in report


Unable to generate full report of supplier data hence you want to identify which Suppliers are missing in report.


SAP Business ByDesign

Reproducing the Issue

To view Complete Supplier data follow below steps and you can find total Suppliers available.

  1. Go to Supplier Base work center and to Suppliers view
  2. Show: All Suppliers

To Fetch the Supplier report,you follow below steps and notice only few number of Suppliers displayed and not all

  1. Go to Supplier Base work center .
  2. Select Reports view
  3. Search for report 'Supplier Collaboration Data'
  4. Open it
  5. Click in Apply

The Report is not showing all suppliers.


Unfortunately the data source behind report "Supplier Collaboration Data" is not suitable to find "not existing" collaboration data.

The reason for that is, spoken from a database point of view, the data source uses existing collaboration data as an anchor and

then links supplier data to it.

As a consequence, if a supplier misses any collaboration data (such as output channel definitions), it won't appear at all in the report.


We would recommend to create an own data source.

You can do this by following below Steps

1. Go to Business Analytics WorkCenter View

2. Select Design Data Source .

3. Create a "New" Data source as an OUTER join from (for example)

  1. Data source SUPPLIER ("Supplier master data") joined to
  2. Data source "Supplier Collaboration Data".

The JOIN condition is that the "Supplier" in "Supplier Master Data" equals "Supplier" in "Supplier Collaboration Data".

You could then select any interesting fields (which should be filled in case of existing collaboration data) as view fields and

use this data source to find supplier with empty (i.e. non-existing) collaboration data.

See Also

missing output channel selections;unable to generate a full report , Showing less supplier data


KBA , missing output channel selections , unable to generate a full report , showing less supplier data , SRD-MD-BP-SUP , Suppliers , How To


SAP Business ByDesign all versions