3239210 - Report "Supplier Details" Does Not Show All Suppliers

You have noticed that the Supplier Details report does not show the entire list of suppliers in the system.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Business ByDesign

First:

1. Go to the Business Analytics work center.
2. Access the Design Reports work center view.
3. Locate and open the Supplier Details standard report.
   
   
   
   
4. Execute the report with no filters.
5. Click the View button
6. Remove all Row Fields.
7. For the Column Fields, enable only the Key Figure "Counter"
   
   
   
   
8. Execute the report; count will show the number of total records in the report.
   
   

Now:

1. Go to the Supplier Base work center.
2. Access the Suppliers work center view.
3. Set the selection to All Suppliers.
4. Execute a query without setting any filters.
5. Click the scroll bar and hold; system will show the total number of suppliers and it is higher than the one shown in the report.
   
   

The data source BPSPPB - Supplier Details upon which this report is built was designed to provide "an overview of supplier master data, including the supplier name and ID and address data along with information that is required in the purchasing process, such as the purchase order currency, the Incoterms, the customer ID at the supplier, and the expected purchase order acknowledgement. In addition, the report also shows financial data, such as bank and tax data."

Hence, it only shows suppliers that have Financial/Payment Data maintained, which is why the number of suppliers shown in the report will be lower than the total number of suppliers in the system if there are suppliers with incomplete Financial/Payment Data.

System is working as designed.

If you need a report that shows all available suppliers in the system, you can create a custom report based on the SUPPLIER - Supplier Master Data data source. For more information on how to create reports, check the See Also section.

Working with Reports Using the Report Wizard, at SAP Help Portal.

KBA , AP-BP-ANA , Analytics , SRD-MD-BP-SUP , Suppliers , How To