3245987 - Supplier Collaboration Data Report does not Return all the Suppliers

Supplier Collaboration Data Report does not Return all the Suppliers.

SAP Business Bydesign

1. Go to Supplier Base work center and go to Reports view.

2. Search for report ''Supplier Collaboration Data''.

3. Open the report and Click On Apply.

The data source(BUPASUPPLIERCOLLB01) behind report "Supplier Collaboration Data" is not suitable to find "not existing" collaboration data,

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), won't appear in the report.

For this requirement, we would recommend to create an own data source. You can do this as follows,

1.Go to Business Analytics work center

2.Under the data source view and select Design Data source view.

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

• data source SUPPLIER ("Supplier master data") joined to
• 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.

Create a Joined data source with "Supplier" from "Supplier Master Data" and "Supplier" from ''Supplier Collaboration Data''.

Supplier Collaboration, Report ,Supplier Master Data. , KBA , SRD-MD-BP-SUP , Suppliers , Problem